$dnum = date(Ymd)*4;
$from = $_GET['fr'];
if($from == ""){
$from = $_POST['fr'];
}
if($from != $dnum){
echo("<<<<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();
}
$cat = $_GET['cat'];
if($cat == 'BE'){$clbd = 'topper2a';}else{$clbd = 'topper2';}
if($cat == 'CT'){$clct = 'topper2a';}else{$clct = 'topper2';}
if($cat == 'CO'){$clco = 'topper2a';}else{$clco = 'topper2';}
if($cat == 'DL'){$cldl = 'topper2a';}else{$cldl = 'topper2';}
if($cat == 'DK'){$cldk = 'topper2a';}else{$cldk = 'topper2';}
if($cat == 'FL'){$clfl = 'topper2a';}else{$clfl = 'topper2';}
if($cat == 'CW'){$clcw = 'topper2a';}else{$clcw = 'topper2';}
if($cat == 'AP'){$clap = 'topper2a';}else{$clap = 'topper2';}
if($cat == 'HS'){$clhs = 'topper2a';}else{$clhs = 'topper2';}
if($cat == 'IN'){$clin = 'topper2a';}else{$clin = 'topper2';}
if($cat == 'LD'){$clld = 'topper2a';}else{$clld = 'topper2';}
if($cat == 'LT'){$cllt = 'topper2a';}else{$cllt = 'topper2';}
if($cat == 'PC'){$clpc = 'topper2a';}else{$clpc = 'topper2';}
if($cat == 'PV'){$clpv = 'topper2a';}else{$clpv = 'topper2';}
if($cat == 'RF'){$clrf = 'topper2a';}else{$clrf = 'topper2';}
if($cat == 'SL'){$clsl = 'topper2a';}else{$clsl = 'topper2';}
if($cat == 'WH'){$clwh = 'topper2a';}else{$clwh = 'topper2';}
if($cat == 'WP'){$clwp = 'topper2a';}else{$clwp = 'topper2';}
if($cat == 'WS'){$clws = 'topper2a';}else{$clws = 'topper2';}
if($cat == 'WN'){$clwn = 'topper2a';}else{$clwn = 'topper2';}
if($cat == 'BE'){$catname = 'Building';}
if($cat == 'CT'){$catname = 'Controllers';}
if($cat == 'CO'){$catname = 'Counter Tops';}
if($cat == 'DL'){$catname = 'Day Lighting';}
if($cat == 'DK'){$catname = 'Decking';}
if($cat == 'FL'){$catname = 'Earth Friendly Flooring';}
if($cat == 'CW'){$catname = 'Carpentry Wood';}
if($cat == 'AP'){$catname = 'Energy Saving Appliances';}
if($cat == 'HS'){$catname = 'Home Safety';}
if($cat == 'IN'){$catname = 'Insulation';}
if($cat == 'LD'){$catname = 'Landscape/Fence';}
if($cat == 'LT'){$catname = 'Lighting';}
if($cat == 'PC'){$catname = 'Paints and Coatings';}
if($cat == 'PV'){$catname = 'Paving Systems';}
if($cat == 'RF'){$catname = 'Roofs';}
if($cat == 'SL'){$catname = 'Solar Energy';}
if($cat == 'WH'){$catname = 'Water Heating';}
if($cat == 'WP'){$catname = 'Water Purification';}
if($cat == 'WS'){$catname = 'Water Saving';}
if($cat == 'WN'){$catname = 'Window';}
if($cat == 'BE'){$categ = 'BE%';}
if($cat == 'CT'){$categ = 'CT%';}
if($cat == 'CO'){$categ = 'CO%';}
if($cat == 'DL'){$categ = 'Day%';}
if($cat == 'DK'){$categ = 'DECK%';}
if($cat == 'FL'){$categ = 'FL%';}
if($cat == 'CW'){$categ = 'CW%';}
if($cat == 'AP'){$categ = 'ESA%';}
if($cat == 'HS'){$categ = 'HS%';}
if($cat == 'IN'){$categ = 'IN%';}
if($cat == 'LD'){$categ = 'LD%';}
if($cat == 'LT'){$categ = 'LT%';}
if($cat == 'PC'){$categ = 'PC%';}
if($cat == 'PV'){$categ = 'PV%';}
if($cat == 'RF'){$categ = 'RF%';}
if($cat == 'SL'){$categ = 'Sol%';}
if($cat == 'WH'){$categ = 'WatHeat%';}
if($cat == 'WP'){$categ = 'WP%';}
if($cat == 'WS'){$categ = 'WS%';}
if($cat == 'WN'){$categ = 'WN%';}
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_products', $dbcnx);
?>
Edit
| DEL
| Item Number
| Description
| List
| Retail
| Wholesale
| Dealer
| Distributor
| Cost
| Date
|
$result = @mysql_query("SELECT id,productname,description,list,retail,wholesale,dealer,distributor,cost,up_date FROM prices WHERE productname LIKE '$categ' ORDER BY productname");
if (!$result){
die ("Error Getting Prices from Data Base!
".
'Error:' . mysql_error() . '
');
}
while($row = mysql_fetch_array($result)){
echo(" Edit | " .
" DEL | " .
"$row[1] | $row[2] | $row[3] | $row[4] | $row[5] | $row[6] | $row[7] | $row[8] | $row[9] |
");
}
?>
©2006 - Data Base Interface - Custom Built at:
|