The following code works fine locally (apache/php 4.3.4/ mysql 3) but not on my webserver (iis6/php 4.3.6/mysql4).
Everything else works fine both locally and on the webserver.
$query = "insert into orders values ('', '$customerID',
".$_SESSION['total_amount'].", '$date', '1', '$nameD',
'$companyD', '$addressD','$address2D','$townD',
'$countyD','$postcodeD','$countryD','$addInfo1')";
$result = mysql_query($query);
if (!$result)
return false;
The problem is with the $_SESSION variable because it works fine when I replace it with a number, but I don't understand why it works locally and not on the webserver?