Drompo
21-01-2007, 07:47 PM
I am making a staff profile system. i have the view profile with information i inserted witnin database. I made a script so you can edit it with a form but how do you insert it into that user.
My user table is called staff and the field with the usernames is called username
This is my current query
$edit = mysql_query("UPDATE `staff` ( `habboname`, `forumname`, `age`, `hotel`, `gender`, `favouritesong`, `favouritegenre, `favmanagement`, `besthabbofriend`, `bestfriend`, `interests`, `about`) VALUES ('$habboname', '$forumname', '$age', '$hotel', '$gender', '$favouritesong', '$favouritegenre', '$favmanagement', '$besthabbofriend', '$bestfriend', '$interests', '$about')");
Any Ideas?
My user table is called staff and the field with the usernames is called username
This is my current query
$edit = mysql_query("UPDATE `staff` ( `habboname`, `forumname`, `age`, `hotel`, `gender`, `favouritesong`, `favouritegenre, `favmanagement`, `besthabbofriend`, `bestfriend`, `interests`, `about`) VALUES ('$habboname', '$forumname', '$age', '$hotel', '$gender', '$favouritesong', '$favouritegenre', '$favmanagement', '$besthabbofriend', '$bestfriend', '$interests', '$about')");
Any Ideas?