Jump to content


seeing double


  • Please log in to reply
2 replies to this topic

#1 dogguy2010

  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 12 July 2013 - 12:40 AM

Can some one please explain to me why the following code echoes the results twice?




    //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>' ;            
The results that I want:
Keebler100 Calorie Right Bites390
Sunshine100 Calorie Right Bites390
The results I am getting:
Keebler100 Calorie Right Bites390
Sunshine100 Calorie Right Bites390
Keebler100 Calorie Right Bites390
Sunshine100 Calorie Right Bites390
I am new to this and am probably missing something very simple, but I can not figure it out.
Please help.

#2 kicken

  • Gurus
  • Wiser? Not exactly.
  • 3,375 posts
  • LocationBonita, FL

Posted 12 July 2013 - 01:04 AM

Probably your SELECT query is returning duplicates. We can't answer why to that without knowing more about each of the tables and the data contained within them. A quick fix might be to just change it from SELECT to SELECT DISTINCT
Did I help you out? Feeling generous? I accept tips via Bitcoin @ 14mDxaob8Jgdg52scDbvf3uaeR61tB2yC7
Kicken's World⦄ ⦃Recycle old CD's

#3 web_craftsman

  • Members
  • PipPipPip
  • Advanced Member
  • 64 posts
  • LocationUkraine

Posted 12 July 2013 - 03:43 AM

Try to change your second INNER JOIN to LEFT JOIN

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users