1
Hi,
I'm having a problem with my smarty/php/mysql project. I can insert/update/delete from the database, but I cannot seem to view tables of the data in the database.
My viewusers.php code is as follows:
<?php
$name = $_POST["name"];
$address = $_POST["address"];
$connection = mysql_connect("localhost", "*******", "*******") or die ("Could not connect");
$db = mysql_select_db("*******", $connection);
$result = mysql_query("SELECT * FROM users") or die(mysql_error());
$number = MYSQL_NUMROWS($result);
$i = 0;
if ($number == 0) {
print "<CENTER><P>There are no entries in the table</CENTER>";
}
else {
PRINT "<CENTER>";
PRINT "<TABLE BORDER=0>";
PRINT "<tr>";
PRINT "<TD> <b> Name </b> </TD>";
PRINT "<TD> <b> Address </b> </TD>";
PRINT "</tr>";
WHILE ($i < $number) {
$name = mysql_result($result,$i,"name");
$address= mysql_result($result,$i,"address");
PRINT "<tr>";
PRINT "<TD> $name </TD>";
PRINT "<TD> $address </TD>";
PRINT "</tr>";
$i++;
}
PRINT "</TABLE>";
PRINT "</CENTER>";
}
?>
Where am I going wrong?