Question about limit

[doubli]

If I wanted to limit a query so that it started at row 4 and showed all rows in that table whats the way to do that

I read somewhere LIMIT 4,-1 would do it but it didnt seem to work.

I know that if I did say LIMIT 4,10 that would show rows 4-10 but I need to show the remainder of the table if possible?

[scoates]

LIMIT 4,9999999999999999999999999999999999999999999999

?

S

[doubli]

Thats the only way? ?

[Sarah]

well I used

select * from mailing_list limit 4,-1; 

and it worked for me??

Version 4.1.1 of php, why do you say it doesn't seem to work?

I tried it directly in mysqladmin and using php and both worked?

my php code:

mysql_select_db("leaf_mail"); 
$sql = mysql_query("select * from mailing_list limit 4,-1");
while ($row=mysql_fetch_array($sql)) {
$id = $row["id"];
$name = $row["name"];
echo ("$id, $name");
} 

[doubli]

I thought it was my bad, but I since worked out I cant use LIMIT in a count(*) query

Heres the thread where i try to explain what i am doing

http://www.sitepointforums.com/showt...255#post386255