How do you get data from database when you pick up item from database list?
Published: July 9, 2009
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.