multiple conditions in SQL

scott212

I'm trying to search for matches in a database with more than one condition and getting errors. With a single condition it works fine. Here's the code:

$link = mysql_connect($host, $user, $password);

$query = "SELECT * FROM houses WHERE city='$city', mls_number='$mlsNumber'";
$result = mysql_db_query($DBName, $query, $link); 

while ($row = mysql_fetch_array($result)) {
	echo "<B>$row[mls_number]</B><BR>\n";
	echo "<B>$row[type]</B><BR>\n";
	echo "<B>$row[address]</B><BR>\n";
	echo "<B>$row[city]</B><BR>\n";
	echo "<B>$row[state]</B><BR><HR>\n";
}

scott212

nevermind ya'll. I got it! Inserting an 'and' between the conditions instead of the comma was all it was!
New code:

$link = mysql_connect($host, $user, $password); 

$query = "SELECT * FROM houses WHERE city='$city' and mls_number='$mlsNumber'"; 
$result = mysql_db_query($DBName, $query, $link);  

while ($row = mysql_fetch_array($result)) { 
    echo "<B>$row[mls_number]</B><BR>\n"; 
    echo "<B>$row[type]</B><BR>\n"; 
    echo "<B>$row[address]</B><BR>\n"; 
    echo "<B>$row[city]</B><BR>\n"; 
    echo "<B>$row[state]</B><BR><HR>\n"; 
}

pjleonhardt

yup, that'll get ya where you want to be..
please click the 'resolved' link at the bottom of the thread

scott212

well, it's not totally resolved. Both $city and $mlsNumber are not mandatory and when a user doesn't input both it looks for no value in the column. What's the usual course of action when trying to validate multiple optional conditions???? Is there some kind of and/or wildcard or something?