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

Need help with a mail notify function
I was tasked with setting up a site that's been prewritten. The site is basically a form that captur

Session
I am having a little trouble with a session. Not sure if it is my browser or what. I know I do not

get font info from a font file
hello,

Does anyone know how to get font info from a font file ... using php of course !
<

How would I protect......
I have a from, actually, a good amount of forms. How can I make it so you can't type the characters:

Strange HTML Tag?
I recently noticed some odd HTML appear in some of the websites I host. Not all of them are run on a

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to

mysql UPDATE request not working and driving me crazy!!!
Hi,

I have been stuck on this for ages.

Quite simply I am trying to update my database

Calling variables
I want to call this to my website but it doesn't display what I want it to,

Code: <h5&

OPINIONS WANTED
This is my login page code, and I want your opinion on it please!

Code: // Login ~ CHECKS

Comparing two dates
Hi Guys
I have two dates I want to compare. Below is my current implementation. The problem with