php/mysql help ?

[jd2007]

1. How to select the first 6 rows in a mysql table ?

2. How to select rows 7-13 in a mysql table ?

3. How to refresh a php page ? what code to use ?

[Yesideez]

1.

SELECT rows FROM table LIMIT 6

 

2.

SELECT rows FROM table LIMIT 7,7

 

3. You can use a refresh header but if you've got output on the page already you'll get an error. The best way is to use a meta tag to refresh the page.