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

"); exit(); } $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_products', $dbcnx); $result = @mysql_query("SELECT prodname FROM inventory WHERE located='$locate[0]' and state='$locate[1]' ORDER BY prodname"); if (!$result){ die ("

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

'); } ?>
Click Here to Return

Product Inventory
Inventory by Location

Products at :
" . "$value" . "Part NumberStock" . "Last Update." . "."); $result2 = @mysql_query("SELECT ID,prodnum,stock,last_date FROM inventory WHERE prodname='$value' ORDER BY prodnum"); if (!$result2){ die ("

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

'); } while($row2 = mysql_fetch_array($result2)){ if($pswinv == 'All'){ $straw1 = "[Edit]"; $straw2 = "[DEL]"; }elseif($pswinv == 'Read_Write'){ $straw1 = "[Edit]"; $straw2 = "."; }elseif($pswinv == 'Read'){ $straw1 = "."; $straw2 = "."; } $lastdate = chunk_split("$row2[3]", 2, ","); $listdate = explode(',',$lastdate); echo("$row2[1]$row2[2]" . "$listdate[2]-$listdate[3]-$listdate[0]$listdate[1]" . "$straw1" . "$straw2"); } echo(""); } ?>
 Inventory Home   Return to Your Page 
Eco-$mart Products
©2005 - Data Base Interface - Custom Built at:  kwgrubbs.com