Paul Fitz wrote:
You haven't done that a thousand times - the syntax is wrong :). You are using a combo of INSERT and UPDATE syntax there.
INSERT INTO log (term, returns, time, date, ip) VALUES ('$search', '$arrayword',CURTIME(), CURDATE(), '$ip');
From: Axel IS Main [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 7:06 PM
Subject: [PHP-DB] What's wrong with this query?
I've just tried to do something I've done a thousand times. It does not work. I've checked all of the syntax, made sure the field and variable names are correct. No matter what I do it just doesn't work. The table remains empty. Here's the query:
$logit = mysql_query("INSERT INTO log SET term='$search', returns='$arrayword', time=CURTIME(), date=CURDATE(), ip='$ip'");
Now that doesn't look too difficult does it? Well, apparently it's impossible! I'm really hoping someone out there can see something that I
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php