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 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. 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
Archived
This topic is now archived and is closed to further replies.