Insert

[Anon]

Where am I going wrong

I am trying to insert a variable in to the Orders table and return the autoincremented order_id from the table

$add_order_sql = "INSERT INTO ORDERS (fullname) values (\"$full_name\")";

$mysql_query($add_order_sql, $link);
$order_id = mysql_insert_id();
print "Thank You. Your Order ID is $order_id. Please quote this in any communication";

The following error results in running the script:

Fatal error: Call to undefined function: () in /usr/home/shop/sendorder.php on line 193

[wdseelig]

Don't know if this is it, but you should not have a dollar sign in front of the mysql_query -- functions are not variables!

[Anon]

I saw this and took it out, but still no luck

[Anon]

I've also got another statement directly after the initial statement would this cause a problem?

$add_order_sql = "INSERT INTO ORDERS ( fullname ) values ( '$full_name' )";

mysql_query($add_order_sql, $link) or die("Sorry couldn't add items to table");
$order_id = mysql_insert_id();

print "Thank You. Your Order ID is $order_id. Please quote this in any communication ";

$rm_item_sql = "DELETE FROM TRACKING WHERE user_id = \"$user_id\"";

mysql_query1($rm_item_sql) or die("Couldn't remove items.");

[Anon]

So what's the error message now?

Diego

[Anon]

It's sorted out, I just put a result command

e.g $sql = blah blah
$sql_result = mysql_query