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

Session
I am having a little trouble with a session. Not sure if it is my browser or what. I know I do not

records between 2 dates
Hello all,

I have a date tracked table which contains effective_start_date and effective

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Drop Down and text box issue
Is it possible to set a drop down list and text boxes to a certain width?

here is my code

Credit card verification
I have a client who wants to process credit card transactions from his web site rather than the goin

how to get sn motherboard
Hello.
I want to get serial number motherboard, cpu and else hardware.
Can You show me sam

Working with Global Variables
hi, I'm not really sure why the following code is returning a "Call to a member function getBan

Xacute search within SQL results
I have a query that is pulling data, and I want to return a specific value from the results of that

how to export excel file in same server
My first post - php newbie, so appreciate your support.

I'm currently using headers to save w

get the country of visitor and display content based on that
Hello all,

I have seen that Google analytics can tell you where a visitor is coming from 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