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
<*> 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/
