jamiegee Posted July 28, 2013 Share Posted July 28, 2013 SELECT oc_option_value_description.option_id, oc_option_value_description.name, oc_product_option_value.quantity FROM oc_option_value_description LEFT JOIN oc_product_option_value ON oc_option_value_description.option_id = oc_product_option_value.option_id WHERE product_id = 447 AND oc_option_value_description.option_id = 11 Hi I haven't posted all the table data just yet as this seems it could be a simple fix. I am quite new to mysql/php but am trying to learn more technical code. I run the above sql code and it should return 3 rows, i know this for a fact, but it actually returns 9, it returns 3 of each row. Is it just something im missing off? i have googled but can seem to run into an article or post about this error. if you need to see my database structure im happy to post it. Kind regards and many thanks in advanced cheers jamie Quote Link to comment https://forums.phpfreaks.com/topic/280605-multiple-rows-of-same-data/ Share on other sites More sharing options...
ragax Posted July 29, 2013 Share Posted July 29, 2013 Time waster. This is a duplicate from DevShed, where the OP hasn't given sign of live after several replies. Quote Link to comment https://forums.phpfreaks.com/topic/280605-multiple-rows-of-same-data/#findComment-1442608 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.