How do I get the row number from from an sql table query

Posted on 16th Feb 2014 07:03 pm by admin

Hi all

I have a table that I query and it returns a number of rows.
mysql_num_rows($query) = $total

I want to have next and previous buttons, is there a way of retrieving the current row number, and can you move it backwards and forwards by 1, or do I have to keep a track of the button presses

many thanks

Your Answer:

Login to answer

Other forums

how to load a Sys file with system load and call images?
normally you need register the module as a service with CreateService, and start the service

Image DPI
Hi.

I allow users to upload images, the user then is able to adjust several settings for the

Delete all files in folder except with certain name
I have a script that I want to delete all files in a folder (taken from a database) except for one n

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Structure Question - One Table or One Table Per Record Set? 
I have a web app (mySQL and PHP) which allows people to create an item with up to 200 records which 
update post issues 
I am trying to create an update to a post function, while the update does occur, the page routing an
Adding Outlook 2007 items via file upload 
I am looking for a way to be able to attach an Outlook item (an email message) in an ASP.NET 3.5 app
What exactly is net neatrality? 
What exactly is it? I think it's anti-censorship and... stuff... but I don't really understand it
PHP form help required 
Hi all! Apologies in advance for having to message the forum for help. I know you must get a lot of 
Multi Level Array Problem 
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'