This query isn't limiting

[myfayt]

I am trying to get this query to work, and keep getting an error. If I remove LIMIT 10, it works fine, but how can I add the limit to it?

PHP Code:

$Qpost1 = mysql_query("SELECT * FROM posts WHERE id>'0' ORDER BY id DESC LIMIT 10");
while ($qrow2 = mysql_fetch_array($Qpost1)) {
  ?>
  <tr>
<td>
<?php echo "".$qrow2['title'].""; ?>
</td>
<td>
<?php echo "".$qrow2['category'].""; ?>
</td>
<td>
<?php echo "".$qrow2['location'].""; ?>
</td>
<td>
<?php echo "$".$qrow2['price'].""; ?>
</td>
</tr>

[Coyote6]

A little hard to tell without seeing what data you are trying to pull but why do you have the WHERE id>'0'... if your id is auto_incremented when would it not evaluate to true... seems like a waste of database resources... are you going in and changing the id to negative numbers or something? Also its recommended that you just select the specific fields you need from the database and not use *.

SELECT `title`, `category`, `location`, `price`
FROM `posts`
ORDER BY `id`
LIMIT 10

[myfayt]

I need it to start at the highest id (last inserted) and count 10 backwards to display.
But also if 10 doesn't exist and it's only 3, then it should only show 3.

[ShaneC]

While it shouldn't be strictly necessary, you may want to try LIMIT 0,10.

LIMIT Syntax: [LIMIT {[offset,] row_count | row_count OFFSET offset}]

If this doesn't correct your problem, please post the MySQL error you're receiving.