Do you know if you've even made a valid database connection? Try
echoing $this->database as well. If that is null, you haven't
connected to your database; perhaps the username, password and or
permissions were changed, so that you're unable to connect from your
PHP program.
- steve
At 9:47 AM -0400 7/22/01, Greg Schnippel wrote:
>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
>
--
+------ Factoid: Of the 100 largest economies in the world, 51 are ------+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ |
+--- corporations ------ http://www.ips-dc.org/reports/top200text.htm ---+
--
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]
