Quote:
Originally posted by Mortimer
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...
|
NICE, that's what I wanted to do, exactly ;)
+---------+------------+------------+------------+-------------+-------------+----------------+
| code | collection | short_name | date_start | total_votes | total_score | ip_address |
+---------+------------+------------+------------+-------------+-------------+----------------+
| anna01 | hardcore | Anna T | 1064373796 | 0 | 0 | NULL |
| jenny01 | blowjob | Jenny J | 1064286997 | 0 | 0 | 24.201.235.105 |
+---------+------------+------------+------------+-------------+-------------+----------------+
2 rows in set (0.00 sec)