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

php or sql?
Sorry not sure if this is a sql problem or php the following code is supposed to delete data from th

order by date not ID number help php
I am trying to orginize the following code to order by date not id number.
any help would be grea

Insert to MySQL inside foreach
Hey.
I am parsing some html, and putting inside an html db.
I need to create a randomized inte

Agency Business Process
Hi,

I don’t understand the process of the agency business in SAP.

In my

what are '%S%', '%E%'
for example when i see Code: [Select]printf("Hello %srn", $name);
what does %s means

how to configure ADS in ABAP instance
Hi All,

I am working on r/3 4.7 ABAP system.Can we configure ADS(adobe document services)

Automatic Webpage ??
I have a page www.mysite.com/test.php with a
<form>
<textarea name=&q

Load file in PHP
I have 2 files. The first is a PHP generated XML file that's dependent by 2 inputs. The second is a

Shuffle Array
Hi,

I am writing a script for a game that needs players to randomly be assigned a target (ano

Points for Wiki contribution
Hi everyone,

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