sql문 호출문좀 봐주세요 ㅠ

sql문 호출문좀 봐주세요 ㅠ

QA

sql문 호출문좀 봐주세요 ㅠ

답변 2

본문

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

$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."%";
하시면됩니다........
배추빌더에서 판매된 소셜 컨텐츠 이신가요
답변을 작성하시기 전에 로그인 해주세요.
QA 내용 검색
질문등록
전체 10,637
© SIRSOFT
현재 페이지 제일 처음으로