1st, when I want to update multiple values, I tried:
$sqlRequest = “UPDATE gvntools_msg SET title = ‘$title’ AND body=‘$body’ AND videoID=‘$videoID’ WHERE username = ‘$username’”;
What would be a correct syntax? Because it wont save the results.
Also, I wanna store a private message in database. As its plain text I decided to go simply with VARCHAR(1000). Saves fine, but I have a problem getting it inside textarea.
Message:<br /><textarea name=\“body\” cols=\“40\” rows=\“10\” maxlength=\“1000\” value=\“$body\”></textarea>
It won’t display a thing. Here is how I get $body var:
$body = mysql_result($result, 0, ‘body’);