next/previous problem

[micmac]

Hi all,
I'm currently working on a Next/Previous page script.
This is my query:

$result = mysql_query("SELECT * FROM cat1 WHERE CatParent = $id  AND active='yes' ORDER BY pref, CatName LIMIT " . $start . ", 20");

Within my database i have a field called 'confirm_cat'.
What i want to do is that if 'confirm_cat' has a value of 'yes' i want the LIMIT switched off but if the 'confirm_cat' doesn't equal 'yes' then i want it to do the above query. (ie. LIMIT 20)
I can easily do two queries but this does not solve the problem.

Any ideas on how to do this?

Cheers,
micmac

[Weedpacket]

Have you heard of the if statement??!

If you don't want a LIMIT clause, don't write one!