sql statement


$sql = "SELECT * FROM $table ORDER BY id
DESC LIMIT $page,$limit AND WHERE mainpic <> 'default.gif'";

Ok, so you can see what i'm trying to do, only mysql does not like it.

Any other suggestions?

Select elements go in this order:

SELECT
FROM
WHERE
GROUP BY
ORDER BY
LIMIT

SELECT *
FROM $table
WHERE mainpic <> 'default.gif'
ORDER BY id DESC
LIMIT $page,$limit

But that statemnet only pulls from the table where pic is not default.gif I ionly want to pull those first then pull the ones that are default.gif.

Any ideas?

you mean something like
[pre]SELECT *,
IF(mainpic = 'default.gif', 0, 1) AS orderby
FROM $table
ORDER BY orderby, id DESC
LIMIT $page,$limit
[/pre]

(it's up to you to test and modify it, I can't test it from here, but I used a very similar statement for a similar task recently.)

Thank you!

what does the 0, 1 mean?

The 0 and 1 are just values to ORDER the resulting rows on: