Parse error: syntax error, unexpected ',' on line 10

saragoth

Getting this error when inserting a few items.. This worked on PHP 4 but I'm setting up under PHP 5 now. Here is a snippet of the code.. thanks in advanced

<?php
$con = mysql_connect("localhost","xxxx","xxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("facility", $con);

('$_POST[fac_date_month]',
'$_POST[fac_date_day]',
'$_POST[fac_date_year]',
'$_POST[fac_tech_name]',
'$_POST[fac_time]',
'$_POST[fac_ups1_kva_out]',
'$_POST[fac_ups1_phasebkw_out]',
'$_POST[fac_ups1_battery_time]',
'$_POST[fac_ups2_kva_out]',
'$_POST[fac_ups2_phasebkw_out]',
'$_POST[fac_ups2_battery_time]',
'$_POST[fac_notes]')";

bradgrafelman

Welcome to PHPBuilder!
When posting PHP code please use the board's [noparse]
[/noparse] bbcode tags as they make your code much easier to read and analyze.
If you're getting a parse error in PHP5, I'm about 99% sure you'll get a parse error in PHP4 (in general; with the code you posted, I'm 100% sure you'll get a parse error in any version of PHP).
The snippet you posted seems to be missing some code. After the call to mysql_select_db(), you have an opening parenthesis without any function name before it, and then at the end you have what looks like an ending double quote, yet there was no starting double quote.

Might want to go back and make sure you copied all of the code you meant to show us.

saragoth

Thank you for the heads up... I didn't want to drown everyone in code and I'm still fairly new so I wasn't sure.. Here is the code in it's entirety.

<?php
$con = mysql_connect("localhost","xxxx","xxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("facility", $con);

('$_POST[fac_date_month]',
'$_POST[fac_date_day]',
'$_POST[fac_date_year]',
'$_POST[fac_tech_name]',
'$_POST[fac_time]',
'$_POST[fac_ups1_kva_out]',
'$_POST[fac_ups1_phasebkw_out]',
'$_POST[fac_ups1_battery_time]',
'$_POST[fac_ups2_kva_out]',
'$_POST[fac_ups2_phasebkw_out]',
'$_POST[fac_ups2_battery_time]',
'$_POST[fac_notes]')";

$t = 'fac_trans_switch_dca';
$fac_trans_switch_dca_day = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_ups_dca';
$fac_ups_dca_day = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_server_alarms_dca';
$fac_server_alarms_dca = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_ac_leaks_dca';
$fac_ac_leaks_dca = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_trash_dca';
$fac_trash_dca = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_kitchen_dca';
$fac_kitchen_dca = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_doors_dca';
$fac_doors_dca = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_trash_dcb';
$fac_trash_dcb = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_lostitems_dcb';
$fac_lostitems_dcb = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_cables_dcb';
$fac_cables_dcb = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_leaks_dcb';
$fac_leaks_dcb = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_equipment_dcb';
$fac_equipment_dcb = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_console_dcb';
$fac_console_dcb = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_server_alarms_dcb';
$fac_server_alarms_dcb = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_ac_leaks_dcb';
$fac_ac_leaks_dcb = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_rear_door_dcb';
$fac_rear_door_dcb = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;
$t = 'fac_rear_alarm_dcb';
$fac_rear_alarm_dcb = array_key_exists( $t, $_POST ) && $_POST[$t] === 'true' ? 1 : 0;

$sql="INSERT INTO facility (fac_date_month, fac_date_day, fac_date_year, fac_tech_name, fac_time, fac_trans_switch_dca,  fac_ups_dca, fac_server_alarms_dca, fac_ac_leaks_dca, fac_trash_dca, fac_kitchen_dca, fac_doors_dca, fac_trash_dcb, fac_lostitems_dcb, fac_cables_dcb, fac_leaks_dcb, fac_equipment_dcb, fac_console_dcb, fac_server_alarms_dcb, fac_ac_leaks_dcb, fac_rear_door_dcb, fac_rear_alarm_dcb)

VALUES
( {$fac_date_month}, {$fac_date_day}, {$fac_date_year}, {$fac_tech_name}, {$fac_time}, {$fac_trans_switch_dca}, {$fac_ups_dca}, {$fac_server_alarms_dca}, {$fac_ac_leaks_dca}, {$fac_trash_dca}, {$fac_kitchen_dca}, {$fac_doors_dca}, {$fac_trash_dcb}, {$fac_lostitems_dcb}, {$fac_cables_dcb}, {$fac_leaks_dcb}, {$fac_equipment_dcb}, {$fac_console_dcb}, {$fac_server_alarms_dcb}, {$fac_ac_leaks_dcb}, {$fac_rear_door_dcb}, {$fac_rear_alarm_dcb} )";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con)
?>

bradgrafelman

You still have the same problem as I mentioned above. Looks like a call to mysql_query() got cut off or something.. perhaps it was a copy-and-paste gone wrong?

Not much we can suggest, other than rewrite the section that's missing some code.