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

Consuming third party Payment Gateway API from Procedure.
Hi All,

First of all i would like to thank all the people of the oracle forum for providi

Refining of search Criteria
Dear Friends

I need a help, I have a search page which of cars related, which has different s

Putting double spaces instead of single spaces
Im looking at trying to replace all single spacing between fields with double spacing

At pres

If a record matches an existing record do nothing
So I don't know if I should put this here or in mysql, but what my script is for is for people to ad

Else statement screws up all css
Does anyone know what goes wrong in the process with this php code?
This code seems to be causing

max() problem
I have a while loop to get image names.
Code: $imagequery = mysql_query("SELECT * FROM ad_i

Grouping and sorting results
Please help with this query.

I have 2 tables in a database, countires and cities. states look

Reading waves
Hi,

I am trying to find a way of finding the highs and lows on a graph line, the line points

Database connection failure
Hello All,

I am trying to create new connection to Oracle DB 10.1,
I could not see a

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

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