mysql wrong error?

[flemingmike]

hello,  if im inserting to database from form, im getting an error, but it is correctly entering the data.  any ideas?

 

<?php
include 'config.php';


$query = mysql_query("INSERT INTO jobNO (
`ID` ,
`jobNO` ,
`companyID` 
)
VALUES (
NULL, 
'$_POST[jobNO]', 
'$_POST[companyID]'
)");

mysql_query($query) or die('Error, insert query failed');


echo "1 record added";




?>

[Pikachu2000]

You're actually executing mysql_query() twice. The second one (the only one that is checked for failure) tries to execute the result resource of the first one, and fails.

[flemingmike]

thanks

 

i made it $query = "Insert.....

 

it works