what is wrong with this code?
 

i get this error:

<?php



session_start();



$_SESSION['user_id'] = 4;



$user_id = $_SESSION['user_id'];



$_SESSION['username'] = "zack";



$username = $_SESSION['username'];



$message = $_POST['shout_mes'];



$insert = $_POST['shout'];





if(!empty($message) && $insert = "shout"){



include('mysqlcon.php');



$select = mysql_select_db($db, $con);

if(!$select){

die('could not select db: ' . mysql_error());

}





$sql = mysql_query("INSERT INTO shoutbox (index, user_id, username, message) VALUES(' ', '$user_id', '$username', '$message')");



if(!$sql){

echo "error" . mysql_error();

}else{

header("location: index.php");

}



}else{



echo "there was an error: " . mysql_error();

}



?>

Re: what is wrong with this code?
 

'index' is a reserved word. You must name that column something else.

Re: what is wrong with this code?
 

ok here is what worked.

$sql = mysql_query("INSERT INTO shoutbox (user_id, username, message) VALUES('$user_id', '$username', '$message')");

Re: what is wrong with this code?
 

It is not a good habit to use reserve words as column or table names. But if you still need to use that then simply enclose the column name in backticks (`).