Wed, 2011-10-12 13:07
Hello All,
Got a php question!
I am trying to select a DISTINCT entry based on a entry in the database. But when i select the entry, it only shows that current column information. It drops out all the other information related to that entry. Can anyone give a pointer? I am ready to share the username / pwd with anyone who would like to help 
Regards,
Mihir.
Wed, 2011-10-12 15:00
#1
SQL, not PHP
Your query is doing exactly what it's supposed to do. You only asked for the one distinct field.
I am no sql guru, and am fast forgetting all I ever knew. 
You need a nested query that asks for all columns where the column of interest is distinct. If no one pops up here with an answer, you may want to try an sql forum.
I am moving this to 'off topic', as the question is not css related.
cheers,
gary
Wed, 2011-10-12 15:25
#2
your query will return all
your query will return all columns of a row based on the distinct entry.. it will be more helpful if you can share the query you are using.
Wed, 2011-10-12 18:07
#3
jagzviruz wrote: your query
your query will return all columns of a row based on the distinct entry.. it will be more helpful if you can share the query you are using.
Not quite. Mihir is only selecting the one field.
cheers,
gary