$sql=mysql_query("SELECT sum(Price) * FROM reservations as A
inner join service as B on A.Res_ser_ID = B.Ser_ID
inner join personel as C on A.Res_per_ID = C.Per_ID
where Res_cus_ID = '$userID' ");
"select sum(service.price) as sum_price from (reservations inner join
service on reservation.Res_ser_D = service.Ser_ID inner join personnel
on reservation.Res_per_ID = personnel.Per_ID ) where
reservation.Res_cus_ID = '$userID'"
2条答案
按热度按时间vjhs03f71#
这样行得通,我假定价格是在餐桌上。
n9vozmp42#
您需要升级到支持的软件,如
mysqli_
. php的mysql\uapi多年来一直不受支持。然后您可以使用参数——安全有效地使用应用程序中的sql的关键。我认为是这样的(不使用参数):
这假设价格来自
service
table。