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.
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.