my this file is not working can you tell me the mistake
<html><head><title>Add record to my_database/my_table</title></head>
<body>
<form action ="<?php echo($PHP_SELF);?>" method="post">
SNo. <input type = "text" name = "sno" size="3">
Name: <input type = "text" name="name" size="25">
Project :<input type="text" name="project" size="2"><br>
class :<input type="text" name="class" size="2"><br>
no_of_studs :<input type="text" name="children" size="2"><br>
year:<input type="text" name="year" size="2"><br>
father name :<input type="text" name="father_name" size="25"><br>
mother name :<input type="text" name="mother_name" size="25"><br>
Location :<input type="text" name="location" size="25"><br>
father edu :<input type="text" name="father_edu" size="3"><br>
mother edu :<input type="text" name="mother_edu" size="3"><br>
father job :<input type="text" name="father_job" size="10"><br>
mother job :<input type="text" name="mother_job" size="10"><br>
housing :<input type="text" name="housing" size="10"><br>
caste :<input type="text" name="caste" size="4"><br>
<input type = "submit" value ="Submit">
</form>
<?php
$conn = mysql_connect("localhost" ,"root", "");
#echo($conn);
$rs = mysql_select_db("student", $conn) or die("Err😃b");
#create the query
$sql = "INSERT into st_per_details(sno,project,class,children,year,father_name,mother_name,location,father_edu,mother_edu,father_job,mother_job,housing,caste)values($sno,'0',$project,$class,$children,$year,\"$father_name\",\"$mother_name\",\"$location\",\"$father_edu\",\"$mother_edu\",\"$father_job\",\"$mother_job\",\"$housing\",\"$caste\")";
$rs=mysql_query($sql);
if($rs){echo("Record added:$sno");}
?>
</body>
</html>
I don't know what to do
an early reply would be highly appreciated.
-ASHUTOSH
