Inserting & Updating

[Anon]

I'm trying to do the following

I have a registered user when first registered there are No orders This value is kept in the user table, So when the main page loads it displays No orders.

I have a link that lets the user place an order this information is stored in a seperate table. When the user places the order I want to insert the order in the orders table but also update the value No to Yes in the user table.

Can anyone help?

TIA
Richie TM

[trippyd]

sounds like 2 sql statements to me, if you are worried about a failure of the order insert, I would run that first, and dump them all into a single query call to the database. Assuming MySQL for this example:

mysql_query("insert into dbName (some, column, names) values (some, values, in);update user set ordered = "Yes" where user_id = $userID;;

That should do it.

[Anon]

It seems that would work. but I receive no errors even when I user
print mysql_error();

Everything seems to look good but it dosen't update that file

Here the code see if theres anything I can't see

// Insert data into bpo_orders table

$sql = "INSERT INTO bpo_orders
(paddress,notes,date,status,bpo_user)
VALUES (
'$paddress',
'$notes',
'$date',
'$status',
'$bpo_user')";
$result = mysql_query($sql);
print mysql_error();
echo "text";
}
// Update bpoco orders value to Yes
if ($submit) {
if ($bpo_id) {
$sql2 = "UPDATE bpoco SET
orders='Yes' WHERE bpo_id=$bpo_id";
print mysql_error();
}

TIA
Richie TM

[trippyd]

I don't see anywhere in your code where you are running (mysql_query) the second piece of sql... ($sql2).

Often, if I am having problems with a piece of sql, I will print it as I run it, so I can see exactly what is being passed to the database and why it is behaving (or not behaving).

Hope this helps.

D