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
Did you know?Explore Trending and Topic pages for more stories like this.

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
No comments posted yet

Your Answer:

Login to answer
181 Like 51 Dislike
Previous forums Next forums
Other forums

Hits this week counter
I have a counter on my site that tracks hits, IP's, etc. into a mySQL database. It also includes the

extract data
Code: <div class="post hentry uncustomized-post-template">

php - xml what is the best way to do this.
IN essence I want to have a script calling the info from the database.. I have no problem thus far,

pull content
I have an existing page, domain/adverts.php which has a good PR. I've just rebuilt my site and the n

Adding post count
How would I make it so everytime someone clicks submit on my form, their row in the database for the

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

PHP friend keyword equivalent
is there a PHP equivalent for the C++ friend keyword?

Help with forum quoting?
Hi im working on a forum and I have alomost finished it but i want a user quote system like twitter

Java API in PHP?
I have an application that we use internally here at the office.

The software company provide

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

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash