[RESOLVED] Code fails upon exit of foreach () loop, why?

ppowell

		  foreach (array($firstOrderByFieldIfClause, $groupByClause, $orderByClause) as $clause) {
		   $clause = substr($clause, 0, strrpos(trim($clause), ','));
		   if ($clause) $clause = ", $clause";
		  }
		  print_r("firstOrderByFieldIfClause = $firstOrderByFieldIfClause and groupByClause = $groupByClause and orderByClause = $orderByClause<P>");
		 }

This foreach loop will change each $clause, but upon exit all fields referenced by $clause revert back. I can't use reference pointers due to PHP syntax, so what on earth do I do?

Thanx
Phil

ppowell

Ok now I tried this and IT also failed!

		  $array = array($firstOrderByFieldIfClause, $groupByClause, $orderByClause);
		  array_walk($array, create_function('&$a', '$a = substr($a, 0, strrpos(trim($a), ",")); if ($a) $a = ", $a";'));
		  print_r("firstOrderByFieldIfClause = $firstOrderByFieldIfClause and groupByClause = $groupByClause and orderByClause = $orderByClause<P>");

This is madness!

devinemke

what excatly are you trying to do here? what are you expecting to happen?

ppowell

Very simple: shortcut coding version of changing the values of $firstOrderByFieldIfClause, $groupByClause and [$orderByClause possibly but not for now]

I think I got it, but it's not pretty:

		  if ($firstOrderByFieldIfClause && $groupByClause) {
		   $array = array(&$firstOrderByFieldIfClause, &$groupByClause);
		   @array_walk($array, create_function('&$a', '$a = substr($a, 0, strrpos(trim($a), ",")); if ($a) $a = ", $a";'));
		  }