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

SAP Treasury - Commodities
We are running SAP ECC 6.0 with Treasury Activated.
EA-FIN is also activated (SFW5).

How to generate a random array of integers subject to a certain constraint
I am writing a program that asks the user to enter an integer N and then generates a random array of

path to include folder
Hi everyone,

When I'm testing locally, I have to add the name of the site folder as part of t

extract content from a website
i have written a code that will grab the content from the index page..
i would like to know how c

PHP mail() with images
I'm trying to get images to send along with my HTML e-mail sent through PHP mail(). I only tried vie

Ariba 9r - SAP MM Integration
Hi experts,

The standard Ariba adapter for 9r creates a relationship between Cost Centers

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

=> and <=
So I was digging through some code when I came across the <= operator. This is the first tim

ALV grid with 2 headers
Hi Gurus,

I need to display ALV GRID as below.

Header1

Pass sql into pl/sql and create RMAN duplicate script.
Hi,

I'm new to pl/sql and I'm trying to write a script that will generate some RMAN comma