View Single Post
Old 05-24-2005, 03:09 AM   #5 (permalink)
insitedev
Inactive
 
insitedev's Avatar
 
Join Date: 12-14-04
Posts: 108
iTrader: 0 / 0%
Latest Blog:
None

insitedev is liked by somebodyinsitedev is liked by somebodyinsitedev is liked by somebodyinsitedev is liked by somebody
well.. you could try a couple things.

1. use DISTINCT in the query (SELECT DISTINCT [columns] WHERE .....)
2. use a GROUP BY in the query (SELECT [columns] WHERE ..... GROUP BY [uniquecolumn])

By "uniquecolumn" I mean something that would be common only if the two results were identical (such as the id).
insitedev is offline   Reply With Quote