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

User registration and login
I don't know whether this is the correct forum, if not i apologise but am pretty desperate at the mo

need good snippet manager
Hi. as i am coding and learning more, it is becoming difficult to manage code snippets. how you mana

Business Health Check
Hello

I need to create an online business health check for a client it will be multiple choi

query based on 2 conditions
I want to select if the doc_type is either s OR f but this doesn't work:

Code: [Select]$query

Help with search.php
Hello All

I need the search engine on a site I am building at the moment to display the searc

Performance impact of cookies
Hi, I was just wondering what impact there would be in terms of performance if you where to set then

string to currency format
Hi guys...

Actually I chunk out some data from txtfile and one of the data contains amount va

Help: calling function
Hi,
Is it possible to call a php function on page close?
If yes, could you explain how and whe

Multi Level Array Problem
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'

ORA-00932: inconsistent datatypes: expected - got CLOB
SO : windows xp
database : XE

there is a table (transito) with two fields of clob