View Single Post
Old 09-30-2003, 08:08 PM  
Penthouse_mike
Confirmed User
 
Industry Role:
Join Date: Jun 2003
Location: Silicon Valley
Posts: 317
I assumed you are getting the ip to check from your program not from mysql

SELECT u.code,
u.collection,
u.short_name,
UNIX_TIMESTAMP(u.date_start) AS date_start,
u.total_votes,
u.total_score,
v.code,
v.ip_address

FROM update_info u,
votes v

WHERE u.date_start < now( )
AND u.code = v.code
AND v.ip_address = '$IP'

ORDER BY u.date_start DESC
Penthouse_mike is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote