perky416

Hi JKG, Just out of curiosity, what benefits would it give me by just selecting the columns that i need rather than selecting everything? I have wondered about this before. Thanks mate.

Thanks guys i used the following: mysql_query("SELECT * FROM table ORDER BY date DESC LIMIT 10, 9999"); it didnt work with the brackets so i removed them and its perfect. thanks.

Hi everyone, I have the following query to select things from my database table. Im also trying to get it for ignore the first 10 results, so that it selects everything from row 11 onwards. mysql_query("SELECT * FROM table ORDER BY date DESC LIMIT 10"); Does anybody know how I would achieve this? Thanks