RE: [PHP] while loop with if statement - here's the code
| From: | sgibbs at vt dot globalhealth dot org | Date: | Mon, 20 Aug 2001 15:02:34 +0000 |
| Subject: | RE: [PHP] while loop with if statement - here's the code | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-63517@lists.php.net to get a copy of this message | ||
Thanks Steve! :) Here's the code:
<?
$results = mysql_db_query("$db", "select * from $table where $query order
by update_datetime desc limit $offset, 10");
while($one = mysql_fetch_array($results)){
$id=$one["id"];
$title=$one["title"];
$description=$one["description"];
print "
<TR><TD VALIGN=TOP><img src=/assets/images/bullet.gif width=10
height=8></TD><TD><FONT FACE=VERDANA,ARIAL,HELVETICA,SANS-SERIF SIZE=2><A
HREF=/view_top.php3?id=$id>$title</A><BR>$description</TD></TR>\n
<TR><TD VALIGN=TOP COLSPAN=2><img src=/assets/images/spacer.gif
width=10 height=6></TD></TR>\n
";
};
if($results <= 0)
{
print "
<TR><TD><FONT FACE=VERDANA,ARIAL,HELVETICA,SANS-SERIF SIZE=2>NO
RESULTS</TD></TR>\n
<TR><TD VALIGN=TOP COLSPAN=2><img src=/assets/images/spacer.gif
width=10 height=6></TD></TR>\n
";
}
?>