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

Apple's revamped lineup arrives

I'm personally curious about the magic mouse.. a multi-touch concept sounds like it could be nea

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

Open link with largest int string first
I have the following links i would like to open either all at once or one-by-one. How would i procee

Record count of entire database
Does anyone know if there is a way to obtain the number of records in each table of the database usi

need help about
i store the value of my select statement result to an array and stored it to a variable named $fname

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

All possible combinations of String in PL/SQL
Hi All,

Could you please explain the logic of getting all possible combinations of String

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

need help in update query
i create a form for update. there are 8 columns in my mysql table. on my main page all the data is r

Help With Showing Users On the Index Page
Ive got this code which works just how i want it to.

Code: <?
$timenow=time();

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