Re: mysql query/$post problem

From: Date: Mon, 27 Mar 2006 08:24:47 +0000
Subject: Re: mysql query/$post problem
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-232597@lists.php.net to get a copy of this message
Mark a écrit :
I havnt even tried this query but i know its wrong can anyone help! *************************************** <?php include("header.php"); include("connect.php"); don't you need a session_start() somewhere ?
(or it's in the header.php or connect.php perhaps ?)
$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. could you tell us a bit more about what's in the $avname ?
try an echo $query and run your query with an sql client to check if the database accepts your request. N F

« previous php.general (#232597) next »