At 11:02 AM -0400 8/20/01, [EMAIL PROTECTED] wrote:
>
>
>$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
okay - read all the code now.
this might be a better way:
0)
{
for ($x=0;$x<$numrows;$x++)
{
$id=$one["id"];
$title=$one["title"];
$description=$one["description"];
print "
$title$description\n
\n
";
} // end of for
}
else
{
print "
NO
RESULTS\n
\n
";
}
?>
--
PHP Ge
try using mysql_num_rows() to get the number of rows returned by the query.
you need to supply it with the identifier for the query not the sql you sent
to the query. not exactly sure what you're trying to do though ...
Steve
<[EMAIL PROTECTED]> wrote in message
BB6D932A42D6D211B4AC0090274EBB1D2
Thanks Steve! :) Here's the code:
$title$description\n
\n
";
};
if($results <= 0)
{
print "
NO
RESULTS\n
\n
";
}
?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EM
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Sent: 8/20/01 10:25 AM
> Subject: [PHP] while loop with if statement
>
> I can't figure out why the if statement isn't working. The page
> displays
> the same with or without the
Here's the attachment - I hate it when I do that! :)
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/20/01 10:25 AM
Subject: [PHP] while loop with if statement
I can't figure out why the if statement isn't working. The page
displays
the same
I can't figure out why the if statement isn't working. The page displays
the same with or without the if statement. Any idea what I'm doing wrong?
I attached the code in a word document.
Thank you, Shawna
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTEC
7 matches
Mail list logo
