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

Inter Company -- Resources Related Billing (Services Industry)
Hello,

My company has a scenario where:
Company A bills Company C for INTER (cross

output_buffering so rewrite
I'm planning to rewrite some of my scripts so they don't have to use output buffering to accomplish

convert static html data into dynamic
hi all

i need to convert a website which has static above 2000 articles into dynamic and add

Deleting a record php
Attempting to setup delete a record page. The below code I put together doesn't seem to work.

mysql_real_escape_string
Let me preface this that I am very much a PHP noob, but I have some SQL training (not necessarily My

Form File Upload
I've read through tons of resources and tutorials and as far as I can tell, my code is accurate, but

How to make URL loads only on login
On my page, when a user login he's redirects to user_home.php. I made it also to open the chat scree

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

Problem related to Creation of PDF File?
Hi All,
I am facing a problem related to creation pdf file. when I am creating a pdf file of do

Custom array sort? asc then desc
Any ideas how I could sort this array? I've been trying for a while. Maybe with usort, but I have no