How would I select all but the first 3 rows in my MySql query?
$query = mysql_query("SELECT * FROM comments WHERE approved = 1");
How would I select all but the first 3 rows in my MySql query?
$query = mysql_query("SELECT * FROM comments WHERE approved = 1");
Do you want the following:
$query = mysql_query("SELECT * FROM comments WHERE approved = 1");
$rowCount = 0;
while ($row = mysql_fetch_assoc($query)) {
$rowCount = $rowCount + 1;
// do stuff only if you have reached the third row.
if ($rowCount > 3){
// do stuff here
}
}
SELECT * FROM comments WHERE approved = 1 LIMIT 3,SOME_HUGE_NUMBER
$query = mysql_query("SELECT * FROM comments
WHERE approved = 1
ORDER BY columnName
LIMIT 3");
To find third record order by columnName use
$query = mysql_query("SELECT * FROM comments
WHERE approved = 1
ORDER BY columnName
LIMIT 2, 1");
To find All other than 1st 3 rows use LIMIT 2, total_no_of_rows
if you don't know total_no_of_rows use very large number instead of it.
$query = mysql_query("SELECT * FROM comments
WHERE approved = 1
ORDER BY columnName
LIMIT 2, total_no_of_rows");