implode? explode?

[dadamssg87]

I had help writing the function below which takes an array and converts into "AND date = '$array_item'" for each item in the array. I'm trying to figure out how to change the function to output this instead: "AND date = date($array_item)". Anybody know how to do this?

 

<?php
function array_to_sql($array)
{
	$count = count($array);
   if($count == 1)
   {
	$one = $array['0'];
	return "AND date = '$one'";
   }else
   {
   $one = $array['0'];
   $shift = array_shift($array);
   return "AND date = '$one' AND date = '".implode("' AND date = '",$array)."'";
       }
}
?>

[braunshedd]

echo "AND date = " . date($array_item);

Is this what you're talking about?

[dadamssg87]

ehh i just used a foreach. don't know why the heck i was trying to use implode or explose. so much easier this way, except apparently my sql syntax isn't correct...on to the mysql board

 

<?php
function array_to_sql($array)
	{
		$first = $array['0'];
		$sql = "AND date = date($first) ";

		$shift = array_shift($array);
	   
		if(!empty($array))
		{	
			foreach($array as $key => $date)
			{
				$sql .= "AND date = date($date) ";
			}
		}

		return $sql;

	}
?>