getting a parse error >.<

[Wuggy]

include("common.php");
if(!($link_id = mysql_connect($db_host, $db_user, $db_password))) die(mysql_erorr());
mysql_select_db($db_name);
$wdbattle = mysql_query("SELECT * FROM wdbattle WHERE uid = 1);
$wdbattle = mysql_fetch_array($wdbattle);
$hp = $wdbattle[hp];
$hpleft = $wdbattle[hpleft];
$hpheal = "$hp - $hpleft";
mysql_query("UPDATE wdbattle SET hpleft=hpleft+$hpheal WHERE uid='$id'");

Parse error: parse error in /home/newbie/kiswebdesigns-www/wuggydesign/battle/hospital.php on line 13

I get a parse error, but what the hell is wrong, I've tried like everything, any ideas?

[tekky]

whats line 13? 😕

[Wuggy]

the mysql query

[tekky]

Originally posted by Wuggy
the mysql query

well you make it sound like its obvious what line was #13... the query is #9 on your post...

try this instead

mysql_query("UPDATE wdbattle SET hpleft= $hp WHERE uid='$id'");

no point trying complex math when you are just trying to RESET hpleft to the value of hp....

[Wuggy]

:-\

[tekky]

oh duh

$wdbattle = mysql_query("SELECT * FROM wdbattle WHERE uid = 1);

add a " after the 1

[Wuggy]

hits himself STUPID WUGGY!

[Weedpacket]

Speaking pre-emptively, I'm not sure you want quotes in this line:
$hpheal = "$hp - $hpleft";

[tekky]

Originally posted by Weedpacket
Speaking pre-emptively, I'm not sure you want quotes in this line:
$hpheal = "$hp - $hpleft";

Hey Weed, since you asked about that, if you look over his code... would you not agree that he should just set hpleft to the value of hp?

(looking at his math, it appears thats the result EACH time....)

[Weedpacket]

Originally posted by tekky
(looking at his math, it appears thats the result EACH time....)

Hrm, yeah - except that the uid isn't necessarily the same in the two queries .... not sure I understand what's supposed to be going on here, now.

[piersk]

Also, in the last line, you probably don't need the ' ' around $id (I'm assuming that $id is numerical)