its me again help me if you can
my search page is not work in server please check my code below & find out what is wrong with it
Code:
<HTML>
<?php
include ('config.php');
if (isset($_POST['searchstring']))
{
$sql="SELECT * FROM personnel WHERE $searchtype LIKE '%$searchstring%' ORDER BY firstname ASC";
$result = mysql_query($sql);
echo "<TABLE BORDER=0 align=center>";
echo"<TR><td align=center width=190><B>الاجـــراء</B><td align=center width=190><B>الاسم واللقب</B><td align=center width=190><B>العنــوان</B></TR>";
while ($myrow = mysql_fetch_array($result))
{
echo "<TR><td align=center><a href=\"view.php?id=".$myrow["id"]."\">عرض</a>";
echo "<td align=center>".$myrow["firstname"]." ".$myrow["lastname"]."<td align=center>".$myrow["nick"];
}
echo "</TABLE>";
}
else
{
?>
<form method="POST" action="<?php $PHP_SELF ?>">
<table border="0" cellspacing="2" align=center>
<tr><td align=center width=190><b>مجال البحث</b></td>
<td align=center width=190><b>ادخل كلمة البحث</b></td></tr>
<tr>
<td align=center width=150>
<p dir="rtl"><select size="1" name="searchtype">
<option selected value="firstname">الاســـــم</option>
<option value="lastname">اللقــــب</option>
<option value="nick">العنوان</option>
<option value="email">البريد الالكتروني</option>
</select></td>
<td align=center width=150>
<p align="left" dir="rtl">
<input name="searchstring" size="22" style="float: right"></td>
</tr>
<tr><td colspan=3>
<p> <input type="submit" value="ابحث" name="B1" align=middle> <input type="reset" value="تراجع" name="B2"> </p>
</td></tr>
</table>
<p align="center"><b><span lang="ar-sa"><a href="serch.php">بحث جديد</a>
<a href="viewdb.php">عودة للقائمة</a></span></b></p>
</form>
<?php
}
?>
</HTML>
