ok 2 part problem first code
<php>
<html>
<head>
<title>ADD/invoice entry</title>
<style type="text/css">
TD {color:#353535; font-family:verdana}
TH {color:#FFFFFF: font-family:vendanabackground-color:#336699}
<H1> Please enter the invoice </H1>
</style>
</head>
<body>
<form action="invopro.php?action=add&type=data" meathod="post">
<table border="0" cellspacing="1" cellpadding="3"
bgcolor="#353535" align="center">
<tr>
<td bgcolor=#FFFFFF" width="50%">Invoice Number</td>
<td bgcolor="FFFFFF" width="50%">
<input type="text" name="invo_num">
</td>
</tr>
<tr>
<td bgcolor=#FFFFFF">Type of Product</td>
<td bgcolor=#FFFFFF">
<select name="type_prod">
<option value="Food">Food</option>
<option value="Wine">Wine</option>
<option value="Beer">Beer</option>
<option value="Liquor">Liquor</option>
<option value="Misc">Misc</option>
</select>
</td>
</tr>
<tr>
<td bgcolor=#FFFFFF" width="50%">Product Discreption</td>
<td bgcolor="FFFFFF" width="50%">
<input type="text" maxlength="40" name="prod_desc">
</td>
</tr>
<tr>
<tr>
<td bgcolor=#FFFFFF" width="50%">Date</td>
<td bgcolor="FFFFFF" width="50%">
<input type="date" maxlength="10" name="date_invo">
</td>
</tr>
<tr>
<td bgcolor=#FFFFFF" width="50%">Ammount</td>
<td bgcolor="FFFFFF" width="50%">
<input type="text" name="ammo_invo">
</td>
</tr>
<tr>
<td bgcolor ="#FFFFFF" colspan="2" align="center">
<input type="submit" name="SUBMIT" value="Add">
</td>
</tr>
</form>
</table>
</body>
</php>
now its going to this file
<php>
<?php
$connect = mysql_connect ("localhost", "some data", "some name") or die ("lost") ;
mysql_select_db("alifraz_bella") ;
switch ($_GET['action']) {
case"add":
switch ($GET['type']) {
case "data":
$sql="INSERT INTO purchf
(invoice_num,prod_type,desc_prod,date_purc,amm_pur)
VALUES
('" . $_POST ['invo_num'] ."',
'" . $_POST ['type_prod'] ."',
'" . $_POST ['prod_desc'] ."',
'" . $_POST ['date_invo'] ."',
'" . $_POST ['ammo_invo'] ."')";
break;
}
break;
}
if(isset($sql) && !empty($sql)) {
echo "!--" .$sql ."-->";
$result =mysql_query($sql)
or die ("lost: " . mysql_error());
?>
<p align="center" style="color:#FF0000">
Done. <a href="input.php">back</a>
</p>
<?php
}
</php>
don't give me any errors just blank page
