Download Firefox: WindowsMac OS X
logo       
Google Custom Search
    AddThis Social Bookmark Button

[ILUG-Webdev] SQL Query: msg#00009

Subject: [ILUG-Webdev] SQL Query
I couldn't resist playing with that Google stuff after my last post and
ended up rewriting my feed reader* using teh magic, via this article:

http://jibbering.com/2002/4/httprequest.html

Quick resultant SQL question: For the resultset that loads by default I
really only want one story from each source. I thought I could use
DISTINCT `source`, but that'll only pull the results from the DISTINCT
column and of course I want all the data. Can I use UNION or something?

I'm sure I've asked this very question before, but I can't find the answer
in my archives.

adam


* OLD: http://beecher.ie/pheed/
  NEW: http://beecher.ie/pheeds/
  (Yes I know I should be using XML for the data and yes I know I
shouldn't be using pipe as a separator; I just threw it together, cut me
some slack! :)



-- 
ILUG Web Development
http://mail.linux.ie/mailman/listinfo/webdev/



<Prev in Thread] Current Thread [Next in Thread>