This is my query
$offers_with_limit = $db->query("
SELECT *
FROM `offers`
WHERE `countries` LIKE '%'?'%'
AND `category` = '$query2'
AND NOT EXISTS
(SELECT *
FROM completed
WHERE completed.offer_id = offers.id
AND completed.user = ?)
AND NOT EXISTS
(SELECT *
FROM pending
WHERE pending.offer_id = offers.id
AND pending.user = ?)
AND NOT EXISTS
(SELECT *
FROM ignored
WHERE ignored.offer_id = offers.id
AND ignored.user = ?)
AND `active` = '1'
AND `hard_incent` > '0'
ORDER BY `hard_incent` ASC,
`date_added` DESC LIMIT $startpoint,$limit
");
Obviously it is only going to show the rows that are greater than 0 but I also need it to continue to show the rows that are equal to 0 after the rows that are greater than if I don't add the hard_incent > '0'
then it shows the rows that are equal to 0 first because they are in ASC
order.