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

Disable html within defined tags
I have a mysql database that allows users to enter content with html, but I also want to have a tag

PHP error. Need help urgently
Hi,

I am programming a php site and have a problem that i just cant find out how to fix. When

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names

a multi dimensional array with for each
hi, I have been asked to write an array, I have Zone 2,3,4,5,6,7,8 each zone has 3 sections of weigh

Help to integrate whois Domain Details to website
Hi,

can i know is their any php script r methods to add domain details to my website.

check comment for html
hi, I just wanted to check if a comment a user posts contains HTML, and if it does, to not allow it

Output Buffering question
Hi all,

I've been trying to wrap my head around output buffering. So far I've found tons of

Running a cron job through PHP/Apache?!
Hello all,
I have a PHP script which makes a cron file from user input. When i try to run the cro

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Embed Video Problem
Hey, thanks for looking!

File to be embedded:

Code: <playlist version="1&q