foreach loop variable string

[Scooby08]

I have a foreach loop that I need the variable to be different if something is true.. This is hard to explain, but an example should work.. It's complete wrong, but should give the idea as to what I'm trying to do..

 

Have a simple loop:

<?php
// have a select query here to create the $event_ID_array
foreach ($events as $event) {
$x = (in_array($event['ID'],$event_ID_array))?'update':'insert';
$sql_$x .= $event['date'];
}
echo $sql_update;
echo $sql_insert;
?>

 

Am trying to collect the data in a string depending on whether that event exists in the database or not.

[trq]

Your much better off using arrays instead of variable variables (which is what your attempting).

 

<?php
$result = array();
foreach ($events as $event) {
  $x = (in_array($event['ID'],$event_ID_array))?'update':'insert';
  $result[$x] .= $event['date'];
}

echo $result['update'];
echo $result['insert'];

?>

[Scooby08]

YES!! That's just beautiful! Way better than what I was doing.. Works great!! Thanks again Thorpe!!