$ connect = mysql_connect ('localhost', 'root', ''); $ db = mysql_select_db ('soc_pasport');

$sname=$_POST['sname'];//имя $fname=$_POST['fname'].//фамилия $tname=$_POST['tname'];//отчество $group=$_POST['group'];//группа $date=$_POST['date'];//дата рожд $gender=$_POST['gender'];//пол $nation=$_POST['nation'];//нация $disability=$_POST['disability'];//инваоидность $place=$_POST['place'];//местный или нет $oblast=$_POST['oblast'];//область $how=$_POST['how'];//с кем живет $family=$_POST['family'];//семья $how1=$_POST['how1'];// семья $uchet=$_POST['uchet'];// на учете? if(isset($_POST['send'])){ mysql_query("ALTER TABLE full_name AUTO_INCREMENT=1"); mysql_query("INSERT INTO full_name(surname,name,third_name) VALUES('$sname','$fname','$tname')"); mysql_query("ALTER TABLE student AUTO_INCREMENT=1"); mysql_query("INSERT INTO student(groupName,date,gender) VALUES('$group','$date','$gender')"); } mysql_close;
  • when I send a request to attach studen group values, dates and gender to the table, they do not appear in the database - As Lan

1 answer 1

It is not necessary:

 mysql_query("ALTER TABLE full_name AUTO_INCREMENT=1");

When you add a new line, it is automatically assigned a new number, 1, 2, 3 ..

And you always put on 1