sql문 호출문좀 봐주세요 ㅠ

sql문 호출문좀 봐주세요 ㅠ

QA

sql문 호출문좀 봐주세요 ㅠ

본문

쇼셜커머스를 최신글로 사용하려고 합니다.

$product = sql_fetch("select * from g4_mw_soc_product where bo_table = '$bo_table' and wr_id = '{$list[$i]['wr_id']}'");


<?=number_format($product[pr_original_price])?>
<?=number_format($product[pr_sale_price])?>


현재 위의값 오리지날값과 세일값을 % 보여줄려고합니다

오리지날값은 현재 : 49800 원이며
세일값은 : 19000원 입니다.

어떻게 출력함수를 써야될까요?

<?=number_format($product[pr_original_price])?> = 100% 임으로
<?=number_format($product[pr_sale_price])?>값은 62% 이다





print_r ($product); 찍어봤을때

Array ( [pr_id] => 10 [bo_table] => B16 [wr_id] => 9 [pr_original_price] => 49800 [pr_sale_price] => 19000 [pr_max] => 100 [pr_min] => 3 [pr_sdate] => 2014-02-20 00:00:00 [pr_edate] => 2014-03-10 00:00:00 [pr_type] => s [pr_ship_min] => 30000 [pr_ship_price] => 2500 [pr_ship_collect] => [pr_sale_max] => 30 [pr_use_point] => 0 [pr_member_limit] => 0 [pr_commission] => 0 [pr_commission_payment] => 0 [pr_save_point] => 300 [pr_save_cash] => 100 [pr_level] => 2 [pr_memo] => [pr_hp] => [pr_membership] => [pr_rel_table] => [pr_rel_id] => [pr_no_buyer] => 2 [pr_email] => [pr_repeat_stime] => [pr_repeat_etime] => [pr_repeat_week] => 1,1,1,1,1,1,1 [pr_mb_id] => ) Array ( [pr_id] => 9 [bo_table] => B16 [wr_id] => 8 [pr_original_price] => 49800 [pr_sale_price] => 19000 [pr_max] => 100 [pr_min] => 3 [pr_sdate] => 2014-02-20 00:00:00 [pr_edate] => 2014-03-10 00:00:00 [pr_type] => s [pr_ship_min] => 30000 [pr_ship_price] => 2500 [pr_ship_collect] => [pr_sale_max] => 30 [pr_use_point] => 0 [pr_member_limit] => 0 [pr_commission] => 0 [pr_commission_payment] => 0 [pr_save_point] => 300 [pr_save_cash] => 100 [pr_level] => 2 [pr_memo] => [pr_hp] => [pr_membership] => [pr_rel_table] => [pr_rel_id] => [pr_no_buyer] => 2 [pr_email] => [pr_repeat_stime] => [pr_repeat_etime] => [pr_repeat_week] => 1,1,1,1,1,1,1 [pr_mb_id] => ) Array ( [pr_id] => 8 [bo_table] => B16 [wr_id] => 7 [pr_original_price] => 49800 [pr_sale_price] => 19000 [pr_max] => 100 [pr_min] => 3 [pr_sdate] => 2014-02-20 00:00:00 [pr_edate] => 2014-03-10 00:00:00 [pr_type] => s [pr_ship_min] => 30000 [pr_ship_price] => 2500 [pr_ship_collect] => [pr_sale_max] => 30 [pr_use_point] => 0 [pr_member_limit] => 0 [pr_commission] => 0 [pr_commission_payment] => 0 [pr_save_point] => 300 [pr_save_cash] => 100 [pr_level] => 2 [pr_memo] => [pr_hp] => [pr_membership] => [pr_rel_table] => [pr_rel_id] => [pr_no_buyer] => 2 [pr_email] => [pr_repeat_stime] => [pr_repeat_etime] => [pr_repeat_week] => 1,1,1,1,1,1,1 [pr_mb_id] => ) Array ( [pr_id] => 7 [bo_table] => B16 [wr_id] => 6 [pr_original_price] => 49800 [pr_sale_price] => 19000 [pr_max] => 100 [pr_min] => 3 [pr_sdate] => 2014-02-20 00:00:00 [pr_edate] => 2014-03-10 00:00:00 [pr_type] => s [pr_ship_min] => 30000 [pr_ship_price] => 2500 [pr_ship_collect] => [pr_sale_max] => 30 [pr_use_point] => 0 [pr_member_limit] => 0 [pr_commission] => 0 [pr_commission_payment] => 0 [pr_save_point] => 300 [pr_save_cash] => 100 [pr_level] => 2 [pr_memo] => [pr_hp] => [pr_membership] => [pr_rel_table] => [pr_rel_id] => [pr_no_buyer] => 2 [pr_email] => [pr_repeat_stime] => [pr_repeat_etime] => [pr_repeat_week] => 1,1,1,1,1,1,1 [pr_mb_id] => ) Array ( [pr_id] => 6 [bo_table] => B16 [wr_id] => 5 [pr_original_price] => 49800 [pr_sale_price] => 19000 [pr_max] => 100 [pr_min] => 3 [pr_sdate] => 2014-02-20 00:00:00 [pr_edate] => 2014-03-10 00:00:00 [pr_type] => s [pr_ship_min] => 30000 [pr_ship_price] => 2500 [pr_ship_collect] => [pr_sale_max] => 30 [pr_use_point] => 0 [pr_member_limit] => 0 [pr_commission] => 0 [pr_commission_payment] => 0 [pr_save_point] => 300 [pr_save_cash] => 100 [pr_level] => 2 [pr_memo] => [pr_hp] => [pr_membership] => [pr_rel_table] => [pr_rel_id] => [pr_no_buyer] => 2 [pr_email] => [pr_repeat_stime] => [pr_repeat_etime] => [pr_repeat_week] => 1,1,1,1,1,1,1 [pr_mb_id] => ) Array ( [pr_id] => 5 [bo_table] => B16 [wr_id] => 4 [pr_original_price] => 49800 [pr_sale_price] => 19000 [pr_max] => 100 [pr_min] => 3 [pr_sdate] => 2014-02-20 00:00:00 [pr_edate] => 2014-03-10 00:00:00 [pr_type] => s [pr_ship_min] => 30000 [pr_ship_price] => 2500 [pr_ship_collect] => [pr_sale_max] => 30 [pr_use_point] => 0 [pr_member_limit] => 0 [pr_commission] => 0 [pr_commission_payment] => 0 [pr_save_point] => 300 [pr_save_cash] => 100 [pr_level] => 2 [pr_memo] => [pr_hp] => [pr_membership] => [pr_rel_table] => [pr_rel_id] => [pr_no_buyer] => 2 [pr_email] => [pr_repeat_stime] => [pr_repeat_etime] => [pr_repeat_week] => 1,1,1,1,1,1,1 [pr_mb_id] => )

이 질문에 댓글 쓰기 :

답변 2

최신글에서 뽑으실려면
 
head.php 상위에
 
//할인율구하기
function sc_rate($o, $s) {
    return @round((1-$s/$o)*100);
}
 
넣으시구
 
$rate = sc_rate($product[pr_original_price], $product[pr_sale_price]);
 
echo $rate."%";
하시면됩니다........
배추빌더에서 판매된 소셜 컨텐츠 이신가요
답변을 작성하시기 전에 로그인 해주세요.
전체 125,873 | RSS
QA 내용 검색

회원로그인

(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1402호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT