Re: mysql query/$post problem
| From: | nicolas figaro | 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