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

Your Answer:

Login to answer

Other forums

Filtering for a phrase using pregmatch
Here is my code which looks for addresses which start with ' src=" '

Code: [Select]preg_

line breaks in between fetched file names
Hi,

I have this code:
Code: <?php
if($dir = opendir('files')){
while (($f

sql problems
I am having a small problem with my sql statement. it is inserting into 4 of the fields.

fie

multipart emiail forms
Hi All,

I am new to the boards and I've been working on a form (which is rather massive, imo

PHP code needed to get/post form fields and request mysql query results.
I'm new to PHP

I've created an html form to allow the user to request a basic telephone dire

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

Check premium expire
Hi,

I am making a simple file hosting site and want to check if users premium subscriptions h

retrieving more than one max key from an array?
so i have an array of 20 numerical values (0-100) that i need to order from highest to lowest and th

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

double and single quotes in text fields acting up... help please
Single quotes, when entered into a text field, create an sql error upon Submit. It seems to create t