I'm using MySQL database. The form works ok without the PHP insertion statement to MYSQL Can someone tell me what I'm doing wrong?
Thanks
<?php
include 'header.php'; ?>
<?php if (array_key_exists("submit", $_POST)) {
phpfunc();
?>
<CENTER>
<form method="POST" action="phpfunc()">
<table border="1" cellpadding="2" cellspacing="1" width="600" valign="top">
Required fields
<tr>
<td>E-mail Address: </td>
<td><input type="text" name="email" size="25" maxlength="50"/ ></td>
</tr>
<tr>
<td>First Name: </td>
<td><input type="text" name ="firstname" size="25" maxlength="50"/></td>
</tr>
<tr>
<td>Last Name: </td>
<td><input type="text" name ="last_name" size="25" maxlength="50"/></td>
</tr>
<tr>
<td>*Phone: </td>
<td><input type="text" name="Phone" size="25" maxlength="50"/></td>
</tr> </table>
<input type="Checkbox" CHECKED value="Y" name="subscription"/> Yes, please e-mail me <br>
<table border="0" cellpadding="0" cellspacing="0" width="600" valign="t
op">
</table><br><br>
<tr>
<td></td>
<td>
<table bgcolor="#990000" cellspacing="0" cellpadding="4" border="0">
<tr><td>
<input type='hidden' name='action' value='send'>
<input name="submit" type="submit" value="Enter" border="0"></td>
</tr>
</table></td>
</tr>
</FORM>
</CENTER>
<?php
dbConnectWrite();
function phpfunc() {
INSERT INTO commerce.sweepstakes values ('1', $POST['email'], $POST['firstname'], $POST['last_name'], $POST['Phone']);
} }
include 'footer.php'; ?>
