السلام عليكــم ورحمـة الله وبركاتــه يا اخوان ابي المساعدة العاجلة في هالكود وشكرا لانه يرجع لي كل شيء موجود في الجدول ابيه يرجع لي بس الشيء اللي احدده في البحث
<html>
<center>
<form action= formtest7.php method=post>
Name:<input type=text name=name size=20><p>
Job: <input type=text name=artist size=20><p>
search item description?
<input type=radio name=description>Yes</input>
<input type=radio name=description checked>No</input><p>
<input type=submit name=full value=search>
</form>
</center>
</html>
<?php
echo "<html dir=rt1>";
echo "<TITLE> Show Record </TITLE>";
$conn = mysql_connect ("localhost" , "root" , "");
$db=mysql_select_db("movie_star");
$field_t0_search="name";
$result =mysql_query ("select emp_no , name , job , salary ,bonus , date from employees where $field_t0_search like \"%trimmed%\" order by name");
//if ($trimmed == "")
{
//echo "<p>Please enter a search.... </p>";
exit;
}
if (!isset($var))
{
echo "<p>Search parameter missing!</p>";
exit;
}
$numresults = mysql_query($query);
$numrows = mysql_numrows($numresults);
if ($numrows == 0)
{
echo "<h4>Results</h4>";
//echo "<p>Sorry your search: "". $trimmed."" returned zero results</p>";
}
if (empty($s))
{
$s = 0;
}
//get results
$result = mysql_query($query) or die("Could'nt execute");
if($numrows > 1 ) { $return = "results";}
else{ $result = "result";}
//echo "<p>Your search for "". $var. "" returned $numrows $return.</p>";
$count = 1 +$s;
//لرسم حدود الجدول لاخراج نتيجة البحث
echo "<table border=2 cellpadding=0 cellpadding=0
style=border-collapse: collapse bordercolor=#111111
width=50%> ";
echo "<td width=10%
align=center bgcolor=#FF0000> Emp_no </td>";
echo "<td width=30%
align=center bgcolor=#FF0000> Name</td>";
echo "<td width=30%
align=center bgcolor=#FF0000> Job</td>";
echo "<td width=30%
align=center bgcolor=#FF0000> Salary</td>";
//echo "<td width=30%
//align=center bgcolor=#FF0000> Bonus</td>";
//echo "<td width=30%
//align=center bgcolor=#FF0000> Date</td>";
//لطباعة البيانات في الجدول
while ($row = mysql_fetch_array ($result))
{
echo "<tr>";
echo "<td width=10%
align=center bgcolor=#FF00FF> $row[emp_no] </td>";
echo "<td width=30% align=center > $row[name] </td>";
echo "<td width=30% align=center > $row[job] </td>";
echo "<td width=30% align=center > $row[salary] </td>";
//echo "<td width=30% align=center > $row[bonus] </td>";
//echo "<td width=30% align=center > $row[date] </td>";
echo "</tr>";
}
echo "</table>";
mysql_free_result ($result);
mysql_close ($conn);
?>