Re: mysql query/$post problem

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!