[Resolved] MySQL Query Error: LIMIT & ORDER BY

ScubaKing22

Hi all I'm having a problem with the following query: $query="SELECT*FROM table WHERE field='field' LIMIT 0, 10 ORDERY BY id ASC";

Table, field, etc aren't the actual values, but I know they aren't the problem because when I take out LIMIT or ORDER BY it works fine. I'd tried switching the order, placing ORDER BY first. What order should all this be in? Thanks for any help.

tha_mink

I think limit comes after order by. so...

$query="SELECT*FROM table WHERE field='field' ORDER BY id ASC LIMIT 0, 10 ";

Plus if you only want the first ten rows you don't need to specify the offset. so...

$query="SELECT * FROM table WHERE field='field' ORDER BY id ASC LIMIT 10 ";

good luck

ScubaKing22

Actually thanks but I already tried switching the order or those two. Do you think it might have something to do with the WHERE?. BTW I just put in those random numbers.

kevinsequeira

what error are / problem are u getting - no results ??

reg
kevin

tha_mink

Both of the queries I posted should work fine if the values exist. (table and column names).

What error do you get?

ScubaKing22

LOL sorry guys I spelt ORDER as ORDERT. It was all just a typo.

kevinsequeira

:rolleyes: 😃