require("/db/db_connect.php");
$select_member = "select Uniqueid,Bar_name,Boss_name,Bar_address,Begin_tm,End_tm,Ismember from member_info where uniqueid='$_GET[uni]'";
$query1 = "select date_format(Begin_tm,'%y-%m-%d') from member_info where uniqueid='$_GET[uni]'";
$query2 = "select date_format(End_tm,'%y-%m-%d') from member_info where uniqueid='$_GET[uni]'";
$b_tm = mysql_query($query1,$conn);
$e_tm = mysql_query($query2,$conn);$rows_begintm = mysql_fetch_array($b_tm);
//$rows_endtm = mysql_fetch_array($e_tm);echo "<pre>";
print_r($rows_begintm);我把这个数组打印出来显示如下Array
(
[0] => 10-07-05
[date_format(Begin_tm,'%y-%m-%d')] => 10-07-05
)当我使用 $rows_begintm[Begin_tm] 却无法取回从MYSQL中查询出来的值
提示 begin_tm未定义:
Notice: Undefined index: Begin_tm in E:\php\Search.php on line 13
请问如何从mysql_fetch_array中提取经过mysql date_format过的时间呢?
$select_member = "select Uniqueid,Bar_name,Boss_name,Bar_address,Begin_tm,End_tm,Ismember from member_info where uniqueid='$_GET[uni]'";
$query1 = "select date_format(Begin_tm,'%y-%m-%d') from member_info where uniqueid='$_GET[uni]'";
$query2 = "select date_format(End_tm,'%y-%m-%d') from member_info where uniqueid='$_GET[uni]'";
$b_tm = mysql_query($query1,$conn);
$e_tm = mysql_query($query2,$conn);$rows_begintm = mysql_fetch_array($b_tm);
//$rows_endtm = mysql_fetch_array($e_tm);echo "<pre>";
print_r($rows_begintm);我把这个数组打印出来显示如下Array
(
[0] => 10-07-05
[date_format(Begin_tm,'%y-%m-%d')] => 10-07-05
)当我使用 $rows_begintm[Begin_tm] 却无法取回从MYSQL中查询出来的值
提示 begin_tm未定义:
Notice: Undefined index: Begin_tm in E:\php\Search.php on line 13
请问如何从mysql_fetch_array中提取经过mysql date_format过的时间呢?
$query2 = "select date_format(End_tm,'%y-%m-%d') as Begin_tm from member_info where uniqueid='$_GET[uni]'";给数据查询一个别名就行了。就能得到一个
Array
(
[0] => 10-07-05
[Begin_tm] => 10-07-05
)这样的格式的数值
$rows_begintm = mysql_fetch_assoc($b_tm); //改成关联数组,就只剩一个字段。
print_r($rows_begintm);
Array
(
[time] => 10-07-05
)
这样试试