|
although this might solve your problem:
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 AND votes.ip_address = '24.201.235.105'
WHERE date_start < now( )
ORDER BY date_start DESC
LIMIT 2 , 2;
try this on your mysql and tell me if it works...
__________________
The wiseman owns little but knows much, while the fool knows little but owns much
|