Hi,
I have 2 tables Order & Orderdetail
For each Order , there are several rows in the Order Detail table. I need a format like
Name, Order id
and then a list of all the orders details.
But my query pulls all the data and repeats the Name & Order id repeatedly.
In MS Access I used a Shape command, but in MYSQL I’m not sure how to do it.
Here is my query
$result1 = mysql_query("SELECT * ,b.total FROM orderdet a,orders b WHERE a.orderId =$orderno");
Thanks
