why this sql code dont work
<pre><code>&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;
&lt;head&gt;

&lt;meta http-equiv="Content-Type" content="text/html; charset=windows-1256"&gt;
&lt;title&gt;اول اسكربت باذن الله&lt;/title&gt;
&lt;/head&gt;

&lt;body&gt;
&lt;table width="100%" border="1"&gt;
 &lt;tr&gt;
    &lt;td&gt;name&lt;/td&gt;
    &lt;td&gt;number&lt;/td&gt;
    &lt;td&gt;math&lt;/td&gt;
    &lt;td&gt;arab&lt;/td&gt;
    &lt;td&gt;history&lt;/td&gt;
    &lt;td&gt;geo&lt;/td&gt;

  &lt;/tr&gt;


&lt;?php


require_once "conf.php";

$sql2=("SELECT * FROM student WHERE snum = $ss");
$rs2 = mysql_query($sql2) or die(mysql_error());
$num = mysql_num_rows($rs2);
$ss= $_POST["ss"];

if (empty($ss))
{ echo "please write your search words";}
else if ($num &lt; 1 )   {
   echo  "not found any like ";

}else {
$sql=("SELECT * FROM student WHERE snum = $ss ");
$rs = mysql_query($sql) or die(mysql_error());



while($data=mysql_fetch_array($rs)){
$name=$data["sname"];
$number=$data["snum"];
$math=$data["math"];
$arab=$data["arab"];
$history=$data["history"];
$geo=$data["geo"];





echo"
  &lt;tr&gt;
    &lt;td&gt;$name&lt;/td&gt;
    &lt;td&gt;$number&lt;/td&gt;
    &lt;td&gt;$math&lt;/td&gt;
    &lt;td&gt;$arab&lt;/td&gt;
    &lt;td&gt;$history&lt;/td&gt;
    &lt;td&gt;$geo&lt;/td&gt;
  &lt;/tr&gt;
";


}
 };
?&gt;
 &lt;/table&gt;
&lt;/body&gt;
&lt;/html&gt;
</code></pre>
