Error with mysql limit query

Anon

Grasping for some answers here.

I have a website hosted that has mySQL and php4 installed. It also has phpMyAdmin.

My error:
I can not do a query with a limit function in it. It errors, but does not give an error message (its blank).

In the phpMyAdmin if I click on "browse" of a table it runs a query of "SELECT * FROM TableName LIMIT 0, 30" and pulls the first 30 records. I can not get this code to run for myself anywhere, not on a webpage, not even in the "Run SQL Query" in the phpMyAdmin.

If I do a query with "SELECT * FROM TableName" it works fine, I add "LIMIT 0, 30" and it says there is an error, but lists no reason.

Any one have any clues on this?

thanks,
-jeff

van__

You might want to try
"SELECT * FROM tablename LIMIT 0,30"
...note the lack of space between the 0, and 30. SQL can be picky on the exact formatting or your declarations and it's probably interpretting that as LIMIT 0 since immediately after the comma is a null value.
So in fact, there would be no error since it returned 0 rows, which IS what you asked it to do.

Anon

Yes I tried that.

I tried nearly every combination I could to get it to work.. I am new to using php and mysql, used to MS SQL, but it seems like this should work....

I tried with a space between the numbers
I tried with a leading 1 instead of 0
I tried with just a single number to get 10 records or whatever
I tried ever capitlization combination for the SELECT/Select/select, FROM/From/from, LIMIT/Limit/limit.. and even variations on my table name, though I know its proper.
I have over 500 records in there....

van__

Me thinks there is a bug in phpmyadmin, since I tried a query I know for a fact works becuase it runs as an automated process and has NEVER had a problem,
which was "SELECT * FROM portals LIMIT 0,3" and I got the same results you did in phpmyadmin. Knowing this query does ion fact work, I was not suprised when I entered it into my shells mysql moniter and it popped up no problem.

I recommend that you do your testing in PHP or your mysql moniter for those types of statements, and check out the phpmyadmin homepage for any bug fix on that.

Anon

Using Mysql 3.23.26 and phpMyAdmin 2.2.3 I am able to run that type of query no problem. I noticed that when using the "Run SQL Query" box, the system automagically places accent marks around the table name
so that when I type in ..
select * from table limit 0,30

the system returns
select * from table limit 0,30

I dunno if this is related or not, but I never noticed it before upgrading phpMyAdmin to 2.2.3.

Anon

I thought I had used the exact same query run from a webpage, but I was wrong. It did work elsewhere, but doesn't run in the phpMyAdmin.....

thanks for finding the error of my way!

-jeff