Parse error

Senior WebHelper Joined: 21 Apr 2003 Posts: 153

Can someone please tell me the parse error on line 13

Code:

<?php
$player = $_POST[player]; $game = $_POST[game];
$ab = $_POST[ab];
$sng = $_POST[sng];
$dbl = $_POST[dbl];
$tpl = $_POST[tpl];
$hr = $_POST[hr];
$wlk = $_POST[wlk];
$stk = $_POST[stk];
$hbp = $_POST[hbp];
$scf = $_POST[scf];
mysql_select_db("",mysql_connect("localhost","",""));
$sql = "UPDATE {$player}_Stats SET ab = $ab, sng = $sng, dbl = $dbl, tpl = $tpl, hr = $hr, wlk = $wlk, stk = $stk, hbp = $hbp, scf = $scf WHERE id = $game");
$result = mysql_query($sql)
or die("Invalid query: " . mysql_error());
?>

Team Member Joined: 06 Jan 2002 Posts: 2564

Shouldn't {$player} be $player?

Posted: Sun Apr 27, 2003 8:08 pm (20 years, 11 months ago)

Code:

$sql = "UPDATE ".$player."_Stats SET ab = $ab, sng = $sng, dbl = $dbl, tpl = $tpl, hr = $hr, wlk = $wlk, stk = $stk, hbp = $hbp, scf = $scf WHERE id = $game");

Senior WebHelper Joined: 21 Apr 2003 Posts: 153

I had to edit it a little, but I still get an error on 13.

Code:

<?php
$player = $_POST[player]; $game = $_POST[game];
$ab = $_POST[ab];
$sng = $_POST[sng];
$dbl = $_POST[dbl];
$tpl = $_POST[tpl];
$hr = $_POST[hr];
$wlk = $_POST[wlk];
$stk = $_POST[stk];
$hbp = $_POST[hbp];
$scf = $_POST[scf];
mysql_select_db("",mysql_connect("","",""));
$sql = "UPDATE ("$player."_Stats" SET (ab) = ($ab), (sng) = ($sng), (dbl) = ($dbl), (tpl) = ($tpl), (hr) = ($hr), (wlk) = ($wlk), (stk) = ($stk), (hbp) = ($hbp), (scf) = ($scf) WHERE (id) = ($game)");
$result = mysql_query($sql)
or die("Invalid query: " . mysql_error());
?>

Team Member Joined: 06 Jan 2002 Posts: 2564

What's with all the parentheses?

Try this:

Code:

$sql = "UPDATE ".$player."_Stats SET ab = $ab, sng = $sng, dbl = $dbl, tpl = $tpl, hr = $hr, wlk = $wlk, stk = $stk, hbp = $hbp, scf = $scf WHERE id = $game";

That should work now. You had a missing "." and an extra ")" on the end.