$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_products', $dbcnx);
$getem = mysql_query("SELECT * FROM prices ORDER BY productname");
if(!$getem){
echo("Could not get prices. Error:". mysql_error()." ");
}else{
while($row = mysql_fetch_array($getem)){
$id = $row[0];
$productname = $row[1];
$description = $row[2];
$list = $row[3];
$retail = $row[4];
$wholesale = $row[5];
$dealer = $row[6];
$unit = $row[10];
$case = $row[11];
$minimum = $row[12];
echo("$productname" .
" | $description | " .
"" .
"$list " .
" | $retail " .
" | $wholesale " .
" | $dealer " .
" | $unit" .
" | $case" .
" | $minimum" .
" | | | ");
}
}
?>
|
|