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

96 Like 34 Dislike
Previous php-forum Next php-forum
Other php-forum

Sub-domains & calling unique content
Hello,

Is there a way use something similar to the $_GET function for a sub-domain? I to be a

understanding functions and classes
Code: [Select]
class person {
var $name = "Jimmy Goe";

function get_nam

Cloud Computing?
Hello,

I was wondering if anyone could help explain this term to me. I'm starting to hear it

grouping within a foreach?
hello all,

I currently have a list of products spit out from my db via a foreach loop. Right

timezone change with date()
so i put all my times for posts in my made from scratch forum(not phpbb3 or sm)
in my mysql db u

creating a 1 to 100 in a table
hi guys I am a newb in php need some help.

I have a table with 1 column and 100 rows and in

firefox wouldnt stream mp3 files completely from my php page
hi everyone,
I have a php file trying to read and stream mp3 files. It works fine in IE but my pr

switch not getting value
what am i doing wrong?
i want to populate the country list according to the category
i want to

RSS poster script?
I have found a script that posts RSS's for me on a site that I'm building. However I would like to a

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and

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