Never mind this one.. :) I figured out that it
was because I'm using mysql_query, but declaring
the database which means that the mysql_query
command will fail and of course won't return a
mysql_error code. Geeez...
Another classic case of figuring out the problem
in the process of trying to explain it to a colleague.
I should 'pretend' to send a letter to php-general
next time :p
-greg
-----Original Message-----
From: Greg Schnippel [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 22, 2001 9:48 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Mysterious MYSQL Error..
I'm stumped on this one.. I set up PHP 4.04/Apache/Mysql 3.23
on my Windows 98 box for development purpouses. Its been
working flawlessly for 2-3 years now (using the same
configuration files, etc).
However, as of 3 days ago, i can't get it to execute a simple
"select * from table query". Here's the code I'm using:
$query = "select * from $this->table where $this->primary_key='$record_id'";
$result = mysql_query($this->database, $query);
echo mysql_errno().": ".mysql_error()."<BR>";
and the query that it sends to the mysql database is
"select * from article where article_id='1'";
However, mysql fails to execute the query. Result returns
nothing and the echo command returns:
errno: 0
mysql_error_text: ""
??!? I've tried everything to get it to display any more information
as to why its breaking but nothing works. I even uninstalled and
reinstalled all of the packages, thinking it had something to do
with a windows dll file or something annoying like that but no luck.
Any ideas? Anyone encountered a problem like this?
Thanks,
Greg
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
