Forum Moderators: coopster
What to do now?
==============
<?php
mysql_connect(localhost,My_username,My_password);
@mysql_select_db(My_database) or die( "Unable to select database");
$query="SELECT * FROM My_table WHERE $findwhat LIKE '$findthis%' AND $findwhat2 LIKE '$findthis2%' order by last asc, first asc";
$result=mysql_query($query);
$num=mysql_numrows($result);
if ($num==0):
echo "<b><center><font color=#3300CC>No match found. Please go back and modify your search.</font>";
echo "<b><center><font color=#3300CC><input type=button value=Back onclick=history.back()></font><br>";
else:
echo "<b><center><font color=#3300CC><input type=button value=Back onclick=history.back()></font><br>";
echo "<b><center>Here are your search results for <font color=#3300CC><i> $findthis $findthis2</b></i>";
echo "<center><a href=http://My_domain/findid.htm> Click here to view info page</a></p>";
endif;
$numofrows = mysql_num_rows($result);
?>
<center>
<?php
echo "<TABLE BORDER=\"0\">\n";
echo "<TR bgcolor=\"#0066FF\"><TD><font color=\"#FFFFFF\">ID</TD>
<TD><font color=\"#FFFFFF\">F. Name</TD><TD><font color=\"#FFFFFF\">L. Name</TD>
<TD><font color=\"#FFFFFF\">Profession</TD>
<TD><font color=\"#FFFFFF\">City</TD><td><font color=\"#FFFFFF\">State</TD><TD><font color=\"#FFFFFF\">Country</TD>
<TD></TD></TR>\n";
for($i = 0; $i < $numofrows; $i++) {
$row = mysql_fetch_array($result);
if($i % 2) {
echo "<TR bgcolor=\"#F0F7FF\">\n";
} else {
echo "<TR bgcolor=\"#F9FFF9\">\n";
}
echo "<TD>"."<a href=http://My_domain/Do_This.php?id=$id>ID</a>".$row['id'].
"</TD><TD>".$row['FIRST']."</TD><TD>".$row['last'].
"</TD><TD>".$row['profession']."</TD><TD>".$row['city'].
"</TD><TD>".$row['state']."</TD><TD>".$row['country'].
"</TD><TD><center>"."</TD>\n";
echo "</TR>\n";
}
echo "<br></TABLE>\n";
if($numofrows > 10)
echo "<br><b><center><font color=#3300CC><input type=button value=Back onclick=history.back()></font><br>";
enfif
?>
==============
[edited by: coopster at 9:27 am (utc) on Sep. 1, 2004]
[edit reason] fixed sidescroll [/edit]
2. you'll probably want to read up more on php.net about using arrays and mysql
