is there any thing wrong wif this code??

aznjay

<?
session_start();

$link = mysql_connect('localhost','chaotici_commu', 'dragon')
    or die("Could not connect");
mysql_select_db('chaotici_chaotic')
    or die("Could not select database");

$my_quadrant = $_SESSION['edithtml'];
$email = $_POST['email'];
$message = $_POST['comments'];


$update ="INSERT INTO users (comment) values ($message)";
mysql_query($update) or die ("Could not add data to the table");

?>

THis code wouldn't create the file in the table......help me whatis wrong with this code.

aznjay

I don't know where to put WHERE in the INSERT INTO command.

mflanagan

When you say it didn't create the file (sic?) in the table, do you mean the mysql_query returned an error?

What should happen if there is no 'comments' field in the post (and therefore, no values in the insert)?

aznjay

see this what i want making it send in mysql in a ceratin username.

mflanagan

Are you trying to update an existing record, or are you trying to insert a new record?

aznjay

yeah i'm inserting a new record like adding a new. Can you help me create a guestbook that when users login they can only see the messages that they recived. NOt put one guestbook and pile all of the message that all users post. Can you IM me aznjay2x okie.