[RESOLVED] Do things to one database result then move on...

ElectricRain

Ok, so what i have is a orders database which goes order number, customer number, product, quantity etc. now for each different product ordered, im entering a new row, and grouping them by order number- ie all products ordered at one time will have the same order no.

Problem is, when I come to display the orders tracking page, Im wanting to display:

Order 1
Product 1 - some info -
Product 2 - some info -
dispached etc.

Order 2
Product 1 - some info -
dispatched.

But since I have a whole bunch of rows which have the same order number, I need something like
while order number is (whatever the first order number that matches the customers id is) display this table with the info about those products.. then move on and do the same for the second order number. make sense?
code so far:

$getorders = mysql_query("SELECT * from orders where customer_no = '".$userrow['id']."'") or die(mysql_error());
if (mysql_num_rows($getorders) == 0) { 
	echo ("You currently have no orders."); 
} else {
	while ($orderrow = mysql_fetch_assoc($getorders)) {	
		//im not sure what should go here
	}
}

bpat1434

well, you could always do:

$order_num = '';
while($orderrow = mysql_fetch_array($getorders)) {
  if(empty($order_num)){ $order_num = $orderrow['ordernumber']; }

  if($order_num != $orderrow['ordernumber'])
  {
    // Ensure this only shows per unique order number
    echo '<b>'.$orderrow['ordernumber'].'</b><br>';

// Update $order_num for current number
$order_num = $orderrow['ordernumber'];
  }

  // Display your results as you want here
}

Now, you'd have to order by ordernumber so that they "group" together....

ElectricRain

Thats almost precisely it, theres just one small problem- whats displaying is

(order number missing here)
Product 1 - some info -
Product 2 - some info -
dispached etc.

Order 2 (but this one displays ok)
Product 1 - some info -
dispatched.

In other words it works fine, except the very first order number isnt displaying.
Have you any idea why that would be? Code altered just slightly to

$order_num = ''; 
while ($orderrow = mysql_fetch_array($getorders)) { 
	if (empty($order_num)) { $order_num = $orderrow['order_no']; } 
   	if ($order_num != $orderrow['order_no']) { 
    		// Ensure this only shows per unique order number 
    		echo '<b>'.$orderrow['order_no'].'</b><br>'; 
    		// Update $order_num for current number 
    		$order_num = $orderrow['order_no']; 
  	} 
	// Display your results as you want here 
	echo ("<hr class='rule'> ".$orderrow['prodid']." <br><hr class='rule'>");
}

bpat1434

SOrry, guess my logic was off... do this:

 $order_num = '';
while ($orderrow = mysql_fetch_array($getorders)) {
     if (empty($order_num) || $order_num != $orderrow['order_no']) {
          // Ensure this only shows per unique order number
          echo '<b>'.$orderrow['order_no'].'</b><br>';
          // Update $order_num for current number
          $order_num = $orderrow['order_no'];
    }
    // Display your results as you want here
    echo ("<hr class='rule'> ".$orderrow['prodid']." <br><hr class='rule'>");
}

ElectricRain

Perfect. Thankyou so much 🙂