Hi,
I have a simple search for my site, I will post it below. the search works fine but my problem is I want to get the results to come out in a spercific order, which will be displayed in two colum's. How owuld I do this?
Thanks
<?php
if ($cat && $ne && $sub && $key) // perform search only if a string was entered.
{
mysql_connect() or die ("Problem connecting to testbrissy");
$search1="%".$cat."%";
$search2="%".$ne."%";
$search3="%".$sub."%";
$search4="%".$key."%";
$query = "select * from testbrissy WHERE (category LIKE '$search1') AND (nesw LIKE '$search2') AND (suburb LIKE '$search3') AND (id LIKE '$search4' || name LIKE '$search4' || address LIKE '$search4' || suburb LIKE '$search4' || nesw LIKE '$search4' || email LIKE '$search4' || web LIKE '$search4' || template LIKE '$search4' || category LIKE '$search4')";
$result = mysql_db_query("test_database", $query);
if ($result)
{
echo "<font><b>Here are the results:</b></font><br>
<table width=100% align=center border=0>
<tr>
<td align='left' bgcolor='White' valign='middle'><h4><font>Business Details</font></h1></td>
<td align='right' bgcolor='White' valign='middle'><h4><font>Category</font></h1></td>
</tr>
</table>";
while ($r = mysql_fetch_array($result)) { // Begin while
$id = $r["id"];
$name = $r["name"];
$address = $r["address"];
$phone = $r["phone"];
$fax = $r["fax"];
$suburb = $r["suburb"];
$nesw = $r["nesw"];
$email = $r["email"];
$web = $r["web"];
$template = $r["template"];
$category = $r["category"];
$keywords = $r["keywords"];
$background = $r["background"];
$font = $r["font"];
$image = $r["image"];
echo "<table width=100% align=center border=0 bgcolor='$background'>
<tr>
<td align=left><font face='$font'><b><u>$name</u></b></font></td>
<td rowspan='6' valign='top' align='right'><font>$category</font></td>
</tr>
<tr><td align=left><font face='$font'>$address</font></td>
</tr>
<tr>
<td align=left><font face='$font'>$phone</font></td>
</tr>
<tr>
<td align=left><font face='$font'>$fax</font></td>
</tr>
<tr>
<td align=left><a href=mailto:$email>$email</a></td>
</tr>
<tr>
<td align=left><a href=http://$web>$web</a></td>
</tr>
<tr>
<td align=left><a href=http://$template>$template</a></td>
</tr>
<tr>
<td align=left><font face='$font'>Business ID Number: $id</font></td>
<tr>
<td align=left><img src='$image'></td>
</tr>";
} // end while
echo "</table>";
} else { echo "problems...."; }
} else {
echo "Search box was empty. <br> Go back and try again.";
}
?>
