[SOLVED] this code drives me crazy "inserting values to the mysql" need help !

[samoi]

I try to let this script work, but it doesn't what's its problem?

 

<?php
error_reporting(E_ALL & E_NOTICE);

require_once('config.php');




if(!$_POST)
{
header('Location: insert.php');
}

else
{

$event = clean($_POST['event']);
$date = clean($_POST['date']);
$insert = "INSERT INTO table (event, date) VALUES ('$event', '$date')";
$insertSQL = mysql_query($insert);

echo 'The new event has been submitted <br>
 hit <a href="index.php"> this link </a> to view them';
}
function clean($str)
{
return mysql_escape_string($str);
}


?>

[awpti]

I don't know!

 

What's the error? A little information goes a long way.

[samoi]

it display no errors, but it doesn't insert them in the database!

 

Strange, right?

[awpti]

Not necessarily. Check your error logs (error_log if on an Apache server)

[DarkWater]

You don't do any error checking on your query results.  Check your query by changing the line to read:

 

$insertSQL = mysql_query($insert) or die(mysql_error());

 

You should run error checks on every query.

[samoi]

You don't do any error checking on your query results.  Check your query by changing the line to read:

 

$insertSQL = mysql_query($insert) or die(mysql_error());

 

You should run error checks on every query.

 

I've got

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table (event, date) VALUES ('ENG 102 delever', '12/05/2008')' at line 1

[samoi]

Oh, I found that I cannot name a table `table` , not allowed in Mysql !!

 

Thank you guys though

[revraz]

Because you can't use the word TABLE as your tablename.  Rename it (or if you want to keep it, use `backtics`)