How do you retrive the particular data from data base?

Answer 1

Code below assumes you have the connection, database and table working:

<?php

mysql_select_db("db_name");

$select = mysql_query("SELECT Name FROM table_name"); // Fetch a column

while($col=mysql_fetch_array($select))

{

echo "Name is ".$col['fname']; // Assumes table has a column by name 'fname'

}

?>

<?php

$name $_POST['name'] // Getting form value

// For fetching a row you need to use the 'WHERE' clause

$select = mysql_query("SELECT * FROM table_name WHERE Name='$name'");

while($row=mysql_fetch_row($select))

{

echo $row['Name']; // Prints name

echo $row['Surname']; // Prints surname

}

?>