PHP date_format upgrade problem

Hi,

I am transfering an application from one server to another (Windows) and in the process moving from PHP 4.3.9 to 5.3.6. I have a script which displays stats in a table format, however I'm have problems with two functions that use date_format. Please see the attached code.

When this code is run the following error is displayed:

Fatal error: Cannot redeclare date_format() in C:\Inetpub\wwwroot\cpark\reports\transaction_stats.php on line 4

So I have determined that I can't use "date_format" as a function name. When I change the name to dateFormat in the first function:

function dateFormat($field, $fmt)
{
      return (isSet($fmt)? "dateFormat($field, '$fmt')" : $field);
}

The following is displayed:

Warning: date_format() expects parameter 1 to be DateTime, string given in C:\Inetpub\wwwroot\cpark\reports\transaction_stats.php on line 14 Warning: date_format() expects parameter 1 to be DateTime, string given in C:\Inetpub\wwwroot\cpark\reports\transaction_stats.php on line 15 Warning: date_format() expects parameter 1 to be DateTime, string given in C:\Inetpub\wwwroot\cpark\reports\transaction_stats.php on line 16

FUNCTION 'db_query': select as dt, as sh, count(*) as ct from booking_pool where 1 and >subdate(curdate(), interval 14 day)group by - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as dt, as sh, count(*) as ct from booking_pool where 1 and >subdate(curdate(),' at line 1

As the second function is calling the first:

$group = date_format($details['FIELD'], $group_fmt);

If I change this the read:

$group = dateFormat($details['FIELD'], $group_fmt);

The following is displayed:

FUNCTION 'db_query': select dateFormat(timestamp, '%Y-%m-%d') as dt, dateFormat(timestamp, '%a
%d
%b') as sh, count(*) as ct from booking_pool where 1 and dateFormat(timestamp, '%Y-%m-%d') >subdate(curdate(), interval 14 day)group by dateFormat(timestamp, '%Y-%m-%d') - FUNCTION cpark.dateFormat does not exist

Any help would be greatly appreciated.

function date_format($field, $fmt)
{
	return (isSet($fmt)? "date_format($field, '$fmt')" : $field);
}

// Do various counts
function do_counts($sql_counts, $group_fmt, $show_fmt, $where_fmt, $criteria)
{
	$stats = array();

	// Do SQL Counts
	foreach ( $sql_counts as $tag => $details ) {
		if ( isSet($details['SQL']) ) {
			$group = date_format($details['FIELD'], $group_fmt);
			$show = date_format($details['FIELD'], $show_fmt);
			$where = date_format($details['FIELD'], $where_fmt);

			$sql_query = "select $group as dt, $show as sh, count(*) as ct from " . $details['SQL'] . " " . 
				(isSet($criteria)? "and $where $criteria": "") . "group by $group";
			$result = db_query($sql_query);
			while($row = mysql_fetch_array($result))
			{
				$stats[$row['dt']]['sh'] = $row['sh'];
				$stats[$row['dt']][$tag] = $row['ct'];
			}
		}
	}

	// Do any derived functions
	foreach ( $sql_counts as $tag => $details ) {
		if ( isSet($details['FUNC']) ) {
			$func = $details['FUNC'];
			$stats = $func($stats);
		}
	}

	return $stats;
}

Select allOpen in new window