<?

echo "<p>Recent Signatures\n<br><em><UL>";
$query = "SELECT FirstName,LastName,CityState FROM phPetition WHERE
Public='yes' AND Verified='yes' ORDER BY ID DESC LIMIT 0,5";
$result =  mysql_query( $query )
    or die("never expect your query to work: $query");

while ( $row = mysql_fetch_array( $result ) ) {

    echo "<LI>" . stripslashes($row["FirstName"]) . " " .
stripslashes($row["LastName"]) . " from " . stripslashes($row["CityState"]);

}



-- 
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]

Reply via email to