Hi, I found a tutorial for a mysql db search engine and I managed to get it working just fine. My problem is that I can't get the search results to display in multiple columns, I get one column with all the results instead. I figured out how to display data from the db horizontally but on a different page that has nothing to do with this one, I just can't figure out how to do it here.
So basically, right now the results are displayed like this:
<tr>
<td>
result1
</td>
</tr>
<tr>
<td>
result2
</td>
</tr>
<tr>
<td>
result3
</td>
</tr>
I'm trying to get them to be horizontal like this:
<tr>
<td>
result1
</td>
<td>
result2
</td>
<td>
result3
</td>
</tr>
I found out that I need to use the modulus operator. I just can't figure out how to integrate that with this script!
Any help would be greatly appreciated!
Here's the code from the db search tutorial I used:
<HTML>
<?php
if ($searchstring)
{
$sql="SELECT * FROM personnel WHERE $searchtype LIKE '%$searchstring%' ORDER BY firstname ASC";
$db = mysql_connect("localhost", "root", "");
mysql_select_db("learndb",$db);
$result = mysql_query($sql,$db);
echo "<TABLE BORDER=2>";
echo"<TR><TD><B>Full Name</B><TD><B>Nick Name</B><TD><B>Options</B></TR>";
while ($myrow = mysql_fetch_array($result))
{
echo "<TR><TD>".$myrow["firstname"]." ".$myrow["lastname"]."<TD>".$myrow["nick"];
echo "<TD><a href=\"view.php?id=".$myrow["id"]."\">View</a>";
}
echo "</TABLE>";
}
else
{
?>
<form method="POST" action="<?php $PHP_SELF ?>">
<table border="2" cellspacing="2">
<tr><td>Insert you search string here</td>
<td>Search type</td></tr>
<tr>
<td><input type="text" name="searchstring" size="28"></td>
<td><select size="1" name="searchtype">
<option selected value="firstname">First Name</option>
<option value="lastname">Last Name</option>
<option value="nick">Nick Name</option>
<option value="email">Email</option>
</select></td>
</tr>
</table>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
<?php
}
?>
</HTML>
