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

PHP Include not working
The website is http://www.grlistingservices.com

The code block is as follows:

<

Is there something wrong?
Hi all,

Just a quick question... can someone look at this code and see if something is wrong?

SAP Project Module
I have seen in the SAP Project Module,plan cost and budget are not equal and even difference is sign

Email/MMS to Site
Hey guys. I'm looking for a way for a user to upload images and/or text via their cell phones. It

script and html conflict in trying to create a header.
I have an error is occurring because of an html webpage with a "php require" at the top of

login box shows up again after logging in 2nd login works
Hello,

I am having trouble on my site Lockerz.rack111.com where when you login the login box

php include email form with attachment
I have had no luck with finding a email form all over the Internet for various reasons. Some insecur

Loops and Classes
I am making a template system and everything seems to be going well up until I have to loop in a var

php file erros / need help please
Hello

Someone decoded a zend file for me.. after uploaded it on ftp i get some errors, i trye

Basic Question Regarding PHP Includes
Hi

Just starting out with PHP.

Working on a site that uses some basic includes, these