View Single Post
Old 09-30-2003, 08:10 PM  
Mortimer
Confirmed User
 
Join Date: Oct 2002
Location: Where the hell am I now?
Posts: 153
Quote:
Originally posted by extreme
Uhm ...



... LEFT JOIN votes ON votes.code = update_info.code ... ?

seems about right to me
would give the following query:

SELECT update_info.code, update_info.collection, update_info.short_name, UNIX_TIMESTAMP(update_info.date_start) AS date_start, update_info.total_votes, update_info.total_score, votes.ip_address
FROM update_info
LEFT JOIN votes ON votes.code = update_info.code
WHERE date_start < now( )
ORDER BY date_start DESC
LIMIT 2 , 2;
__________________
The wiseman owns little but knows much, while the fool knows little but owns much
Mortimer is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote