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

Including calander to page - will not show other months than current??
im trying to add an existaing calander onto a profile page by using Code: <?php include "

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I

Whats wrong with my query?
I am trying to get this query to show the appropriate ticked vehicle roof height, unless no boxs are

upload form file types....
Hey all, I am learning PHP and I am writing a script from the W3C Schools tutorials for uploading fi

Querying info from one table based on info in another
Hi, I am currently trying to make a part for my user driven website where one user can subscribe to

php problem?
I don't think I'm stupid, but maybe I am.

I am working on a sit for a friend I am try to put

On page view, minus credit
Hello all, please, I need a little help with this script. I am charging one credit (credits can be p

pspell
using pspell, is it possible to get words that would be best in the current phrase?

For examp

I am stumped
OK. Here is what I am trying to do. I have the conditions set, and if the conditions are met, I want

Intrastat Report Config in ECC 6.0 - goods Movement in EU countries
Colleagues, need ur help to understand the changes require in ECC 6 standard Report configuration se