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

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

extending tidy
I have problem with type-hinting and extending tidy. This code creates error:
Code: class cMyTidy

Links not updating
I'm trying to fuel a simple navigation system for a news section. It works fine when it comes to ret

Cursor statement failed with errors
Following statement failed with the errors.

cursor proj_cursor1 is (select projectID from

ldap connection
We are using ldap to get user information from the domain controller. It was working before. Recentl

php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu

How to sum these output values
Hi

I need sum the month totals
SELECT region_name, area_name ,SUM (CASE WHEN S

Displaying data from MySql a different way
Hi all,
I'm pretty new to php and MySql and have hit a problem.

I am able to display data

System copy error in RUN ABAP REPORT PHASE
Hi,
I am performing system copy on my test server. I have previously taken export of JAVA + A

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