$qry = "SELECT '$longitude'=longitude,'$latitude'=latitude,'$updatetime'=updatetimer FROM members WHERE login='why'";
$result = @mysql_query($qry);
//Check whether the query was successful or not
if($result) {
echo $longitude;
echo $latitude;
echo $updatetime;
exit();
}
我的mysql数据中有坐标和时间,我想读取出来打印出来,不知道哪句代码写错了,显示空白
$result = @mysql_query($qry);
//Check whether the query was successful or not
if($result) {
echo $longitude;
echo $latitude;
echo $updatetime;
exit();
}
我的mysql数据中有坐标和时间,我想读取出来打印出来,不知道哪句代码写错了,显示空白
还是没效果,$longitude等要初始化吗?echo $longitude;写法对吗?
$result = mysql_query($qry);
while($rs = mysql_fetch_array($result)){
print_r($rs);
}
if($row = mysql_fetch_array($result)) {
echo $row['longitude'];
echo $row['latitude'];
echo $row['updatetime'];
exit();
}