Not sure what you mean
This is the code for the second repeat region...
mysql_select_db($database_midas0001, $midas0001);
$query_Recordsetdisplayproducts = sprintf("SELECT * FROM products WHERE invoiceid = %s ORDER BY productid", GetSQLValueString($colname2_Recordsetdisplayproducts, "int"));
$Recordsetdisplayproducts = mysql_query($query_Recordsetdisplayproducts, $midas0001) or die(mysql_error());
$row_Recordsetdisplayproducts = mysql_fetch_assoc($Recordsetdisplayproducts);
$totalRows_Recordsetdisplayproducts = mysql_num_rows($Recordsetdisplayproducts);
and this is the code for the first repeat region...
mysql_select_db($database_midas0001, $midas0001);
$query_Recordsetmultiprint = "SELECT *, DATE_FORMAT(datecreated,'%d %M %Y') as printdate FROM invoice LEFT JOIN customers ON customers.customerid = invoice.invoiceid LEFT JOIN products ON products.invoiceid = invoice.invoiceid LEFT JOIN preferences ON customers.prefid = preferences.prefid WHERE invoice.print = '1' group by invoice.invoiceid";
$Recordsetmultiprint = mysql_query($query_Recordsetmultiprint, $midas0001) or die(mysql_error());
$row_Recordsetmultiprint = mysql_fetch_assoc($Recordsetmultiprint);
$totalRows_Recordsetmultiprint = mysql_num_rows($Recordsetmultiprint);?>
So, do you mean add the two codes together within the php brackets like so...
mysql_select_db($database_midas0001, $midas0001);
$query_Recordsetmultiprint = "SELECT *, DATE_FORMAT(datecreated,'%d %M %Y') as printdate FROM invoice LEFT JOIN customers ON customers.customerid = invoice.invoiceid LEFT JOIN products ON products.invoiceid = invoice.invoiceid LEFT JOIN preferences ON customers.prefid = preferences.prefid WHERE invoice.print = '1' group by invoice.invoiceid";
$Recordsetmultiprint = mysql_query($query_Recordsetmultiprint, $midas0001) or die(mysql_error());
$row_Recordsetmultiprint = mysql_fetch_assoc($Recordsetmultiprint);
$totalRows_Recordsetmultiprint = mysql_num_rows($Recordsetmultiprint);mysql_select_db($database_midas0001, $midas0001);
$query_Recordsetdisplayproducts = sprintf("SELECT * FROM products WHERE invoiceid = %s ORDER BY productid", GetSQLValueString($colname2_Recordsetdisplayproducts, "int"));
$Recordsetdisplayproducts = mysql_query($query_Recordsetdisplayproducts, $midas0001) or die(mysql_error());
$row_Recordsetdisplayproducts = mysql_fetch_assoc($Recordsetdisplayproducts);
$totalRows_Recordsetdisplayproducts = mysql_num_rows($Recordsetdisplayproducts);?>
as i cant see it making a difference or have I got the wrong end of the stick.
sorry for being such a numskull
thanks
john