Shouldn't your query add the $Cust_ID too ??
$sql = select * from product,order_line where prod_num = product_id and
order_num = $order_id;
How is this query going to identify a particular customer ??
--
I'm not sure if
my guess:
it seems that this is where the fault lies. But without information on how
the database is setup and what $order_id is there is not much else that I
can pick at.
$sql = select * from product,order_line where prod_num = product_id and
order_num = $order_id;
make sure your WHERE clause
The script looks ok to me, so you might need to debug the input values and
the data it is drawing from.
This is probably where the problem is:
$sql = select * from product,order_line where prod_num = product_id and
order_num = $order_id;
If you can, print the value of $sql and then run the