RE: [PHP] Strange coding bug
| From: | Pat Hanna | Date: | Mon, 05 Jan 2004 22:30:12 +0000 |
| Subject: | RE: [PHP] Strange coding bug | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-173786@lists.php.net to get a copy of this message | ||
I think I've fixed it but in an odd way. Apparently I was getting error
1046: no database seleted. So I ran mysql_db_query and that worked. But
on the other pages I have, mysql_query always works. I have a function
called connect() that I run on every page:
function connect()
{
global $DB_SERVER, $DB_LOGIN, $DB_PASSWORD;
if (@mysql_pconnect($DB_SERVER, $DB_LOGIN, $DB_PASSWORD))
{
return 1;
}
else
header("Location: blahblahblah");
}
This should establish a permanent connection to the database server. Is
there a way to permanatly select a certain database?
Pat
-----Original Message-----
From: Jay Blanchard [mailto:jay.blanchard@niicommunications.com]
Sent: Monday, January 05, 2004 3:20 PM
To: Pat Hanna; php help
Subject: RE: [PHP] Strange coding bug
[snip]
$query="SELECT * FROM products WHERE stock_number = '$item_number'";
$result=mysql_query($query); $row=mysql_fetch_array($result);
When I do 'echo $result;' on the first page, I get the result number.
[/snip]
If you
echo $result;
with this code all you should get back is 'array' ($result is an array)
Do this
print_r($row) and see what happens.
P.S. Attachements are stripped on the way to the list usually, so post
the relevant small bits of code in your e-mail.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php