Hi all,
I'm working on my first php+mysql program.
I have a mysqld running and there's a DB named "example" with a table
"tbl". Here it is:
--------------
mysql> use example;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from tbl;
+------+----------+----------+----------------+
| idx | UserName | LastName | FreeText |
+------+----------+----------+----------------+
| 2 | Rafi | Ton | Just a test |
| 1 | li | ken | Just two tests |
| 3 | ghjgj | jhn | Jus tests |
+------+----------+----------+----------------+
3 rows in set (0.00 sec)
---------------
When I tried to apply the following sample program, strange result came
to me. Let me show you the script.
---------------
<html>
<head><title>Web Database Sample Index</title>
</head>
<body bgcolor=#ffffff>
<h2>Data from tbl</h2>
<?
mysql_connect() or die ("Problem connecting to DataBase");
$query = "select * from tbl";
$result = mysql_db_query("example", $query);
if ($result) {
echo "Found these entries in the database:<br><p></p>";
echo "<table width=90% align=center border=1><tr>
<td align=center bgcolor=#00FFFF>User Name</td>
<td align=center bgcolor=#00FFFF>Last Name</td>
<td align=center bgcolor=#00FFFF>Domain Name</td>
<td align=center bgcolor=#00FFFF>Request Date</td>
</tr>";
while ($r = mysql_fetch_array($result)) {
$idx = $r["idx"];
$user = $r["UserName"];
$last = $r["LastName"];
$text = $r["FreeText"];
echo "<tr>
<td>$idx</td>
<td>$user</td>
<td>$last</td>
<td>$text</td>
</tr>";
}
echo "</table>";
} else {
echo "No data.";
}
</body>
</html>
---------------
I ran this php page in IE and only to get "No data." as the result,
while I was expecting a list of my table contents. I cannot find the
error I made, actually I almost copied this script from some book.
Please help me to check it.
Any suggestion would be appreciated.
Best, zhy
