想问一下,可以像下面的那样,将插入数据库的结果输出吗?不用select...from查询,这样输出可以吗?
<?php
$conn= mysql_connect("localhost","fuck","654321") or die("Could not connect: " . mysql_error());;
$db = mysql_select_db("test");
$result = mysql_query("insert into comments values (1,'jimx','teng')");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf ("ID: %s Name: %s", $row[0], $row[1]);
} mysql_free_result($result);?>
<?php
$conn= mysql_connect("localhost","fuck","654321") or die("Could not connect: " . mysql_error());;
$db = mysql_select_db("test");
$result = mysql_query("insert into comments values (1,'jimx','teng')");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf ("ID: %s Name: %s", $row[0], $row[1]);
} mysql_free_result($result);?>
这个肯定不行,因为insert 语句返回的只有两种情况成功和失败
不会返回结果集的。