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

Reply via email to