Re: Managing Multiple Conditions in a MySQL Query

Thanks Tomasz, I believe that this will work just fine! :) Mike Tomasz Abramowicz wrote:

<? 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"]); }

-- Mike Gifford, OpenConcept Consulting, http://openconcept.ca Offering everything your organization needs for an effective web site. Featured Client: http://rabble.ca - News For the Rest of Us! Courage my friends, 'tis not too late to make a better world - T. Douglas