Newbie Can't seem to get it Right, please help if you can

[ElonnaT]

I have created a .php file and an ihtml file. I have to take information from a form to poat into a mySQL table. I had it working then due to an ftp issue, my files got corrupted and I had to start over. I can not get it to write to the table now. I thought I did the same thing as I had originally done, but obviously not since it is not working. Here is the code for each file:

PHP file (.pml)

<?
$required_fields = array(
name => "Name",
address => "Address",
city => "City",
state => "State",
zip => "Zip",
phone => "Phone",
cg_age => "Age"
);

$errors_num = 0;
$errors_string = "";

while(list($f_name, $f_title) = each($required_fields))
{
$sTmp = "";
eval("\$sTmp = \$$f_name;");

if($sTmp == "")
{
$errors_num++;
$errors_string .= "$errors_num. Field $f_title is required.<br>\n";
}
}

// If no errors, Continue

if(!$errors_num)
{
$sql = "INSERT INTO dt_car_giveaway (name, address, city, state, zip, phone, email, cg_age) VALUES ('$name', '$address', '$city', '$state', '$zip', '$phone', '$email', '$cg_age')";
q($sql);
}
if(!$errors_num)
{
q("UPDATE dt_car_giveaway SET name='$name'");
q("UPDATE dt_car_giveaway SET address='$address'");
q("UPDATE dt_car_giveaway SET city='$city'");
q("UPDATE dt_car_giveaway SET state='$state'");
q("UPDATE dt_car_giveaway SET zip='$zip'");
q("UPDATE dt_car_giveaway SET phone='$phone'");
q("UPDATE dt_car_giveaway SET email='$email'");
q("UPDATE dt_car_giveaway SET cg_age='$cg_age'");

}

include "car/car_giveaway_finish.ihtml";

?>

HTML file (.ihtml)

<table width="100%" border="0" cellspacing="2" cellpadding="2" align="center">
<form action="car_giveaway.pml" method=post>
<!-- GENERAL INFO -->
<tr>
<td width="33%"><div align="center"><img src="car/Q100sm.jpg" width="220" height="125"></div></td>
<td width="33%"><div align="center"><img src="car/rock106sm.jpg" width="240" height="144"></div></td>
<td width="34%"><div align="center"><img src="car/wcoasm.jpg" width="211" height="106"></div></td>
</tr>
<tr>
<td colspan="3">&nbsp;</td>
</tr>
<tr>
<td colspan="3"><div align="center"><img src="car/register_here.gif" width="654" height="78"></div></td>
</tr>
<tr>
<td colspan="3"><div align="center"><img src="car/2003_mustang.gif"></div></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><div align="center"><strong><font size="5">From</font></strong></div></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><img src="car/gbford.gif" width="320" height="64"></td>
<td><div align="center"><strong><font size="5">And</font></strong></div></td>
<td><img src="car/wford.gif" width="217" height="64"></td>
</tr>
<tr>
<td colspan="3">&nbsp;</td>
</tr>
<tr>
<td><div align="right"><strong><font face="Arial, Helvetica, sans-serif">Name:
&nbsp;</font></strong></div></td>
<td colspan="2"><input maxlength=50 size=50 name=name value="<? echo $name ?>">
</td>
</tr>
<tr>
<td><div align="right"><strong><font face="Arial, Helvetica, sans-serif">Address:
&nbsp; </font></strong></div></td>
<td colspan="2"><input maxlength=50 size=50 name=address value="<? echo $address ?>">
</td>
</tr>
<tr>
<td><div align="right"><strong><font face="Arial, Helvetica, sans-serif">City:
&nbsp; </font></strong></div></td>
<td colspan="2"><input maxlength=30 size=30 name=city value="<? echo $city ?>">
</td>
</tr>
<tr>
<td><div align="right"><strong><font face="Arial, Helvetica, sans-serif">State:
&nbsp; </font></strong></div></td>
<td colspan="2"><input type=text maxlength=2 size=2 name=state value="<? echo $state ?>">
</td>
</tr>
<tr>
<td><div align="right"><strong><font face="Arial, Helvetica, sans-serif">Zip:
&nbsp; </font></strong></div></td>
<td colspan="2"><input maxlength=10 size=10 name=zip value="<? echo $zip ?>">
</td>
<tr>
<td><div align="right"><strong><font face="Arial, Helvetica, sans-serif">Phone:
&nbsp; </font></strong></div></td>
<td colspan="2"><input maxlength=20 size=20 name=phone value="<? echo $phone ?>">
</td>
</tr>
<tr>
<td><div align="right"><strong><font face="Arial, Helvetica, sans-serif">Email:
&nbsp; </font></strong></div></td>
<td colspan="2"><input maxlength=50 size=50 name=email value="<? echo $email ?>">
</td>
</tr>
<tr>
<td><div align="right"><strong><font face="Arial, Helvetica, sans-serif">Age:
&nbsp; </font></strong></div></td>
<td colspan="2"><input maxlength=3 size=3 name=cg_age value="<? echo $cg_age ?>">
</td>
</tr>
<tr>
<td>&nbsp;</td>
<td height="25" bgcolor="#6A9185" align=center> <input type="submit" value="Register">
</td>
</tr>
</form>
<tr>
<td><div align="center"><img src="car/mustang1sm.jpg"></div></td>
<td>&nbsp;</td>
<td><div align="center"><img src="car/mustang2sm.jpg"></div></td>
</tr>
</table>

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

I am not sure if form statement is set up incorrectly, or if I have some error in my .php file...I just can not get it to update the database table. If anyone has any ideas, I would be very greatful.

Thank you.

[Norman_Graham]

What is 'q'? And I don't understand your INSERT and UPDATE routine - you want to insert and then update with exactly the same data? You also have a nested 'if' statement without any closing routine (such as else{}). Did you inherit this code from someone else or copy it from the Internet? Or have I just completely misunderstood your intentions? I think you want something like this:

if(!$errors_num) 
{
$sql = "INSERT INTO dt_car_giveaway (name, address, city, state, zip, phone, email, cg_age) VALUES ('$name', '$address', '$city', '$state', '$zip', '$phone', '$email', '$cg_age')";

$db_insert = mysql_query($sql);

print "You're done!"; // Or similar ...

} 
else 
{ 
// Code to display errors
} 
?> 

HTH

Norm

[ElonnaT]

I took two other files that performed the same type of function and copied and modified them. There seems to be pieces missing though. I think there should be an easier way to do this. Yes, I thought the update was a little odd too right after the insert. I modified the code as you suggested, but still does not work. I think it might be more straight forward if I can combine the php and html files into one?

UPDATE: I found another post that helped me resolve this issue. Thank you for your help.