Query Problem?

[Anon]

my script:

echo "
<form method=post action=$PHP_SELF?act=update>
Username:
<input type=text name=Ausername value='$derinfo[username]'><br>
Money:
<input type=text name=Amoney value='$derinfo[money]'><br>
User Level:
<input type=text name=Auserlevel value='$derinfo[userlevel]'><br>
Popularity:
<input type=text name=Apopularity value='$derinfo[popularity]'><br>
<input type=hidden name=Auserid value='$maid'>
<input type=hidden name=act value=update>
<input type=submit value=Update User!>
</form> ";
}

if ($act == "update") {
$Query = "UPDATE users SET username='$Ausername' money=$Amoney userlevel=$Auserlevel popularity=$Apopularity WHERE userid='$maid";

echo "<a href=userlist.php>Go Back</a>";
}

My Problem: Doesn't Update DB...

[Anon]

o0o0ps, forgot to mention: the values do show up in the form*

[Anon]

Sorry, I Would Love To Help But I Suck At PHP And Sql 😉

[Anon]

1st: Connect to the database
//Connect to server with username and password
MYSQL_CONNECT($hostname, $username, $password)
or die ("Could not connect");
print ("Connected to host successfully");

//Now Connect to the MySQL database
@mysql_select_db ("$database")
or die ("***Could not connect to database");
print (" --Connected to database successfully");

2nd: state your query

...you did this with $query

3rd: execute your query

$result=MYSQL_QUERY($query);

[Anon]

yea I know how to connect n stuff, thats already done... and I put the $Query part in this one by accident.....

echo "
<form method=post action=$PHP_SELF?act=update>
Username:
<input type=text name=Ausername value='$derinfo[username]'><br>
Money:
<input type=text name=Amoney value='$derinfo[money]'><br>
User Level:
<input type=text name=Auserlevel value='$derinfo[userlevel]'><br>
Popularity:
<input type=text name=Apopularity value='$derinfo[popularity]'><br>
<input type=hidden name=Auserid value='$maid'>
<input type=hidden name=act value=update>
<input type=submit value=Update User!>
</form> ";
}

if ($act == "update") {
$Query = "UPDATE users SET username='$Ausername' money=$Amoney userlevel=$Auserlevel popularity=$Apopularity WHERE userid='$maid";

echo "<a href=userlist.php>Go Back</a>";
}

I dunno why the info is showing up in the text input but not updating anything...

[edwardsbc]

Is userid a string or a number? Should the end of your query be:

WHERE userid=$maid

No quotes...

[Anon]

Malformed sql. Add AND between attributes.

[manjeman]

maybe u can try this,

if ($act == "update") {
$Query = "UPDATE users SET username='$Ausername', money='$Amoney', userlevel='$Auserlevel',popularity='$Apopularity' WHERE userid='$maid'";

hope it will help..🙂

[mattr]

Yes you need to add commas between the column lists, and NO QUOTES for the userid=$maid if it is a numeric value. That is a big NO NO.