<<<<Restricted Area>>>>" . "
Sorry, you must Log In to view this Page

"); exit(); } $usrn = $_GET['usrn']; if($usrn == ""){ $usrn = $_POST['usrn']; } if($usrn == ""){ echo("

<<<<Restricted Area>>>>" . "
Problem with your username. Please Log In again.

"); exit(); } $searchtext = $_POST['searchtext']; $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_products', $dbcnx); $result1 = @mysql_query("SELECT id,category,partname FROM productinfo WHERE category LIKE '%$searchtext%' OR partname LIKE '%$searchtext%'"); if (!$result1){ die ("

Error Selecting Products from Data Base!
". 'Error:' . mysql_error() . '

'); } $num_rows1 = mysql_num_rows($result1); $result2 = @mysql_query("SELECT id,productname,description FROM prices WHERE productname LIKE '%$searchtext%' OR description LIKE '%$searchtext%'"); if (!$result2){ die ("

Error Selecting Products from Data Base!
". 'Error:' . mysql_error() . '

'); } $num_rows2 = mysql_num_rows($result2); $result3 = @mysql_query("SELECT id,productname,type FROM shipping WHERE productname LIKE '%$searchtext%'"); if (!$result3){ die ("

Error Selecting Products from Data Base!
". 'Error:' . mysql_error() . '

'); } $num_rows3 = mysql_num_rows($result3); ?>

Eco-$mart Products Search

"); } if($num_rows1 == 'false'){ echo(""); } ?> "); } if($num_rows2 == 'false'){ echo(""); } ?> "); } if($num_rows3 == 'false'){ echo(""); } ?>
Search Eco-$mart Products Results:
In Product Info:
(ID, Category, Part Name)
$row1[0], $row1[1], $row1[2]  " . "[ Edit ]" . "  [ DEL ]
Key Word Not Found.
In Product Prices:
(ID, Product Name, Description)
$row2[0], $row2[1], $row2[2]  " . "[ Edit ]" . "  [ DEL ]
Key Word Not Found.
In Product Shipping:
(ID, Product Name, Shipping Type)
$row3[0], $row3[1], $row3[2]  " . "[ Edit ]" . "  [ DEL ]
Key Word Not Found.
Search Again
 Products Home   Dealer List   Mfg List   Featured Product 
 List / Edit Info   List / Edit Prices   List / Edit Shipping   CSV 
 New Info   New Prices   New Shipping   Return to Your Page 
Eco-$mart Products
©2006 - Data Base Interface - Custom Built at:  kwgrubbs.com