01. <table border=1 align="center" / >
02.<tr bgcolor='#3399FF'><th height="30" valign="top" bgcolor="#99CCFF">ID</th>
03.<th width="160" bgcolor="#99CCFF">Name</th>
04.<th width="133" bgcolor="#99CCFF">Company </th>
05.<th width="150" bgcolor="#99CCFF">Position </th>
06.<th width="111" bgcolor="#99CCFF">Mobile Phone</th>
07.<th width="233" bgcolor="#99CCFF">E-mail </th>
08.<th width="auto" bgcolor="#99CCFF">Check </th>
09.
10.</tr>
11.<p>
12. <?
13. $sql="select * from member where name like '%".$_GET["txtKeyword1"]."%' || surname like '%".$_GET["txtKeyword1"]."%' || company like '%".$_GET[txtKeyword1]."%' || position like '%".$_GET[txtKeyword1]."%' order by id asc ";
14.
15.$result=mysql_db_query($dbname,$sql);
16.$x=1;
17. while($row=mysql_fetch_array($result))
18.
19. {
20.
21.echo"<td>",$x,"</td>";
22.$id = $row['id'];
23. echo"<td>",$row["name" ]." ". $row["surname"],"<center/></a></td>";
24. echo"<td>",$row["company"],"</td>";
25. echo"<td>",$row["position"],"</td>";
26. echo"<td>",$row["mobile"],"</td>";
27. echo"<td>",$row["email"],"</td>";
28.
29. if ($row["add"] == "y"){
30. echo"<td><a href=\"save_edit.php? id=$id &f=1\">
31. <center/><img src=\"image/yep.png \" ></a><input name = 'add' type='hidden' value='n'></td>";}
32. else if ($row["add"] == "n" || " ") {
33. echo"<td><a href=\"save_edit.php? id=$id &f=2\">
34. <center/><img src=\"image/delete.gif \" ></a><input name = 'add' type='hidden' value='y'></td>";}
35.
36.
37. echo"</tr>";
38.
39.
40.
41.$x++;
42. }
43.
44.
45.?>
46.</p>
47.</table>
