Can someone help me understand what “Resource id #7” refers to? My line #1 is simply <?php
Thanks!
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
Can you post some code?
I got it worked out. Thanks.
Could you tell us what it was?
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.
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.