$cn=mysql_connect("localhost","root","root") or die(mysql_error());
mysql_select_db("ordertrace");
mysql_query("set names utf8");
$r=mysql_query("select * from vorderpurchaser where pono=1") or die(mysql_error()); $a=mysql_fetch_array($r,MYSQL_BOTH);
if($a){print_r($a); }
为什么得不到信息?
mysql_select_db("ordertrace");
mysql_query("set names utf8");
$r=mysql_query("select * from vorderpurchaser where pono=1") or die(mysql_error());
while($a = mysql_fetch_array($r,MYSQL_BOTH)){
printf("ID: %s Name: %s", $a["id"], $a["name"]);
};
"pono","purchasername"
字段类型出问题了,查看了view字段类型为字符型,我一直以为是int型.
$r=mysql_query("select * from vorderpurchaser where pono=1")