Hi, just a quick question What does the 0,5 mean in the following statement: SELECT name FROM users ORDER BY date DESC LIMIT 0,5 PHP: I know it means show 5 only but why can't we just say LIMIT 5 (what is the 0 for - does it mean start counting from the very first row) thanks in advance
Yes you have got that right, syntax is like LIMIT $offset, $limit where $offset is the record you wanna start from for lets say 20 and $limit is the no of records it would show, lets say 10 so LIMIT 20, 10 would start listing records from id 20 and show 10 records. I hope this clears up.