problem adding record

[kathyc]

I'm using php3 and have successfully opened
an access database, and would now like to
be able to add a record. In my code, I
have the following string...

       ===================

$sQuery = "INSERT INTO EmailLog ";
$sQuery .= "('DateSent', 'SendersName', 'SendersEmail',";
$sQuery .= " 'SendersComments','LetterName', 'EmailedToList')"; $sQuery .= " VALUES ";

$sQuery .= "($dTodaysDate, $sName, $sEmail, $sPhone1, $sLetter, $sDbname)";

$iResult = odbc_exec($iConnect, $sQuery);

print "$iResult";

---

This code isn't working and I'm trying
to figure out what I've missed.

Can someone please help me out.

[Anon]

Try taking the single quotes off of the table fields and place them around the values.

===================
$sQuery = "INSERT INTO EmailLog ";
$sQuery .= "(DateSent, SendersName, SendersEmail,";
$sQuery .= " SendersComments,LetterName, EmailedToList)"; $sQuery .= " VALUES ";

$sQuery .= "('$dTodaysDate', '$sName', '$sEmail', '$sPhone1', '$sLetter', '$sDbname')";

$iResult = odbc_exec($iConnect, $sQuery);

print "$iResult";

Chad

[[deleted]]

Remove the quotes from the field names, and put them around the values.
INSERT INTO table (field1,field2) VALUES ("hello","there");