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

Passing Variables
What I'm wanting to do is when the user clicks on Arenas it will know the name of the country it's w

Unique Visitor Tracking
Hello. Currently, I run a voting site where voters are tracked by their IP address and can only vote

php/xmlrpc class issue
I am working on xml-rpc in php to start with.

I have a class that only has variables defined

reorder sql query
ok so i have this very simple code:
Code: $query = "SELECT search_keywords, COUNT(search_key

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

Why do I get this error
Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/a5488351/public_html/b

Parse String
I need to parse the string below into three variables. How would I do that?

john + 10/20/2008

send message to the java application
Oracle 10g with Windows platform.

I have a java application that periodically pings the d

Query failed issue with php script but works fine in mssql manager!
hi i have the script below which copies data from one table to another but will only insert new data

Time-based image rotation script
I'm trying to write a PHP script that rotates an image based on what time of day it is. I want the