为什么我运行这段代码无法写数据进数据库?
qococ
|
1#
发表于2007-01-05
为什么我运行这段代码无法写数据进数据库?
我的MYSQL运行正常 可以用PHPMYADMIN管理 也可以加入数据,可是运行下面这段代码就是写不进去
 烦啊 <html> <body> <? if ($UserName) { mysql_connect("localhost","root","xxxx") or die (" Problem connecting to DataBase"); $query = "insert into tbl values ('$idx','$UserName','$LastName','$FreeText')"; $result = mysql_db_query("example", $query); echo "Data inserted. new table:<br><p></p>"; $query = "SELECT * FROM tbl"; $result = mysql_db_query("example", $query); if ($result) { echo "<table width=90% align=center border=1><tr> <td align=center bgcolor=#00FFFF>idx</td> <td align=center bgcolor=#00FFFF>User Name</td> <td align=center bgcolor=#00FFFF>Last Name</td> <td align=center bgcolor=#00FFFF>Free Text</td> </tr>"; while ($r = mysql_fetch_array($result)) { $idx = $r["idx"]; $user = $r["UserName"]; $last = $r["LastName"]; $free = $r["FreeText"]; echo "<tr> <td>$idx</td> <td>$user</td> <td>$last</td> <td>$free</td> </tr>"; } // while循环结束 echo "</table>"; } else { echo "No data."; } // if结束($result) } else { echo "No UserName Entered. Please go back and reenter UserName"; } // if结束($UserName) echo "<p></p>"; include ('links.x'); ?> </body> </html> [ 本帖最后由 qococ 于 2007-1-5 20:57 编辑 ] |