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
96 Like 34 Dislike
Previous forums Next forums
Other forums

Customizing message/behavior
Hi,I'm using the ASP.NET membership/authorization controls in my application. Some parts of my appli

Find occurences of unicode characters in string
I need to prohibit filenames with everything but English characters and numbers but regexp and strin

How to restrict the display of report variants
Hello All,

I want t know how to restrict the display of report variants.
I mean, whe

'grab_files', multiple extension?
hey guys,

can anyone suggest a way to make to following line of code look for files with more

i have no idea why this isn't working
Code: <?php
session_start();
include("connect.php");

error_reporting(E

Join Query Help
Hi all,

I am having problems with the below code, which we shall call 'my first join query'!

Question about GD library
I am trying to make an image that shows a random quote from my database.


However I want t

Ball movement
I want to move a ball from one point to another and it should hit a group of balls at the other end

Help! refer to a friend script with captcha code
Hi guys, I am posting on here in desperate need for some help with an ongoing search I have been doi

remove innitial

and

tags
i am using tiny_mce as a text editor for my CMS.
buy now the problem is it add <p>

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