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

Keeping track of php uploads
Hello all.

I was looking at the way PHP handles file uploads.
It seems that PHP uses a tem

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

I have a java application that periodically pings the d

HTML form problem
Ive made a form to that i want to send to my email via PHP. but when it send only the name's etc sen

Parse XML
Good day,

I use oempro software and try to parse XMLReturn but it's not working for me, simpl

Get relative path from absolute path
How would one go about getting the relative path to a file from its absolute path?

Parse multirow HTML table
Hello all,
I have a site I am working on. Its a sports site and I am trying to add stats to a DB

Passing PHP variables from one page to another
Hello-

I'm having trouble figuring out how to transport a variable from one php file to anoth

Not Inserting into DB
I can't get my Add new Division form to submit to the database. Anyone see my issue?

Code: &a

GMail like Chat in ASP.NET
Hi,Can anyone suggest me, how to incorporate GMail like chat in my existing ASP.Net application.I wa

Can I use a loop
Hi buddies!

Once again with my doubts here.

Right now I am using this sql stat