Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

php + MySQL question

Codes here !

Moderators: macek, egami, gesf

Postby DoppyNL » Wed Sep 18, 2002 2:24 am

in a mysql query you can use "LIMIT 0,5"at the end of the query to limit the number of results.

LIMIT 0,5 means: return 5 records starting from position 0

make a next-button in wich you transfer the current limit variables to the same page and change you're query that way. So by clicking next a couple of times you're query may look like "select * from table LIMIT 15, 5;"

Greetz Daan
DoppyNL
 


Return to mySQL & php coding

Who is online

Users browsing this forum: Google [Bot] and 3 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron