delete table in php with mysql

connection.inc.php :

<?php
$host='localhost';
$user_name='root';
$password='';
@$con = mysql_connect("$host","$user_name","$password");
if ($con)
 {echo '<br>host coonected<br>';}
else
  {
  die('Could not connect ');
  }
?>

del_table.php :

<?php

require 'connection.inc.php';

if (mysql_select_db('test'))
if(mysql_query("delete from test where sno = 1",$con))
  {  $result=mysql_query("select * from test where sno = 1",$con);
     echo "<br><table><tr><td>sno</td><td>name</td></tr>";
     while($data = mysql_fetch_array($result))
  {
  echo "<tr><td>".$data['sno'] . "</td><td>" .$data['name']."</td></tr>";
  }
  echo "</table><br>data deleted<br>";
  }
else
  {
  echo '<br>data not selected :'.mysql_error().'<br>';
  }

mysql_close($con);
?>



run " del_table.php "

output :


host coonected

sno

name

data deleted