HELP WITH PHP AND MYSQL

[bodge]

Hey Devbest, I need help with adding a PHP form that edits the MySQL table.
I want it to edit the "status column" the closest I can get is when I type something in and hit okay it makes a whole new user... :L

Can you help?

<?php
$status = $_POST ['status'];
mysql_query("INSERT INTO users (status) VALUES ('$status')");
?>

<form action="<?php $_SERVER['PHP_SELF']?>" method="post" class="status">
<input type="text" name="status" size="32" placeholder="Status"><span required>*</span>
<input type="submit" value="Okay" />

status = VARCHAR(32)

 

[Kaz]

What are you trying to accomplish? Like what do you want to edit?
A users status?

 

[bodge]

What are you trying to accomplish? Like what do you want to edit?
A users status?

Yes, I want to edit a users status. (Like a motto on Habbo).

 

[Kaz]

Then why are you 'inserting' ?? that makes no sense.

You will do:

<?php
$status = $_POST ['status'];
mysql_query("UPDATE users SET status = '".$status.'" ");
?>

After $status, you could maybe have WHERE username = $user (with $user getting the logged in user

 

[Heaplink]

mysql_query("UPDATE users SET status = '{$status}' WHERE id = {$userid}");

Note that $userid is the ID of the user (obviously) so find the right variable.

Also, use PDO or MySQLi, both for security and for later support (Old mysql functions will be deprecated)

 

[bodge]

Then why are you 'inserting' ?? that makes no sense.

You will do:

<?php
$status = $_POST ['status'];
mysql_query("UPDATE users SET status = '".$status.'" ");
?>

After $status, you could maybe have WHERE username = $user (with $user getting the logged in user

Worked perfectly thanks!