add " OR name = '$name' " to query for each name in array

[cjhoward]

I have an array of states called $statesarray. What I need to do is add " OR state = '$state" to the mysql query for each state in the $statesarray. how do I do this?

[LordShryku]

You'd be better off using the "IN" operator. It's a shorter, faster way of doing the OR something=something multiple times. Try this.

$statesarray = array("AZ","CA","OR","MO","NY","IL");

/* SQL construction */
$sql = "SELECT *
        FROM table
        WHERE states IN (";

/* Now loop through the array, and add them to the SQL */
for($i=0;$i<count($statesarray);$i++) {
    if($i == 0) { //no comma on the first one
        $sql .= "'".$statesarray[$i]."'";
    }
    else {
        $sql .= ", '".$statesarray[$i]."'";
    }
}

/* Now close the IN statement */
$sql .= ")";

mysql_query($sql);

HTH

[drawmack]

Hey Lord ever head of implode?

$statesarray = array("AZ","CA","OR","MO","NY","IL");

/* SQL construction */
$sql  = "SELECT *\n";
$sql .= "       FROM table\n";
$sql .= "        WHERE states IN\n            ('";
$sql .= implode("','",$statesarray);
$sql .= "')";
mysql_query($sql);

[LordShryku]

I'm stuck in my ways. Quit following me.