Hi, I need a query that searches my database in a single row called ‘type’ and then extracts all of the types of type.
I can get it to extract all of the values but values in ‘type’ is used for mote than one row so where i end up echoing out
I want to only echo out
Hope this makes sense and thanks in advance.
to your query
Hi, will that piece of code remove the duplicate entries or just order them so they are all together?
Well, it groups them together so you would only have
But then looking at what you want, it may be better to use SELECT DISTINCT(type)
Thanks, DISTINCT was exactly what was needed.
You must be logged in to reply to this topic.