Kanske du glömt SELECT först i satsen? 
Sen om "visad" är av typen int så ska det vara visad=0 istället.
Trådstart#1
Får det här fel meddelandet:
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[TCX][MyODBC]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'texten,memb FROM live_mess WHERE visad='0' AND DAYOFMONTH(dat
/live.asp, line 23
SQL satsen:
SQL = " texten,memb FROM live_mess "& _
" WHERE visad='0' AND " & _
" DAYOFMONTH(datum) = DAYOFMONTH(CURDATE()) " & _
" AND MONTH(datum) = MONTH(CURDATE()) " & _
" AND YEAR(datum) = YEAR(CURDATE()) ORDER BY datum DESC LIMIT 24"
Bara SQL satsen utskriven:
texten,memb FROM live_mess WHERE visad='0' AND DAYOFMONTH(datum) = DAYOFMONTH(CURDATE()) AND MONTH(datum) = MONTH(CURDATE()) AND YEAR(datum) = YEAR(CURDATE()) ORDER BY datum DESC LIMIT 24
kolumnen datum är av typen DATETIME
