4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 Parse error
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
Kdawg
Senior WebHelper
Senior WebHelper


Joined: 21 Apr 2003
Posts: 153

PostPosted: Sun Apr 27, 2003 7:54 pm (14 years, 7 months ago) Reply with QuoteBack to Top

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());
?>
OfflineView User's ProfileFind all posts by KdawgSend Personal Message
Daniel
Team Member



Joined: 06 Jan 2002
Posts: 2564

PostPosted: Sun Apr 27, 2003 7:56 pm (14 years, 7 months ago) Reply with QuoteBack to Top

Shouldn't {$player} be $player?

________________________________
Image
OfflineView User's ProfileFind all posts by DanielSend Personal Message
Iyonix
WebHelper
WebHelper


Joined: 12 Nov 2002
Posts: 82
Location: Yarm, England

PostPosted: Sun Apr 27, 2003 8:08 pm (14 years, 7 months ago) Reply with QuoteBack to Top

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");

________________________________
Iyonix
OfflineView User's ProfileFind all posts by IyonixSend Personal Message
Kdawg
Senior WebHelper
Senior WebHelper


Joined: 21 Apr 2003
Posts: 153

PostPosted: Mon Apr 28, 2003 1:41 am (14 years, 7 months ago) Reply with QuoteBack to Top

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());
?>
OfflineView User's ProfileFind all posts by KdawgSend Personal Message
Daniel
Team Member



Joined: 06 Jan 2002
Posts: 2564

PostPosted: Mon Apr 28, 2003 5:59 am (14 years, 7 months ago) Reply with QuoteBack to Top

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.

________________________________
Image
OfflineView User's ProfileFind all posts by DanielSend Personal Message
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.079327 seconds :: 17 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme