Array used in a mySQL WHERE Statement

[marque]

I'm lost, and I now need help.

I have an array passed through a form from a multiple selection menu.

foreach($Suburb as $SuburbID)
	{
	echo"<b>Suburb:</b> $SuburbID<br>";
	}

This renders the data like so:

Suburb: 22
Suburb: 36
Suburb: 40
Suburb: 80

Thats all cool, the problem is I can't figure out how to put that in a mySQL statement.

$Query = "SELECT * FROM Properties WHERE
SuburbID = ?????????";

Please replace the ???????? with a logical solution. I'm a newbe to this kind of thing.

Ta.

Marc

[marque]

Ok I went the long way around and used

if(in_array($Property_row[SuburbID], $Suburb))

I would rather have this in the sql still, so if anyone can help...

please.

[Raistlin]

You could construct the query using or's like this

$Query = "SELECT * FROM Properties WHERE SuburbID = ".implode(" or SuburbID = ",$Suburb)."";

hope it helps in some way

Raistlin

[MrAlaska]

Here is one way to approach it, assuming your SuburbID has NO NULLs in it. Adding the NULL in the search stops the final comma from breaking the SQL.

$Query="select * from properties
	where SuburbID in (";
foreach($Suburb as $SuburbID){
    $Query.=" $SuburbID,";
}
$Query.=" NULL)";

EDIT: Actually, it would be slicker to have the final concatination be a string replacement of the final comma with a closing paren. Ah well, I suck at strings.

[frigidman]

To simplify that, and eliminate that rampant NULL:

if (is_array($Suburb)) {

$Query="
select *
from properties
where SuburbID in (".implode(',',$Suburb).")
";

}

[MrAlaska]

Originally posted by frigidman
To simplify that, and eliminate that rampant NULL:

if (is_array($Suburb)) {

$Query="
select *
from properties
where SuburbID in (".implode(',',$Suburb).")
";

}

This way is better than either of the ways I suggested.

[frigidman]

😃

[marque]

Cool,

Thank you very much for all your help, imploding works, and now I don't have a masive if statement outside the sql 😃