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

Looping Problem
I've got a client that has a database with about 200 events at any given time. I'm trying to loop t

onclick problem
I have <input type="text" name="message">
<a href=page2.

limit string by words??
hello all,

I was wonder if there is a function to limit a string by the number of words inste

Why does this file not return file names that start with numbers?
This file returns a list of filenames to help populate a drop down in my form. For some reason it ig

multiple recipients + dbuser mail recall
Hello,

I am building a php login script.

When the user registers the script will send

mail()
Hi all. I have a problem with emails. I am trying to set up a mail system where customers can subscr

Multiple server callbacks (NOT POSTBACKS)
Hello, I have 2 different javascript client side functions that are on timers. When the timers elap

single values into sql field
i have a form which i want the user to able to select multiple answers. But i want the answers to be

help countdown timers
hello every one,

I'd like to know how to insert many countdowns in the same page.
The dura

cURL error
So here is my code... I got it off of here... http://www.youtube.com/watch?v=XcgQUsorF_8
Because