I am getting the some info from the last record entered into the database and then running a query based on some of that data. I am echoing out the results to see if I am getting the desired results, and I am, but they are repeated twice and I can not figure out why.

The results I am wanting are :

coupon_id 10000004

Keebler100 Calorie Right Bites390
Sunshine100 Calorie Right Bites390

but what I am getting is:

coupon_id 10000004

Keebler100 Calorie Right Bites390
Sunshine100 Calorie Right Bites390
Keebler100 Calorie Right Bites390
Sunshine100 Calorie Right Bites390

The code is below...can someone enlighten me as to why I am getting the results twice?

Thanks.

PHP Code:
<?php

    
//includes:
    
include('connections.php');
    include(
'my_functions.php');

    
//select last record from coupoons table and set applicable variables
    
$query mysql_query("SELECT * FROM coupons ORDER BY coupon_id DESC LIMIT 1") or die(mysql_error());
        while(
$rows mysql_fetch_array($query))
        {
            
$coupon_id $rows['coupon_id'];
            
$barcode $rows['barcode'];
            
$company_prefix $rows['company_prefix'];
            
$family_code $rows['primary_purch_family_code'];
echo 
'coupon_id '$coupon_id,'<br>','<br>';
        }     

$query1 mysql_query("SELECT manufacturers.company_prefix, family_codes.family_code, brands.brand, manufacturers.mfg
FROM (manufacturers INNER JOIN brands ON manufacturers.`company_prefix` = brands.`company_prefix`) INNER JOIN family_codes ON brands.`brand_id` = family_codes.`brand_id`
WHERE (((manufacturers.company_prefix)=
$company_prefix) AND ((family_codes.family_code)=$family_code))");
        while (
$rows mysql_fetch_array($query1))
        {
            
$mfg $rows['mfg'];
            
$brand $rows['brand'];
            
$family_code $rows['family_code'];
echo 
$mfg,$brand,$family_code,'<br>' ;            
        }
?>