[PHP-DB] php/mysql error

2004-07-27 Thread redhat
I am getting a weird error on one of my servers that says something about "query requires full tablescan". I was not getting this error until today that I noticed. I Googled for a minute and saw where a ton of other sites had the same problem but no "reason" why. I did find one board that said t

[PHP-DB] php/mysql error

2001-11-20 Thread jon
please review my script I have already had it said that the script is fine, please check. IF it is then I have a set up proiblem which I would also like help to solve. BUT mysql outside of apache works fine. I started with an already set up apache so I don't know if mysql was installed in r

Re: [PHP-DB] php/mysql error

2001-04-09 Thread Rasmus Lerdorf
Always check for errors on a mysql_query() call. Like so: $result = mysql_query($cd_qry); if(!$result) { echo mysql_errno().":".mysql_error(); } That should give you an idea. Usually this error happens when your query fails for some reason and thus it doesn't return any rows. When you the

[PHP-DB] php/mysql error

2001-04-09 Thread Liz Bander
This is the error that I've gotten since I switched servers a week-ish ago. No idea why, doesn't make any sense to me. I'm running MySQL 3.23 and the latest versions of Apache and PHP. We used the nusphere install. Warning: Supplied argument is not a valid MySQL result resource in /usr/loca