MySQL中的菜问题~~~~

1   
2session_start();   
3$ksh=$user;   
4if (!session_is_registered("user")&!session_is_registered("passwd"))   
5{   
6Header("Location:newstu.php") ;   
7exit;   
8}   

$db = mysql_connect("localhost","root","");
mysql_select_db ("mydata");
$xh = mysql_query ("select xh from lqdyk where ksh='$ksh'");
$xm = mysql_query ("select xm from lqdyk where ksh='$ksh'");
$result = mysql_query ("insert into maildata (ksh, xh, xm, yhm, mm)
VALUES ('$ksh', '$xh', '$xm', '$yhm','$mm')");

这个的问题在哪里?
为什么取不回$xh和$xm呢?

---------------------------------------------------------------

mysql_query 查询到的关不是 $xh $xm 的值.
相关内容,请参阅
mysql手册.

呵呵
---------------------------------------------------------------

list($xh) = mysql_fetch_row(mysql_query ("select xh from lqdyk where ksh='$ksh'"));
list($xm) = mysql_fetch_rowmysql_query ("select xm from lqdyk where ksh='$ksh'"));
---------------------------------------------------------------

$db = mysql_connect("localhost","root","");
mysql_select_db ("mydata");
$res = mysql_query ("select xh,xm from lqdyk where ksh='$ksh'");
$resArr = mysql_fetch_array($res);
$xh = $resArr['xh'];
$xm = $resArr['xm'];
$result = mysql_query ("insert into maildata (ksh, xh, xm, yhm, mm)
VALUES ('$ksh', '$xh', '$xm', '$yhm','$mm')");
---------------------------------------------------------------

高手说了,我就跟着拣分来了。

Published At
Categories with Web编程
comments powered by Disqus