with any string.
I don't see you entering any questionmarks.
I see you defining an insert command that uses placeholders for the values entered in the execute statement.
You are entering the string "now()" where you probably want the value for the function now(). Leave off the quotes.
Daneman wrote:
At 14:25 24-2-03 -0600, gerald_clark wrote: And you still have not shown us how you are entering the question marks.
Like this:
$sql = qq{ INSERT INTO main (id, categorie, achternaam, voornaam, aanspreektitel, straat, huisnummer, postcode, plaatsnaam, telefoon, mobiel, email1, email2, tekst) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?) };
$sth = $dbh->prepare( $sql);
$sth->execute($id, "now()", $achternaam, $voornaam, $aanspreektitel, $straat, $huisnummer, $postcode, $plaatsnaam, $telefoon, $mobiel, $email1, $email2, $tekst);
(BTW: the "now()" value results in an empty (0000.00.00 etc) date field)
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
