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过的时间呢?
解决方案 »
- 好头疼,拜托各位了!!!
- apache怎样将域名绑定到非80端口?
- PHP能实现 点对点 的传送压缩包 方式么!?
- jquery 选择 SELECT option
- 跪求站内搜索PHP类,高手来帮忙!!
- <<<<<<网站外包,价格大约在800元左右,5张静态页面,2周内交货
- 如何用php来动态抓取别人网页的新闻,在线等待,急.....
- PHP中如何调用ORACLE中的存储过程?
- 各位高手看看这个问题,急!!!
- Fatal error: Call to a member function fetch_array() on a non-object in 62 line
- 用preg_match()匹配这段代码
- 数组赋值的问题
$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
)
这样试试