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

No comments posted yet

Your Answer:

Login to answer
181 Like 51 Dislike
Previous forums Next forums
Other forums

Do not allow posting of whitespace
Currently the script below works if the user does not type a name/message, but if i create a whitesp

PHP and Javascript
Hi Guys,

Im trying to load the contents of an html file into a text area for editing, this is

Include a php
Hello,

I'm trying to include a function that shows the recent searches.
Example I have <

Calander layout
Hi i know this sounds like a simple question but i cant find the answer to it anywhere i have added

How would I protect......
I have a from, actually, a good amount of forms. How can I make it so you can't type the characters:

$variable $variables type question
I need to be able to designate an array element dynamically, so I thought to use a variable variable

Batch Session SM35 stuck in status 'in Background
Hi Experts,

I am facing a problem with Batch Input session SM35.

The batch se

shoping cart issues
i´ve wrote this and works when i add an item to, my cart, but when i want to add othrer item just

Using Microsoft Exchange Server with PHP
Hi,

I wanted to know if its possible to fetch email attachments from the exchange server usin

simplexml_load_file and rss problem
Hi,

I have a problem parsing an rss feed using simplexml_load_file - this is strange as i hav

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