Question

如何在php中获取数据库中字段值？

/* 计算订单总额 */ if ($order['extension_code'] == GROUP_BUY_CODE && $group_buy['deposit'] > 0) { $total['amount'] = $total['goods_price']; } else if($order['extension_code'] == PRE_SALE_CODE && $pre_sale['deposit'] > 0) { $total['amount'] = $total['goods_price']; } else { $total['amount'] = $total['goods_price'] - $total['discount'] + $total['tax'] + $total['pack_fee'] + $total['card_fee'] + $total['shipping_fee'] + $total['shipping_insure'] + $total['cod_fee']+$total['goods_price']*11.9 / 100;}获取到的值可以替换最后11.9/100；这种代码该如何写？麻烦各位大神了~

Answer 1

<?php
$sql = "SELECT name FROM user WHERE ID=1 LIMIT 0,1";
$result = mysql_query($sql);
$rs = mysql_result($result,0);
?>