RE: [PHP] while loop with if statement - here's the code

[sgibbs]

 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
        ";
        
        }

?>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]