SQL select - while verknüpfen

[tom]

hey people.

SELECT ip FROM counter WHERE TO_DAYS(NOW()) - TO_DAYS(time) < 1 and where ip = '0.0.0.0'

wisst ihr was da falsch dran ist??

no peil mehr...

thx tom