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

problem with query error
First Thanks to those who helped me on my previous posts, and the following code i'm using is not mi

Fetching array then reversing it
Hi, I have a simple problem, I'll try to explain it as best I can:
News entries in my database ar

How to show the difference between two data field in a database with php.
Hello php gurus,

how r u all... i'm not so well facing a typical problem please help me...<

Email Form Syantax Issue 2
How to make this look FROM:"OUR TEAM" instead of FROM:abc@mail.com

$headers = "

Kill a process
I have a question - how can I kill a process from a command line or by using Oracle SQL Developer? I

Date Question
I'm using the TIMESTAMP() function within mysql to set the date/time for certain events. However, ho

$variable $variables type question
I need to be able to designate an array element dynamically, so I thought to use a variable variable

Firefox displaying PHP source code??
Currently testing a site thats almost built, am going to be including php on a sidebar on all pages

2 decima places & How to reload my page
Hello There,

How do i put full-stop (.) after second figure from behind? ie if i have 123456

DataTable Help Required
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at vario