select - limit

[Anon]

I have a SQL query that works fine by itself. But when I try to put a "LIMIT 0,6" into it, it errors. Here is the code:

$sql ="SELECT catname,catsubname,catdir,num,altname FROM $table_name WHERE catname=\"$catname\" AND publish=\"Y\" LIMIT 0,6 ORDER BY catname ASC";

Without the "LIMIT 0,6" it works fine, but with it I get a "Couldn't execute query."

Any ideas?

[umbra]

Try this query, with the limit at the end of the query:
$sql ="SELECT catname,catsubname,catdir,num,altname FROM $table_name WHERE catname=\"$catname\" AND publish=\"Y\" ORDER BY catname ASC LIMIT 0,6 ";

[Anon]

Sorry, no luck with this one. I now get this error message:

Fatal error: Call to undefined function: () in /Library/WebServer/Documents/coupons/coups_cat2.php on line 1

I can do a limit from a program on my mac called MacSQL, so I know its not something with mySQL. It just doesn't seem to work from inside a PHP script.

[Anon]

That didn't work either. But, I have done a few tests.

I am using MacSQL to run sample queries on mySQL and have discovered there is nothing wrong with my SQL statement, other than having the limit before the order, which I corrected and it still didn't work.

I created a new simple php file, with a limit, and I got it working with no problem. So I have since, recreated my original file using the simple file. I recreated it piece by piece adding small chunks of code.

I have it working now. I am not really sure what caused the error. But starting fresh, and rebuilding seems to have solved the problem.

Thanks for the help.