Re: how do i construct a sql select statement, where i want to get the where clauses out of an array

You could try:

$statement = "SELECT id, size FROM table WHERE ";
for ($x = 0; $x < @id; $x++) {
  if ($x > 0) {
   $statement .= " || "; 
  }
  $statement .= "id = '$id[$x]'";
}
[download]

Update: fixed a typo

mr greywolf

Comment on Re: how do i construct a sql select statement, where i want to get the where clauses out of an array Download Code