Code: Select all
<?php
$linkID = mysql_connect("localhost","","");
if ($linkID != false)
{
print "connection successfull<br>";
}
else
{
print "connection failed";
}
mysql_select_db("ymca", $linkID);
if ($search == "")
{$search = '%';}
$result = mysql_query ("SELECT * FROM members
WHERE lastname LIKE '%$search%'
");
print "<table width=500 valign=top align=center border=1 cellpadding=0 cellspacing=0 bordercolor=#000000>";
print "<tr>";
print "<td width=500 height=0 valign=top>";
print "<form name=search method=post action=search.php>";
print "<table valign=top width=500 height=129 border=1 cellpadding=0 cellspacing=10 bordercolor=#FFFFFF>";
print "<tr bordercolor=#FFFFFF>";
print "<td nowrap bgcolor=#EBEBEB><div align=left><font size=2>Search Members<font face=Times New Roman, Times, serif></font></font>";
print "</div></td>";
print "<td height=12 rowspan=3 nowrap bordercolor=#000000> <div align=center><img src=images/mysql.jpg width=167 height=87></div></td>";
print "</tr>";
print "<tr bordercolor=#FFFFFF>"; //line 35
print "<td width=204 height=53 nowrap><font size=2><font face=Times New Roman, Times, serif>";
print "<input name=search type=text id=search2 size=29>";
print "<input name=membersearch type=submit id=membersearch2 value=Search>";
print "</font></font></td>";
print "</tr>";
print "<tr bordercolor=#FFFFFF>";
print "<td height=17 nowrap bgcolor=#EBEBEB><font size=2><a href=mailto:sdiver1500@aol.com>Contact Administrator</a> </font></td>";
print "</tr>";
print "</table>";
print "</form>";
print "<table width=500 height=0 border=0 cellpadding=0 cellspacing=10>";
print "<tr bgcolor=#EBEBEB>";
print "<td width=13 bgcolor=white><font size=2>&nbsp;</font></td>";
print "<td width=0 nowrap><font size=2>Last Name</font></td>";
print "<td width=0 nowrap><font size=2>Card Number</font></td>";
print "<td width=0 nowrap><font size=2>Home Phone Number</font></td>";
print "</tr>";
if ($row = mysql_fetch_array($result)) {
do { print "<tr>";
print "<td><font size=2>";
print "<input type=checkbox name=checkbox value=checkbox>";
print "</font></td>";
print "<td nowrap><font size=2>";
print $rowї"lastname"];
print "</font></td>";
print "<td nowrap><font size=2>";
print $rowї"cardnum"];
print "</font></td>";
print "<td nowrap><font size=2>";
print $rowї"homenum"];
print "</font></td>";
} while($row = mysql_fetch_array($result));
} else {print "Sorry, no records were found!";}
print "</tr>";
print "</table></td>";
?>