Mark skrev:
I havnt even tried this query but i know its wrong can anyone help!
***************************************
<?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')";
mysql_query($query);s
mysql_close();
include("footer.html");
?>
**********************************
I am trying to insert the value of $avname into the users table, into the
avatar field.
Hello Mark,
I think what you are trying to do is coordinated a bit wrong, perhaps
http://www.w3schools.com/sql/sql_insert.asp
could be of some help for you to achieve this in the future.
Taking a look at your query, i do see what you are trying to do, but the
structure is wrong.
$query = "INSERT INTO users (avatars) VALUES ('$avname')WHERE id ='$user_id')";
As Nicolas said, it is important that you understand your abilities to
debug these queries by outputting them through simple commands such as
echo or even the php-mysql function mysql_error(); give these a try
Let us know how it works out!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
