Solved: php+mysql help

nipunahasanka · Jan 1, 2011

hello.

I hv a database named lankavis_webs and there is a table named sl_hits. The fied are in the table like this,

id, song, artist, bitrate, dowload_url, views, downloads, lyrics, datetime.

There are about 1000 records in the data table.
I want to get output rows as last 25 record in 1.php and next 25-50 from last in 2.php and go ahead like it.
Already i have made fecth arry to display data . But i want to know how to select rows range like above.
Please help me.

TechGuy · Jan 1, 2011

Look up using "LIMIT" inside your SELECT like this:

SELECT * from sl_hits LIMIT 1,25;

SELECT * from sl_hits LIMIT 26,25;

SELECT * from sl_hits LIMIT 51,25;

etc

Note that the second number (25) is the number of results to return and would be 25 in your example.

It would probably be easier to create a single .php file and set a variable to increase that number rather than make a bunch of php files... Good luck!

nipunahasanka · Jan 3, 2011

TechGuy said: ↑

Look up using "LIMIT" inside your SELECT like this:

SELECT * from sl_hits LIMIT 1,25;

SELECT * from sl_hits LIMIT 26,25;

SELECT * from sl_hits LIMIT 51,25;

etc

Note that the second number (25) is the number of results to return and would be 25 in your example.

It would probably be easier to create a single .php file and set a variable to increase that number rather than make a bunch of php files... Good luck!
Click to expand...

Thanx tech guy
I have understand it.

Log in or Sign up

Solved: php+mysql help

nipunahasanka Thread Starter

TechGuy Administrator

nipunahasanka Thread Starter

Welcome to Tech Support Guy!

Log in or Sign up

Solved: php+mysql help

nipunahasanka Thread Starter

TechGuy Administrator

nipunahasanka Thread Starter

Welcome to Tech Support Guy!

Useful Searches