problem adding record

admin

Administrator
Staff member
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.
 
Back
Top