PHP Pagination Question - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

clifford · 08-04-2005, 08:39 PM

I have 2 numbers that I retreived using PHP. I want mySQL to select all rows that have ID's between 1-15 for example.

How would I go about doing this?

example :
First number : 1
Second number : 15

websitedatabases · 08-05-2005, 04:20 PM

Hi Clifford,

PHP Code:


		
			
SELECT * FROM table WHERE row_id > $low AND row_id < $high

Make sure you check to make sure the lower one is indeed $low and the higher one is $high.

Hope this helps