[SOLVED] yet another mysql question

[TimUSA]

when i use this code:

// CONFIGURATION SECTION
$times = $_POST['boats'];
$x = 0;

if ($_POST['points'][$x] == "DNF")
$points = ($_POST['boats'] +1) * $_POST['factor'];

else if ($_POST['points'][$x] == "DNS")
$points = ($_POST['boats'] +1) * $_POST['factor'];

else
$points = $_POST['points'][$x] * $_POST['factor'];
///POST TO DATABASE
if (isset($_POST['submitted'])) {
if ($_POST['factor'] == "3")
while ($x < $times) {
mysql_query("INSERT INTO ladder_points (memberName, date, factor, racePoints, matchPoints) VALUES ('$_POST['name'][$x]','$_POST['date']','$_POST['factor']','$_POST['points'][$x]','$points')");
$x++;
}
else {
while ($x < $times) {
mysql_query("INSERT INTO ladder_points (memberName, date, factor, racePoints, fleetPoints) VALUES ('$_POST['name'][$x]','$_POST['date']','$_POST['factor']','$_POST['points'][$x]','$points')");
$x++;
}
}

 

i get this error:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/vskayc/public_html/Sources/Load.php(1773) : eval()'d code(209) : eval()'d code on line 17

[revraz]

And line 17 is?

[TimUSA]

mysql_query("INSERT INTO ladder_points (memberName, date, factor, racePoints, matchPoints) VALUES ('$_POST['name'][$x]','$_POST['date']','$_POST['factor']','$_POST['points'][$x]','$points')");

[TimUSA]

this is probably in the wrong section, can you please move to the mysql board?

[PHP_PhREEEk]

You probably just need back ticks around the field names, as I believe date would definitely be a reserved MySQL keyword.

 

<?php
mysql_query("INSERT INTO `ladder_points`
             (`memberName`, `date`, `factor`, `racePoints`, `matchPoints`)
              VALUES
             ('{$_POST['name'][$x]}','$_POST['date']','$_POST['factor']','{$_POST['points'][$x]}','$points')
             ");

 

PhREEEk

[revraz]

Which we already told him in his other thread

 

http://www.phpfreaks.com/forums/index.php/topic,174889.0.html

[TimUSA]

yes sorry....i had actually made the column name 'raceDate' and was just a typo:

my code now looks like this:

// CONFIGURATION SECTION
$times = $_POST['boats'];
$x = 0;

if ($_POST['points'][$x] == "DNF")
$points = ($_POST['boats'] +1) * $_POST['factor'];

else if ($_POST['points'][$x] == "DNS")
$points = ($_POST['boats'] +1) * $_POST['factor'];

else
$points = $_POST['points'][$x] * $_POST['factor'];
///POST TO DATABASE
if (isset($_POST['submitted'])) {
if ($_POST['factor'] == "3") {
while ($x < $times) {
mysql_query("INSERT INTO `ladder_points`
             (`memberName`, `raceDate`, `factor`, `racePoints`, `matchPoints`)
              VALUES
             ('{$_POST['name'][$x]}','$_POST['date']','$_POST['factor']','{$_POST['points'][$x]}','$points')
             ");
$x++;
}
} else {
while ($x < $times) {
mysql_query("INSERT INTO `ladder_points`
             (`memberName`, `raceDate`, `factor`, `racePoints`, `matchPoints`)
              VALUES
             ('{$_POST['name'][$x]}','$_POST['date']','$_POST['factor']','{$_POST['points'][$x]}','$points')
             ");
$x++;
}
}
}

 

and I am getting this:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/vskayc/public_html/Sources/Load.php(1773) : eval()'d code(209) : eval()'d code on line 20

 

sorry again...i didnt think this was a double post?