Welcome to WebmasterWorld Guest from 126.96.36.199
Forum Moderators: open
I have entries in my database that have a column called product_code, not all the entries have a code and some have the same code as other e.g
item 3 123
item 4 123
item 5 567
I have managed to use GROUP BY code to only show one result for duplicate entries for the field 'code' but when I do this the empty results are also grouped, how can I make GROUP BY ignore empty values?
And can I order the grouping to make sure the result for each set presented is the one I want?
Can you take your example data given above and tell us how you expect the results to look like?