[thelist] MySQL display on web w/ PHP

Brian Cummiskey Brian at hondaswap.com
Mon May 9 12:49:06 CDT 2005


Ken Moore wrote:
> Hello everyone,
> 
> I have done some PHP and some MySQL but I am very new at doing both 
> together.
> Assuming the following:
> 
> Database = “Sales”
> Table = “Orders”
> Name = “Jones”
> 
> When Jones’ page opens up, I need his order number and date of order to 
> appear on the screen in a table format. I keep getting syntax errors 
> with this.
> 


$db = mysql_connect($dbhost, $username, $password);
mysql_select_db("Sales", $db);

$sql = "select order_number, order_date from Orders where name = 'Jones'";

if (!$result = mysql_query($sql, $db)) die("<b>Sorry, We could not find 
this person</b>");
		
while ($r = mysql_fetch_array($result))
{
	echo "Order # " . $r['order_number'] . "<br />";
	echo "Date of Order: " . $r['order_date'] . "<br />";
}



More information about the thelist mailing list