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

Timer control causing error
I recently decided to add a timer control to an existing page that uses AJAX on my site. As soon as

php title problem
Hi,

I am having a problem managing my page title with PHP.

Currently I have my <

LIMIT $start, 10... how to pass last value queried into next page with GET??
Ok I know how to display the first or last 10 results of a query...

$result = mysql_query(&q

Points for Wiki contribution
Hi everyone,

I want to know how long does it take for the moderator to award points for a

iterating through an array and escape each value independently.
I have a set up where the variable being escaped is an array and it needs to be iterated and escaped

IIS on 2003 anon access disabled issue
I have an IIS server that belongs to a domain, and anonymous access is turned off for all my sites.

Target costs on Process orders not calculating
Hi All,

We have released standard costs for all the materials. We have also done Goods r

function not returning the correct value
I have a program that needs to return a value from a function. I have an output statement inside the

Not sure why this script is not working?
Hi I am new to php programing and I was trying to make up a simple script like a captcha but I canno

DATEDIFF Question
First time post, and of course it is a help question.

I am using a WP plug-in to display prev