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:


$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 "

There are no entries in the table

";
}
else {
PRINT "";
PRINT "";
PRINT "";
PRINT "";
PRINT "";
PRINT "";
WHILE ($i < $number) {
$name = mysql_result($result,$i,"name");
$address= mysql_result($result,$i,"address");
PRINT "";
PRINT "";
PRINT "";
PRINT "";
$i++;
}
PRINT "

Name	Address
$name	$address

";
PRINT "";
}

?>



Where am I going wrong?

You must indicate table prefix here :


Prefix is XOOPS with XOOPS 2.0.x if you haven't change it