![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
我建立了个数据库:
CREATE TABLE `product` (
`p_no` CHAR( 10 ) NOT NULL ,
`p_name` CHAR( 50 ) NOT NULL ,
`unit` CHAR( 10 ) NOT NULL ,
`price` CHAR( 20 ) NOT NULL ,
`place` CHAR( 100 ) ,
PRIMARY KEY ( `p_no` )
) TYPE = MYISAM ;
然后建立了一个test.php
<?php
$db=mysql_connect("sky","root");
mysql_select_db("bc_db",$db);
$result=mysql_query("SELECT*FROM product",$db);
printf("产品编号:%s
\n",mysql_result($result,0,"p_no"));
printf("产品名称: %s
\n",mysql_result($result,0,"p_name"));
printf("单价:%s
\n" ,mysql_result($result,0,"price"));
printf("产地:%s
\n", mysql_result($result,0,"place"));
?>
在APACHE下运行出现下列错误提示:
Warning: Unable to jump to row 0 on MySQL result index 2 in c:\apache\htdocs\test1.php on line 5
产品编号:
Warning: Unable to jump to row 0 on MySQL result index 2 in c:\apache\htdocs\test1.php on line 6
产品名称:
Warning: Unable to jump to row 0 on MySQL result index 2 in c:\apache\htdocs\test1.php on line 7
单价:
Warning: Unable to jump to row 0 on MySQL result index 2 in c:\apache\htdocs\test1.php on line 8
产地:
我的环境是:apache+mysql+php
请问是什么原因,在线等待,谢谢!

