SQL Problem

Hello,

I have got a PHP script and when I try to execute this SQL

DELETE FROM clanky WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(datum_publikacie) >*1209600;

then it says that “Unknown table 1209600” … How to solve it?

Thanks for any answers!
Jake

Are you using the correct spellings for the table name

What’s the * for there? Try removing it:


DELETE FROM `clanky` WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(`datum_publikacie`) > 1209600;