INSERT INTO not working

FatRat

y does this file not work???

i have other queries that work, but i cant get the INSERT INTO to work 🙁
Any help?

Thanks
My error log has this error:

[Wed Nov 2 08:25:22 2005] [error] [client 62.254.0.55] File does not exist: /home/the5ncom/public_html/404.shtml
[Wed Nov 2 08:25:22 2005] [error] [client 62.254.0.55] File does not exist: /home/the5ncom/public_html/favicon.ico

The Script is:

<?php

$dbcnx = @mysql_connect("localhost", "the5ncom_fatrat2", "**********");
if (!$dbcnx) {
echo( "<p>Unable to connect to the " . "database server at this time.</p>" );
exit();
}

mysql_select_db("the5ncom_5thpdata", $dbcnx);

if (! @mysql_select_db("the5ncom_5thpdata") ) {
echo( "<p>Unable to locate the the5ncom_5thpdata " . "database at this time.</p>" );
exit();
}

mysql_query("INSERT INTO the5ncom_match (match_id, match_date, match_month, match_year, match_time, match_type, match_size, match_versus, match_timezone, match_map, match_status) VALUES (\'\', \'erg\', \'serfg\', \'sdf\', \'sdf\', \'sdf\', \'sdf\', \'sdf\', \'sdf\', \'sdf\', \'0\')");

?>
</body></html>

Roger_Ramjet

You do not need to escape the single quotes around your values since you are using double-quotes around the query string itself.

FatRat

mysql_query( "INSERT INTO 'the5ncom_match' ('match_id', 'match_date', 'match_month', 'match_year', 'match_time', 'match_type', 'match_size', 'match_versus, 'match_timezone', 'match_map', 'match_status') VALUES ('', 'erg', serfg', 'sdf', 'sdf', 'sdf', 'sdf', 'sdf', 'sdf', 'sdf', '0')");

it still dont work 🙁

i have listed every column in the table and put a value for all except the match_id which is set as key, so i put ''

could it be a prob with the database?

i also set the file permissions to 755

Roger_Ramjet

if match_id is autoincrement, and I'll bet it is, then just omit both it's name and any value for it. Attempting to insert anything into an autoinc column will not work as the db supplies that value itself. If it is not an autoinc, but is the primary key, or any required and indexed column for that matter, then ommitting a real value will also cause the query to fail

FatRat

mysql_query( "INSERT INTO 'the5ncom_match' (''match_date', 'match_month', 'match_year', 'match_time', 'match_type', 'match_size', 'match_versus, 'match_timezone', 'match_map', 'match_status') VALUES ('erg', serfg', 'sdf', 'sdf', 'sdf', 'sdf', 'sdf', 'sdf', 'sdf', '0')");

match_id was set to auto inc and was also key.

so i deleted them from the query, but it still dont work 🙁

Lars_Berg

'the5ncom_match'

remove all ' surrounding the table and column names. To escape a name use ` as in your first post.

Add some error handling like

mysql_query("insert ...") or die("Execution error " . mysql_error());

FatRat

i managed to get this to work

thanks