[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