update tables

[nikko50]

Hello friends!
I'm trying to update a table called orders. A field called orderstatus should be marked 'shipped' only if all items in my orderdetails table are marked shipped. How can I test to each row in orderdetails to see if all the items are marked shipped as some will have other status.
Tracy

[trex005]

Maybe I'm not understanding the complexity of this... but here is my stab. Select all items in orderdetails for that order_id, that are not shipped. if you have any results, you know that your order is not ready to be marked shipped

//this is of course written knowing nothing about the structure of your tables. and assuming you are using the most popular database (MySQL)
$sql = "
SELECT
order_id
FROM
order_details
WHERE
order_id = '$order_id'
AND
orderstatus != 'shipped'
";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0)
{
     echo "Sorrybuddy the package is not ready to be marked shipped";
}
else
{
     echo "YAY!!! we can mark the order shipped now!!!!";
}

edited because I forgot to close my PHP tag

[nikko50]

Actually that may work. I'll give it a shot and let you know. Thanks for taking a "stab" at it!
Tracy

[trex005]

okay... been anxiously awating the result... but I need to get to bed... but I subscribed to this thread so my Gmail'll let me know in the mornin if you reply!