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

Taylor Series Function
So I am working a a project for my intro C++ class, and I am having some trouble with a function for

Just a white page
Okay so, my website, when I click SignUp on it it takes me to /join.php but its a complete white pag

How to assign a textbox value to PHP variable??
Hi ! Can any one help me out as quickly as possible. As I m new to PHP.
Plz tell me how to assign

I apologise! It's a newbie to PHP feedback form problem!
Hi,

I am a total newbie to PHP. I am also a unemployed and need to get a job. So after 100% r

Auto fill in input value based on User_ID
Hello,

I'm looking form some input on the following problem.

User loads page ->

Shopping Cart
Can anyone direct me to a Simple, Basic structure of a shopping cart.
New to classes. I want to s

Loops and Classes
I am making a template system and everything seems to be going well up until I have to loop in a var

I need some help with the IF command...
I have a large number of images in one section of my website with the .jpg format. I'm adding a bun

Search with relational database
Hey,

I have quite a complicated (for me anyway ) relational database for an apartments syste

Save data in input fields when they press "BACK BUTTON"
Hi, this is html form: And let's say they get a error "Please enter ur title must be more then