"Dan McCullough" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I believe that would be the correct term for what I need. > > Here is what I have been trying to do. > > I have orders and customers. Customers are required to do a few things before we can process the > order. Some times they are very slow in doing so. So I wanted to write a little reminder script > to poke us to email/call them. > > So I have orders and customers. I need to go through and list out the orders and then I need to > use the customer to grab all the order associated with them, then list out their contact > information. Anythough on how I can group orders by customer, list the customer information (from > another table) and then go on to the next order and so the same thing all over again?
Load all customers and while looping through the result set load all orders associated with the current customer: // open db connection etc. // load all customers $result = mysql_query('SELECT * FROM customers'); while ($row = mysql_fetch_assoc($result)) { // output customer data if required echo $row['customerName']; // load all associated orders $tempResult = mysql_query('SELECT * FROM orders WHERE customerID = ' . $row['customerID']); while ($tempRow = mysql_fetch_assoc($result)) { // output order data if required echo $tempRow['orderID']; } } Regards, Torsten Roehr -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php