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

Why is my row count 0?
Here's the MySQL query i'm running. It basically pulls data from 2 tables based on some data passed.

Display Database
I need to create a shopping cart. I found this code online: http://conceptlogic.com/jcart/
Unfort

cookie problem
I hv a website url
In this site main menu functionality based on cookie when user click on parti

I got my hosting suspended XD
So I saw this challenge a day or so ago

http://www.programming-challenges.com/pg.php?page=dow

EXplanation help
Hey all,

I am still fairly new to PHP programming and I am trying to put together a page wher

Display search result
Hi!

I have a SQL database with information about albums and track (music).

This is wh

Transport data between itab and textfield on ALV event
Hallo,

I have a ALV Grid ( cl_gui_alv_grid ) and I also have hotspot click event with a h

Tournament Brackets (Double Elimination)?
Is making a double elimination tournament style bracket system capable of being done in php?

MASS PM
Hello all, I'm trying to send mass private messages to users in my database but keep getting an erro

Writing Windows Device Drivers with C
Yes: one of the nice features of C is void*. You can put anything there and get anything out. Very