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

Simple MySQL query...
Hello,
How could I do a mysql query that does this: SELECT * WHERE date/time < 5minutes ag

how to remove in php string display
My code is $message="We're looking at developing our website."; $body= "My mess

scandir clients directory
hi,
how can i scandir the clients directory? i need a script that when i click a button it will u

Why will this program not run if the variables are not global?
Hey guys I have a kind of perplexing situation that is probably simple, but I can't seem to understa

Probably Easy, Need help with Check Boxes in PHP Code
hello,

Thanks for looking this over and helping me out. My problem is I have a online store l

error checking breaking my code
Hi there, OK first of all, big apologies for what I assume is really fundamental errors in the struc

Blank record injected into database
I always found several blank records inside my database, although $SESSION is required to insert the

Is there a more efficient way to code this than what I have?
I have three associative arrays.

$combinedSettings
$userSettings
$defaultSettings

if else problem, help please
i have this script that i made only i try to also put in a if else for for some reason the script is

LSB (PHP 5.3) problem with static value!
hello,

i'm having a problem. static::$text variable gets lost at some point. can someone plea