How would I select all but the first 3 rows in my MySql query?
$query = mysql_query("SELECT * FROM comments WHERE approved = 1");
-
According to what criterion do you define "first"?phimuemue– phimuemue2010-07-07 05:35:53 +00:00Commented Jul 7, 2010 at 5:35
-
Well i'd like it to be work regardless of how I ordered or sorted it.ian– ian2010-07-07 05:38:32 +00:00Commented Jul 7, 2010 at 5:38
-
possible duplicate of Mysql Offset Infinite rowsFelix Kling– Felix Kling2010-07-07 05:40:29 +00:00Commented Jul 7, 2010 at 5:40
Add a comment
|
3 Answers
SELECT * FROM comments WHERE approved = 1 LIMIT 3,SOME_HUGE_NUMBER
Comments
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
}
}
Comments
$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");
1 Comment
Matthew Flaschen
This is all but the first 2.
