updating record from page

[Robert_Blackwel]

I have this page that displays point information for members and I want to convert it to an update page.

I've made forms before but never for updating, just regular inserts and form mail.

if ($submission)
{
UPDATE guild_chars2
SET gp = '$results[gp]' <--- parse error
WHERE name = '$name'
}

here's the original code
http://www.wowcentral.com/random/ranks.txt

http://www.wowcentral.com/random/ranks2.txt

[edcellgavin]

first, you missed a ';' @ line 167.
also, try changing your update to

if ($submission)
{
	// update record
	$query = "UPDATE guild_chars2 SET gp = '" . $results[gp] . "' WHERE name = '" . $name . "'";
	$result = mysql_query($query);
}

[thorpe]

are you saying this code...

if ($submission)
{
UPDATE guild_chars2
SET gp = '$results[gp]' <--- parse error
WHERE name = '$name'
}

gives you a parse error? because if you are... there are plenty of bits missing.

if ($submission)
{
mysql_query("UPDATE guild_chars2 SET gp = $results['gp'] WHERE name = '$name'");
}

I've made forms before but never for updating, just regular inserts and form mail.

sorry... no idea what that meens. forms are a html thing and cannot UPDATE or INSERT anything.

[Robert_Blackwel]

I tried your code for the query

mysql_query("UPDATE guild_chars2 SET gp = $results['gp'] WHERE name = '$name'");

and I get this.
Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in ranks2.php on line 119

same error even if I change where name ='$name'" to

name = $results['name']");

😕

[jansky]

just add this one, probably
thorpe miss the php parsing

mysql_query("UPDATE guild_chars2 SET gp ='". $results['gp']."' WHERE name = '$name'");

[Robert_Blackwel]

Thanks, the page now loads with no errors. But nothing seems to happen when I click submit (other then the page reloading). The values are not entered/updated in the dbase. When the page reloads the input fields still have the same information.

[jansky]

can you post the whole codes??

[Robert_Blackwel]

code is in my first post, i linked to txt's.