busboy — 2010-11-23T11:22:22-05:00 — #1
Can someone help me understand what "Resource id #7" refers to? My line #1 is simply <?php
A fatal MySQL error occured.
Query: select count(*) as total from testimonies where author = '17619' and approved = 'Yes'
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #7' at line 1
guido2004 — 2010-11-23T11:57:00-05:00 — #2
busboy — 2010-11-23T20:21:33-05:00 — #3
I got it worked out. Thanks.
guido2004 — 2010-11-24T03:17:30-05:00 — #4
Could you tell us what it was?
busboy — 2010-11-24T10:46:16-05:00 — #5
I was using a different way of executing the mysql. I looked around on some of my other pages and copied the way that I had used there. That did the trick. I don't know this stuff well enough to pinpoint why that original code was producing that weird message.
guelphdad — 2010-11-24T13:36:05-05:00 — #6
The error was PHP related and was because the OP tried to access the database output directly instead of through mysql_fetch_row/array etc.