Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by wickdbob
-
removing duplicate entries
Hmmm.. so there is no other way of doing this other than using another table?? I cannot utilise GROUP BY or DISTINCT in any way? -
removing duplicate entries
Hi I have the following query which displays records based on a certain timeframe sorted by 'in' variable: $query = "SELECT DISTINCT * FROM data WHERE out >= '$time' ORDER BY 'in' DESC"; The problem is that it duplicates entries on the 'user' variable which I would like to restrict to...
