Hey Thanks Petre Cheers... And a big brain fart
> -----Original Message----- > From: Petre Agenbag [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 02, 2003 6:17 AM > To: Joe Harman > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] MySQL get second row problem > > > Either limit your query to return only the second row ( look > in mysql manual for the limit caluse), or you will need to > move the array counter forward one for the $row_rsLastL = > mysql_fetch_assoc($rsLastL) operation.(php manual under array > functions) > > > On Thu, 2003-10-02 at 12:10, Joe Harman wrote: > > Hello... I am having just alittle trouble with this... I know it's > > simple... Look at my comment for the problem I am having > > > > <?php > > mysql_select_db($database_ideation, $ideation); > > $query_rsLastL = "SELECT * FROM logins WHERE user_id = > '$UserID' > > ORDER BY `date` DESC"; > > $rsLastL = mysql_query($query_rsLastL, $ideation) or > > die(mysql_error()); > > $row_rsLastL = mysql_fetch_assoc($rsLastL); > > $totalRows_rsLastL = mysql_num_rows($rsLastL); > > > > // Prints the first row... I just want to print just the second row > > echo $row_rsLastL['date']; > > > > mysql_free_result($rsLastL); > > ?> > > > > Thanks > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
