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

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

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

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

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

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

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

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