$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();
}
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_products', $dbcnx);
$proname = $_GET['proname'];
$listem = @mysql_query("SELECT ID,name,address,city,area,state,zip,country,phone,email,website FROM dealers WHERE proname = '$proname'");
if (!$listem){
die ("Error Selecting Products from Data Base!
".
'Error:' . mysql_error() . '
');
}
$num_rows = mysql_num_rows($listem);
?>
Dealers List Administration
edit dealer
$num_rows = mysql_num_rows($listem);
if($num_rows == 0){
echo("No Dealers Listed |
");
}
if($num_rows >= 1){
while ($row = mysql_fetch_array($listem)) {
$id = $row['ID'];
$name = stripslashes($row['name']);
$address = $row['address'];
$city = $row['city'];
$area = $row['area'];
$state = $row['state'];
$zip = $row['zip'];
$country = $row['country'];
$phone = $row['phone'];
$email = $row['email'];
$website = $row['website'];
echo("$name | $address | " .
"$city, $state | " .
" [Edit] | " .
" [DEL] |
");
}
}
?>
©2006 - Data Base Interface - Custom Built at:
|