Say I have the following query: $select = mysql_query("SELECT * FROM `quotes` ORDER BY `id` DESC LIMIT 32"); PHP: How could I make it so a) there's no limit b) it echos the values between and including 200 and 300. So for id 200, 201, 202 ... 300 i want it to echo them.
$select = mysql_query("SELECT id FROM `quotes` ORDER BY `id` DESC LIMIT 199, 100"); while($row = mysql_fetch_assoc($select)) { echo $row['id'].'<br>'; } PHP:
Because of $select = mysql_query("SELECT * FROM `quotes` WHERE id BETWEEN 200 AND 300 ORDER BY id ASC"); PHP: and continue with Danx10's code to echo it.