RE: [PHP] Mysterious MYSQL Error..

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:schnippy@earthlink.net] Sent: Sunday, July 22, 2001 9:48 AM To: php-general@lists.php.net 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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net