Re: Managing Multiple Conditions in a MySQL Query
| From: | Tomasz Abramowicz | Date: | Wed, 02 May 2001 05:32:52 +0000 |
| Subject: | Re: Managing Multiple Conditions in a MySQL Query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-51082@lists.php.net to get a copy of this message | ||
<?
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"]);
}