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

How to show a complete textarea ??
I enter Client Case Notes notes in a textarea field on a PHP form. The field is 5 rows deep and 70 c

Applet JTextField Size Problem
Hello,

I recently started making an applet to calculate certain values for airplanes. However

Weekly Calendar
Hi, I am looking at creating a weekly calendar. The calendar will read from Monday - Sunday. Does an

DateTimeZone::listIdentifiers headache
http://php.net/manual/en/datetimezone.listidentifiers.php


So the documentation states tha

PHP arrays into arrays need help
Hello
I am trying to highlight the days on my calendar based on the dates that i have in my datab

Using loop to count number of entries
I'm writing a program that must ask user to type in numbers. After each entry, the program has to re

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

How to show next and prev records
Hi all,

Sorry if this is simple, i'm very new to php, well, any programming language actually

Stopping page post back
I have few literal contriols in my page and a repeater too. But inspite of using update panel, postb

getAlexaRank($url) function not working
I have made a function to get alexa rank
the site is here: http://mytestsite.rack111.com/1