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

Pulling out some result data from MYSQL
Hey Guys,

I've built a PHP page that has a for just imagine something like registration form

Required to login help
I'm trying to set up my site so users have to be logged into the forum to access the site.I've been

Navigation include for all site directories
Hi,

I need a navigation include that can deal with directories at different levels on a site.

PHP Include w/If IE Condition Statement?
I was having a problem with Internet Exploder (big surprise, right?) displaying my drop down menus i

Sessions Value Not Saved
Hi,

Im making a login form and im using this code:
Code: if($login=="true"){

SAP FICO learning materials
Hi all,
I am new to this world of SAP FICO. I have taken training on SAP FICO, but was wonderin

Need help adding a timestamp to my filename/variable
Hello,

I'm kind of stupid when it comes to php and I need a tiny bit of help. I've got a f

HTML Email rec'd as Source Code
The code does create and send the email successfully. However, the message shows as html code and n

SESSION question
I am building an application , a directory for auctions.
For SEO i made a script which copies a p

IP Logger for Voting Script
Can anybody help me place an IP logger into my voting script?
I know that maybe it is not as secu