$cur_roomID=$_GET['roomID'];
$query="SELECT *FROM room WHERE roomID=".$cur_roomID."";
$result=mysql_query($query);
$row = mysql_fetch_row($result);
$cur_roomtype = $row['roomtype'];
$cur_roomsize = $row['roomsize'];
为什么总是找不到结果
我想从数据库中得到roomtype和roomsize的值PHPMySQL
$query="SELECT *FROM room WHERE roomID=".$cur_roomID."";
$result=mysql_query($query);
$row = mysql_fetch_row($result);
$cur_roomtype = $row['roomtype'];
$cur_roomsize = $row['roomsize'];
为什么总是找不到结果
我想从数据库中得到roomtype和roomsize的值PHPMySQL
看看是不是sql语句出问题了,还有你的roomID是什么类型的?如果是字符型的要加引号,这样:
$query="SELECT *FROM room WHERE roomID=\'".$cur_roomID."\'";