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

set xml path in flash when xml created in memorystream and webrequest
i am creating an xml file using memory stream and i want to load this xml file into the flash on cli

Delete all from a table
I can not get the following code to work. If I run the sql statement in the db it will delete all t

how to load a Sys file with system load and call images?
normally you need register the module as a service with CreateService, and start the service

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

Upload file and add HTML
Hey everyone,

I have a client has meeting agendas and minutes that should be posted online. I

Calander Basic Spript help
hi, just starting out with PHP and have the following script:

<?php
//This gets t

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

ok i need to join all this pages to make 1 neat code
i have 5 pages that make up my tv guide it works 100% but i want to make it 1 page if i can or 2, i

Deleting Partners on the Customer Master.
Does SAP handle removing the Partner from Open Sales Orders when a Partner is deleted in the Custome

Adding post count
How would I make it so everytime someone clicks submit on my form, their row in the database for the

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