[Resolved] Can't get the LIMIT clause to work

dwilson

I cannot seem to get the LIMIT clause to work for me

$sql = "SELECT * from visa ORDER BY account _number ASC LIMIT 1,10";

I get an error (You have an error in your SQL syntax near 'LIMIT 0,1' at line 1)
Does it only work with a certain version of mysql and beyond. Does anybody know what I'm doing wrong

batman

What are you trying to limit by; the 1 or the 10?

dwilson

What I was trying to accomplish was 1 record per page, what my ultimate goal is I'm trying to write a application for my engineering department, it tracks enginnering change notices, they want to see basically a form and have the fields filled in from a database, but they only want to see 1 record a time, and have a navigation bar(First, Next, Previous, Last).

Seems how I'm fairly new to PHP I figured the only way to accomplish this was to use the LIMIT clause. If you have any better ideas please let me know

Thanks

batman

Since you are wanting one per page, then it will be:

$sql = "SELECT * from visa ORDER BY account _number ASC LIMIT 1";

As for the Next and Previous stuff you will have to have a pagination script for that. Do a search, up at the top, for pagination.

philipolson

Are you sure you want account number instead of account_number? Note the space before the , I doubt you meant that. If you did mean that then you need to seperate ordered columns with a , and not a space.

dwilson

Thanks for your help

batman

Did it help you? Cause if it didnt we are more than happy to keep helping. If it did help then please mark this thread resolved, by clicking on the "Mark thread as resolved" button down below.

dwilson

Yes it did thanks again, and I will mark it resolved