Mysterious MYSQL Error..
| From: | Greg Schnippel | Date: | Sun, 22 Jul 2001 13:47:55 +0000 |
| Subject: | Mysterious MYSQL Error.. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-59061@lists.php.net to get a copy of this message | ||
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