help with UPDATE code

Anon

hey everyone i am building this profile system for a small group of people. The scenario is they first login then are directed to a page that will echo out their current profile stats.

i was wondering though how would i go about coding the script to where they can enter new data on top of the old one and when submitted it will updated the database.

I have an idea how it might be done, but i\'m not too sure how to do it to a specific user.

any help would be greatly appreciated. thanks!

[deleted]

maybe you first create a table in the database. (e.g with 3 columns named 'name','password','user_name').

After however loging in in your system you could use php's session module/functions to register the username in the session.

Then you could on one page have a textarea filled with his name. (of course dynamically with php(could be: $sql = "SELECT name FROM users WHERE user_name = $sessionvar"😉 where $sessionvar could be the users user_name(you had stored it you database)).

So by now you have filled the textarea with the users real name. Maybe his username (user_name) is joe and his name (name) is Joe Goldenberg. So nw in the Textarea the value would be Joe Goldenberg.

The user (or admin or whatever you wanna do) can change this name and by pressing the submit button (<input type="submit" name="update" value="true">).

Now the main thing you were lokking for. The php-code to perform this update in a database (mysql maybe):
if($_POST/GET["update"] == "true"){
$sql = "UPDATE users SET name = '$textareaname' WHERE user_name = $sessionvar";

...

}

regards

ali

Anon

so if i use this line;

$sql = "SELECT name FROM users WHERE user_name = $sessionvar

where the keyword WHERE is the most important piece it will pull the whole row of that user?

if thats the case then i totally get exactly what your saying and i can try other methods besides that sessionvar just to experiment.

So in order for me to pull the correct row of that user i need to use the keyword WHERE userid = '$userid'?

thanks for your help

Anon

One thing to remember if your going to use usernames for your ID make sure you do a check when they sign up, so you dont get any duplicates.

I myself like to use a (auto)ID and an email address as the users ID, it's hard to get a duplicate email, and I still check them for duplicates

If you want to get all the fields from the row use SELECT * FROM table ....

-Ken

Happy coding