Question

关于mysql_fetch_array和mysql_fetch_row的用法

<?php
mysql_connect("localhost","root","XXX");
"create table S (pan char(10),yuan char(10),yu char(40))";
$sql="insert into s values('111','222','333')";
$a=mysql_query($sql);
if($b=mysql_fetch_array($a))
{
echo "$b[0]";
echo "<br>";
echo "$b[yuan]";
echo "<br>";
echo "$b[yu]";
echo "<br>";
echo "$b";
}
$c=mysql_fetch_row($a);
echo "$c";
echo "<br>";
echo "$a";
?>
错误信息：

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\test.php on line 2
Warning: mysql_connect(): in C:\wamp\www\test.php on line 2
Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\test.php on line 5
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\test.php on line 6
Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in C:\wamp\www\test.php on line 16

Answer 1

$sql="insert into s values('111','222','333')";你这句语句其实没有查询成功，你写的数据库名是大写S，所以$a并不是一个查询结果集

另外建议你写程序要进行健壮性判断

追问

mysql不区分大小写的。我改回S错误还是一样

追答

"create table S (pan char(10),yuan char(10),yu char(40))";

这个sql没有执行