$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_products', $dbcnx);
echo("");
echo("item | " .
"sku | " .
"upc | " .
"carrier | " .
"crr_phone | " .
"crr_account | " .
"class | " .
"o_city | " .
"o_country | " .
"o_code | " .
"unit | " .
"weight_lbs | " .
"height_in | " .
"width_in | " .
"length_in | " .
"custom | " .
"currency | " .
"minimum | " .
"handling | " .
"flat | " .
"rate_1 | " .
"rate_wgt_1 | " .
"rate_2 | " .
"rate_wgt_2 | " .
"rate_3 | " .
"rate_wgt_3 | " .
"up_date | " .
"description | " .
" ");
$getit = mysql_query("SELECT item,sku,upc,carrier,crr_phone,crr_account,class,o_city,o_country,o_code,unit,weight_lbs,height_in,width_in,length_in,custom,currency,minimum,handling,flat,rate_1,rate_wgt_1,rate_2,rate_wgt_2,rate_3,rate_wgt_3,up_date,description FROM ship ORDER BY item");
if(!$getit){
echo("Could not Retrieve Shipping List ".mysql_error()." ");
}else{
$numrows = mysql_num_rows($getit);
if($numrows < 1){
echo(" No Shipping Available. Data base table is empty. | ");
}else{
while($row = mysql_fetch_array($getit)){
echo(" $row[0] | $row[1] | $row[2] | " .
" $row[3] | $row[4] | $row[5] | " .
" $row[6] | $row[7] | $row[8] | " .
" $row[9] | $row[10] | $row[11] | $row[12] | " .
" $row[13] | $row[14] | $row[15] | $row[16] | " .
" $row[17] | $row[18] | $row[19] | $row[20] | " .
" $row[21] | $row[22] | $row[23] | " .
" $row[24] | $row[25] | $row[26] | $row[27] | " .
" ");
}//while
}//else
}//bigelse
?>
©2008 - Data Base Interface - Custom Built at:
|
|