Issues updating MySQL value

[AlienGhost]

Hey, I have a MySQL database with the table 'users', and I want to allow users to post a description.
I have a form on another webpage, and I am sure that it is working.

The problem is that, in the following code, I am using the variable $text to update the MySQL. And, when the user submits, the value will not update unless I actually create a specific value to set.

Please excuse the terrible coding. I just want to make it functional before I organize/secure it.
Any help is appreciated, thanks

Code: Select all

<?PHP
session_start();
function upload() {


$text = $_POST['description'];
$userid = $_SESSION['user_id'];
$con = mysql_connect("localhost","**********","****");   //I starred these on purpose
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("1043896_db", $con);

mysql_query("UPDATE users SET description=$text
WHERE user_id=$userid");

}

if (isset($_POST['submit'])) {
upload();}
?>


[johnj]

Please brush up you understanding on data manipulation language.

[vinta]

hi everyone!!!
i like it.thanks for sharing...

[vinta]

hiiiiiiiiii everyone!!!!
i like it.thanks for sharing....
Website Designer Los Angeles

[rupali]

hi,

there is an issue in the query as the description field is in text form so in query use '' to declare text variable,
code should be like this:

mysql_query("UPDATE users SET description='$text' WHERE user_id=$userid");

[johnj]

Another thing that you can try is:

change mysql_query("UPDATE users SET description=$text WHERE user_id=$userid");

to

$sql = "UPDATE users SET description=$text WHERE user_id=$userid";
echo $sql;
mysql_query($sql);

echo $sql will tell you whether $text and $userid has a value in it.

[AlienGhost]

Both of those solutions had valid outcomes. Thanks a lot!