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

Oracle Text CTX_DOC.snippet slow
I have a table (FILE_TABLE) that contains a blob column (ft_file) and I have created the following O

A href problem under php
Hello...

I tried to explain the issue in an earlier post.. but was not clear enough....

Display Database
I need to create a shopping cart. I found this code online: http://conceptlogic.com/jcart/
Unfort

How to show next and prev records
Hi all,

Sorry if this is simple, i'm very new to php, well, any programming language actually

Ajax Error since Upgrading to 3.5
Ever since upgrading my site to .NET 3.5 (I needed LINQ), I've been getting this annoying error on o

help me, how to find text on an external html site using PHP
Would anyone know how to search an external html file for a work or phrase ?

I was thinking s

I need to increse 6hours more, and i don't know how???
I need to increse 6hours more, and i don't know how???
<tr>
<t

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

cursor proj_cursor1 is (select projectID from

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

Extracting URL pointer within XML tag
Hi.

I'm trying to extract text between two quotation marks in XML. For example, I want to ex