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

PHP error. Need help urgently
Hi,

I am programming a php site and have a problem that i just cant find out how to fix. When

filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I h

Unifying logins of two different scripts
I have two different game scripts which I want to embed on my own site. The problem is I don't want

Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d

tag inside php...
hi


Code: <?php
echo "<td width="$columnWidth%" align=&

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

Error when call dll from oracle
Hi all, please help me!

I have dll write C language, I want call it from oracle procedur

Transform value 0 in no and 1 in yes help needed
Hello,
I have this in the table: "value" type int 0 to represent false and 1 to represe

split string
Hi all

i have some names (imploded by comma):
Code: toronto,paris,madrid
Now, i would

problem with array - multilingual page
this is my test page :
Code: <?php
if(isset($_GET['lang'])) {
if($_GET['la

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