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

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying

Could Someone Please Debug This?
I was wondering if someone could debug this script for me. I realize it's not the tidest script (and

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks

get multiple rows
Hi I want to get multiple rows from a db

I am using this for the db query
Code: public

Probably a simple error...
I'm getting the error -- Parse error: syntax error, unexpected '{' in /home/content/c/s/t/csteffen24

redirect standard error and assert (how to?)
How do you redirect standard error and assert?

---

(Why? I am creating an web app and

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

Read from forum
Haven't written anything forever and I would like to get back.
What I'm trying to do is getting t

What do you call the "token" thing?
You know how some sites have links that run on tokens? Tokens are links that only stay alive for a c

question about n
I was looking at some of the things you could do with php and one of the things I have tried is n.<

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