it uses > "higher" and < "lower" so it doesn't matter if the exact matching row exists.
----- Original Message ----- From: "Wade" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, April 18, 2005 11:07 PM Subject: Re: [php-list] Next & Previous Records > 04182005 1606 GMT-6 > > Patrick, question on this. Im thinking that this only will work when you > have consecutive numbering of application id's like, 1, 2, 3, 4, and so > on. What if you have deleted a number = 1, 4, 5, 8,9,10 = would this > still work? > > Wade > > > > Patrick Bierans wrote: > >> I think it's a wrapping thing. If reaching the end start from beginning. >> >> ----- Original Message ----- >> From: "Wade" <[EMAIL PROTECTED]> >> To: <[email protected]> >> Sent: Monday, April 18, 2005 10:57 PM >> Subject: [php-list] Next & Previous Records >> >> >> > 04182005 1551 GMT-6 >> > >> > I want to find the next and previous records in a list of records. I >> > did >> > a search and found this code: >> > >> > $q1 = "SELECT Max(clrId ) As prev from tblcolorpattern Where clrId < >> > $id"; >> > $res = mysql_query($q1); >> > if($res) >> > { >> > $num = mysql_num_rows($res); >> > if($num) >> > { >> > $prev = mysql_result($res,0,0); >> > } >> > } >> > >> > this code give me id before the current id in DB >> > >> > /************************************************/ >> > >> > $q2 = "SELECT Min(clrId ) As next from tblcolorpattern Where clrId > >> > $id"; >> > $res = mysql_query($q2); >> > if($res) >> > { >> > $num = mysql_num_rows($res); >> > if($num) >> > { >> > $next = mysql_result($res,0,0); >> > } >> > } >> > this code give me id after the current id in DB >> > >> > But Im a but unsure of it all so I would like some help with it. Im >> > going to change it to what I think I would write: >> > >> > $query = "$SELECT MAX(appid) AS prev FROM Application WHERE appid < >> > '".$appid."'"; >> > >> > $result = mysql_query($query); >> > >> > if($result) { >> > $num = mysql_num_rows($result); >> > >> > if($num) { >> > $next = mysql_result($result,0,0); >> > } >> > } >> > >> > Ok. Im selecting the next larger appid (application id) and assigning >> > it >> > to 'prev'. >> > >> > Then, im assigning the appid to $num. >> > I dont understand the next part at all = ($result,0,0); >> > >> > Wade >> > >> > >> > [Non-text portions of this message have been removed] >> > >> > >> > >> > Community email addresses: >> > Post message: [email protected] >> > Subscribe: [EMAIL PROTECTED] >> > Unsubscribe: [EMAIL PROTECTED] >> > List owner: [EMAIL PROTECTED] >> > >> > Shortcut URL to this page: >> > http://groups.yahoo.com/group/php-list >> > >> > >> > >> > >> -------------------------------------------------------------------------------- >> > Yahoo! Groups Links >> > >> > a.. To visit your group on the web, go to: >> > http://groups.yahoo.com/group/php-list/ >> > >> > b.. To unsubscribe from this group, send an email to: >> > [EMAIL PROTECTED] >> > >> > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of >> Service. >> > >> > >> >> >> >> Community email addresses: >> Post message: [email protected] >> Subscribe: [EMAIL PROTECTED] >> Unsubscribe: [EMAIL PROTECTED] >> List owner: [EMAIL PROTECTED] >> >> Shortcut URL to this page: >> http://groups.yahoo.com/group/php-list >> >> >> ------------------------------------------------------------------------ >> *Yahoo! Groups Links* >> >> * To visit your group on the web, go to: >> http://groups.yahoo.com/group/php-list/ >> >> * To unsubscribe from this group, send an email to: >> [EMAIL PROTECTED] >> <mailto:[EMAIL PROTECTED]> >> >> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of >> Service <http://docs.yahoo.com/info/terms/>. >> >> >>------------------------------------------------------------------------ >> >>No virus found in this incoming message. >>Checked by AVG Anti-Virus. >>Version: 7.0.308 / Virus Database: 266.9.16 - Release Date: 4/18/2005 >> >> > > > [Non-text portions of this message have been removed] > > > > Community email addresses: > Post message: [email protected] > Subscribe: [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > List owner: [EMAIL PROTECTED] > > Shortcut URL to this page: > http://groups.yahoo.com/group/php-list > > > > -------------------------------------------------------------------------------- > Yahoo! Groups Links > > a.. To visit your group on the web, go to: > http://groups.yahoo.com/group/php-list/ > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
