In your implementation, using limit,

LIMIT <startpoint>,<# to retrieve> 

so you would want $name="2,1"

-Brenden


On Sun, 2002-04-21 at 17:05, Jule Slootbeek wrote:
> Hey guys,
> I have a, for you simple, newbie question.
> 
> my query is SELECT * from $TableName LIMIT $name
> 
> now $name goes from 1 to 4, the 4 rows in my database, but i just want the 
> query to give me one row, not say if $name is 2, rows 1 and 2, just row 2.
> How do i do this?
> thanks,
> 
> Jule
> -- 
> Jule Slootbeek
> [EMAIL PROTECTED]
> http://blindtheory.cjb.net
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to