
hancocj
Novice
Nov 7, 2002, 3:38 PM
Post #3 of 5
(11407 views)
|
Re: [RedRum] Update & Insert Syntax Problems
[In reply to]
|
Can't Post
|
|
I'm sure you're right could you help me get this right. Here is what I have so far but I am still getting a syntax error. $META_TEXT = $dbh->quote($META_TEXT); $PARSED_TEXT = $dbh->quote($PARSED_TEXT); if ( $url ne "" ) { $dbh->do("update Parent set meta = $META_TEXT, text = $PARSED_TEXT, time = NULL WHERE url=$url") or die "Cannot do: " . $dbh->errstr(); } else { $dbh->do( "insert into Parent values ( id, $parent, $META_TEXT, text = $PARSED_TEXT, NULL )") or die "Cannot do: " . $dbh->errstr(); }
|