> mysql_select_db("$DBName");
> mysql_query("SELECT Date,BuyerID,OrderNumber FROM Buyers")
>
> How do I assign the variable to both of those lines that make
> up the DB
> call???
Unless you're planning to use several databases, you only have to use
mysql_select_db($DBName); once, normally where you connect to the
database.
In that way it can be cut down to:
$result = mysql_query("SELECT Date,BuyerID,OrderNumber FROM Buyers");
regards,
//andreas
http://phpwizard.dk (in Danish)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
