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
181 Like 51 Dislike
Previous forums Next forums
Other forums

Email Script does not reach destination
Hey Guys look at this code snippet :
Code:
//read a line from the file

$myFile = "

TimeZoneOffset
Hello,

Please i need your help. I have a system that users can use to punch in and out. This

Email logic not working
I would like to send an email using the php email() function then if it does execute i.e sends i wou

Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the

Must-Know Topics of PHP
Can you guys list the must-know topics of PHP. I am still a learner and I am trying to cover most of

PHP, jAVASCRIPT setting input values, why isn't it working?
Hi:

I am calling this javascript:
<script language="javascript">

Auto fill in input value based on User_ID
Hello,

I'm looking form some input on the following problem.

User loads page ->

$_FILES array
Ok,

I just started experimenting with PHP today. My goal right now is to have people be able

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

a multi dimensional array with for each
hi, I have been asked to write an array, I have Zone 2,3,4,5,6,7,8 each zone has 3 sections of weigh

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