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

Error In Syntax
I got this error:

Code: Parse error: syntax error, unexpected '>' in /home/bucket/publ

Form errors in an array
I'm processing a form and putting the errors in an array. empty($errors) doesn't seem to do the tric

mysql query with single quotes in a variable
$sitedetails = "INSERT INTO vars (address, sitename, description, ownername, theme) VALUES ('$u

Needing Youtube thumb nail fix.
I have a script on a site that pulls in you-tube videos,
The problem is, that the thumb nails for

Need help with basic sql
Hi,

I am using oracle 10g, and having some small doubts related to sql , here goes the si

Internal Server Error issues
This has been bothering me for weeks and I've been trying to solve it without asking for help, but e

Variables and Include
Code: [Select]<?php

$header = $_COOKIE['mss']['header'];
$body = $_COOKIE['mss']['b

Help with captcha script needed
Hello,

I am working on a script where reCAPTCHA or a similar form of CAPTCHA will be used, f

switch form actions? not working
i want on submit to go to different pages according to the CatID

Code: <?php $CatID=$_

Problem with passing variables
I'm not really a php programmer so I'm really struggling with this issue.

I have a banner s