I've been searching all over the internet for an answer to this problem but I'm still stuck. I have a table in my DB that was made with this code:
CREATE TABLE searches (id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, search VARCHAR(255) NOT NULL, datum DATE NOT NULL)
and I am using PHP to insert searches into it like so:
<?php $date = date('Y-m-d'); $queryW = "INSERT DELAYED INTO searches VALUES (NULL, '$search','$date')"; mysql_query($queryW) or print('Problem adding to Db: '.mysql_error()); ?>
But it inserts the same record twice and I have no idea why it does that. As far as I can see my php is sound and other inserts work fine. Please help.