<tr>
<td align= "right" >
<form action= "lisa.php"  method= "post" >Code:</td>
<td><input type= "text"  name= "code"  size= "30 " maxlength= "11 "></td>
</tr>
<tr>
<td align= "right" >Last name:</td>
<td><input type= "text"  name= "lastname"  size= "30 " maxlength= "40 "></td>
</tr>
<tr>
<td align= "right" >First name:</td>
<td><input type= "text"  name= "firstname"  size= "30 " maxlength= "40 "></td>
</tr>
<tr>
<td colspan= "2 " align= "center" ><input type= "submit"  name= "submit"  value= "Add" > <input type= "reset"  value= "Cansel" ></form></td>
</tr>

if ($submit)
{
echo '<tr><td colspan="2" align="center">';
$mustbe = array('code', 'lastname', 'firstname'); 
$error= ""; 
for($i=0 ; $i<sizeof($mustbe);$i++) 
	{  
    if (!strlen($HTTP_POST_VARS[$mustbe[$i]]))  
    $error = $mustbe[$i];  
	}  
if(strlen($error)) 
	{ 
    echo '<p class="error">Error!</p>Please fill all form fields.';  
	} 
else 
	{  
$lastname = addslashes($_POST['lastname']);
$firstname = addslashes($_POST['firstname']);
$code = addslashes($_POST['code']);
$number_q = mysql_query("SELECT MAX(card) AS number FROM registr WHERE LEFT(lastname, 1 ) = LEFT(\ "$lastname\" , 1 ) AND lastname < \ "$lastname\"  ") or die();
if(!mysql_num_rows($number_q)) 
{
$number = 1 ;
}
else {
    $rida = mysql_fetch_array($number_q);
    $number = $rida["number "] + 1 ;
}
mysql_query("INSERT INTO registr (id, code, lastname, firstname, card) VALUES ( 0 ,\ "$code\" ,\ "$lastname\" ,\ "$firstname\" ,\ "$number\" )") or die();
	echo 'Data added successfully. Card number is &number.';
	}
echo '</td></tr>';
}