Here's the exact code that I'm using. It's working like a charm so far. Any way to make it better? I'm still kind of new to php and I got the concepts, just all the syntax and tricks require time to learn...
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Roomful Express Sofa Search</title>
<!--<link href="profile.css" rel="stylesheet" type="text/css" />
<link href="../css/slimbox.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="../js/mootools.v1.11.js"></script>
<script type="text/javascript" src="../js/slimbox.js"></script> -->
</head>
<body>
<div class="container">
<?php
// Get the search variable from URL
$var = @$_GET['FAMILY_CD'] ;
$trimmed = trim($var); //trim whitespace from the stored variable
//connect to your database ** EDIT REQUIRED HERE **
mysql_connect("sql002.choiceone.net","roomfulexpre ss","x47rkv7N"); //(host, username, password)
//specify database ** EDIT REQUIRED HERE **
mysql_select_db("roomfulexpress") or die("Unable to select database"); //select which database we're using
// Build SQL Query
$query = "select * from tblFamily where FAMILY_CD like \"%$trimmed%\" order by FAMILY_NAME"; // this will only effect the data pulling from the family table
$result = mysql_query($query) or die("Couldn't execute query"); // grab results
while ($row = mysql_fetch_array($result)) // show results
{
echo("<table width=500px>");
echo("<tr>");
echo("<td> ". $row["FAMILY_NAME"] . "</td>");
echo("</tr>");
}
echo("</table>");
// Build SQL Query
$query2 = "select * from tblItem where FAMILY_CD like \"%$trimmed%\" order by ITEM_NAME"; // this will only effect the data pulling from the family table
$result2 = mysql_query($query2) or die("Couldn't execute query"); // grab results
while ($row = mysql_fetch_array($result2)) // show results
{
echo("<table width=500px>");
echo("<tr>");
echo("<td> ". $row["ITEM_NAME"] . "</td>");
echo("</tr>");
}
echo("</table>");
// Build SQL Query
$query3 = "select * from tblFurniture where FAMILY_CD like \"%$trimmed%\" order by ITEM_NAME"; // this will only effect the data pulling from the family table
$result3 = mysql_query($query3) or die("Couldn't execute query"); // grab results
while ($row = mysql_fetch_array($result3)) // show results
{
echo("<table width=500px>");
echo("<tr>");
echo("<td> ". $row["MINOR_CD"] . "</td>");
echo("<td> ". $row["SKU"] . "</td>");
echo("</tr>");
}
echo("</table>");
?>
<!--<div class="smallerFontLeft"><A HREF="javascript
:window.print()"> <img src="../images/common/print.jpg" align="bottom" /> click to print this profile</A></div>
<div class="smallFontLeft"><A HREF="javascript
:history.go(-1)"> <<Back</A></div></div>
</div>-->
</body>
</html>
10
