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

Help With editting and deleting form
Hallo !!

So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.pn

Date/Time and Checkbox
Hi Everyone,

I am trying to figure out how to insert the current date and tim

records between 2 dates
Hello all,

I have a date tracked table which contains effective_start_date and effective

ALV List Display to point to another report on Double Click
Hi,

I want my ALV List Display to point to another report on Double Click on its line ite

division gives infinity anser
int main()
{
int z=0;
int i=1/z;
cout<
}

It doesn't throw a

Can I call a class inside a function?
I have a class written in another file that handles my image resizing.

Can I do this (php say

Help with looping
I have a comma separated list of colors taken from a database ($ICo) and a directory of images named

Beginner PHP code help
Hi I'm new to php but if someone could please read the question below and help it would be great.

Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and tim

PHP & Images [Resize, Crop, Save]
Hey! Well I have a little dilema, hoping I could find some guidance.

I have a CMS and on the