Mark wrote:
I havnt even tried this query but i know its wrong can anyone help!
How do you know it's wrong ? O_o
***************************************
<?php
include("header.php");
include("connect.php");
$comp_id = $_SESSION['comp_id'];
$user_id = $_SESSION['user_id'];
// Grab variables and insert into database
$avname = $_POST['avname'];
$query = "INSERT INTO users AVATARS WHERE id =$user_id '','$avname')";
$query = "INSERT INTO users (AVATARS) VALUES ('$avname') WHERE id =
$user_id";
This works only if the $avname is a STRING!
mysql_query($query);s
----------------------^
This will cause an error.
That's why you should test scripts before you post em ...
mysql_close();
include("footer.html");
?>
**********************************
I am trying to insert the value of $avname into the users table, into the
avatar field.
Yeah seems, so ;)
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php