Question:
How do you get data from database when you pick up item from database list?

Answer:
Here is a simple method for connecting to your MySql database and outputting some data.

<?php

#Connect to MySQL database
$db=mysql_connect("localhost","YourDatabaseUserName","YourDatabasePassword");
mysql_select_db("YourDatabaseName",$db) or die ("cant change");

#Select data from database table called customers.
$result = mysql_query("select * from customers Order By LastName, FirstName",$db);

while ($row = mysql_fetch_array($result))
{
$FirstName = $row["FirstName"];
$LastName = $row["LastName"];

echo "$LastName, $FirstName"; ?><br><?

}

?>

About the Author
Rich Agnew is an author for The Computer Geek Custom Web Page Design. The Computer Geek is a web design company that prides itself in professional service at a fraction of the cost. The Computer Geek specializes in Custom Web Design, PHP & MySql and Ecommerce.