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

A little help needed passing hidden values to next page
I have a page that has hidden values in a form.

example
Code: <input name='signupID

This is driving me nuts!
This insert query looks to be alright, however I get this error:

QuoteYou have an error in yo

cPanel API
Hi Guys,

Need a little guidance. I'm trying to get my script to communicate with cPanel (or W

What's best way to get a user's Word doc converted to simple html and images?
Hi all,

I was just wondering if anybody has any experience of this.
Basically, I'm buildin

Form a inline view based on the results of the previous query?
Hi Experts,
Can we form a inline view on the results of a previous query (another inline view)?

How to give the privillege for triggers?
Hi,

How to give the privillage for triggers to particular user?

Please let me

Help with ORDER BY
Hello. I would like to order by ascending States, then Cities, then Gyms in the following code, but

am I using this for loop correctly
Dear buddies!

Right now I am generating a report with some details for all the dealers.

$get problem
Hi Guys ...

can you please tell me what i am doing wrong here
Code: <?php

Is there a more efficient way to code this than what I have?
I have three associative arrays.

$combinedSettings
$userSettings
$defaultSettings