Damien wrote:You could use SQL's DISTINCT keyword, but that would only work if every> Can you stop pulling out exactly the same data from a database, for
> example, if you had 2 entries which had the name Chris, it would only
> print Chris once?
row in your resultset would be a match.
for instance, given the table
fname | lname
Chris | Smith
Chris | Jones
SELECT DISTINCT(fname) FROM tblName WHERE fname='Chris' would work, where
SELECT DISTINCT(*) FROM tblName WHERE fname='Chris' wouldn't.
You might be able to do it with some nasty JOINs but those are evil and
kill your performance.