Re: [PHP] Managing Multiple Conditions in a MySQL Query

2001-05-02 Thread Mike Gifford
Thanks Tomasz, I believe that this will work just fine! :) Mike Tomasz Abramowicz wrote: > > echo "Recent Signatures\n"; > $query = "SELECT FirstName,LastName,CityState FROM phPetition WHERE > Public='yes' AND Verified='yes' ORDER BY ID DESC LIMIT 0,5"; > $result = mysql_query( $query ) >

Re: [PHP] Managing Multiple Conditions in a MySQL Query

2001-05-01 Thread Tomasz Abramowicz
Recent Signatures\n"; $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