Re: mysql query/$post problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Mark wrote:
I havnt even tried this query but i know its wrong can anyone help!
How do you know it's wrong ? O_o

***************************************
<?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')";
$query = "INSERT INTO users (AVATARS) VALUES ('$avname') WHERE id = $user_id";

This works only if the $avname is a STRING!

mysql_query($query);s
----------------------^
This will cause an error.
That's why you should test scripts before you post em ...

mysql_close();

include("footer.html");
?>

**********************************


I am trying to insert the value of $avname into the users table, into the avatar field.
Yeah seems, so ;)

--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux