can't creat table...why?????

mridul

the output does not show the table..please any one help....

<?php
$username="root";
$password="";
$database="prozzal";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database from select_table");

$query="SELECT * FROM person";
$result=mysql_query($query);

$num=mysql_numrows($result);

echo "<center>Database Output</center> ";
?>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th>FName</th>
<th>LName</th>
<th>username</th>
<th>password</th>
<th>email</th>

<th>city</th>
<th>state</th>
<th>country</th>
<th>address</th>
<th>phone</th>
<th>Age</th>
</tr>

<?php
$i=0;
while ($i < $num) {

$field1name=mysql_result($result,$i,"FName");
$field2name=mysql_result($result,$i,"LName");
$field3name=mysql_result($result,$i,"username");
$field4name=mysql_result($result,$i,"password");
$field5name=mysql_result($result,$i,"email");

$field7name=mysql_result($result,$i,"city");
$field8name=mysql_result($result,$i,"state");
$field9name=mysql_result($result,$i,"country");
$field10name=mysql_result($result,$i,"address");
$field11name=mysql_result($result,$i,"phone");
$field12name=mysql_result($result,$i,"Age");

?>
<tr>
<td><? echo $field1name; ?></td>
<td><? echo $field2name; ?></td>
<td><? echo $field3name; ?></td>
<td><? echo $field4name; ?></td>

<?php
$i++;
}
echo "</table>";

coldwerturkey

it seems to be a very over-done way to unsuccessfully do it

how about something like,

<?php
$username = "root";
$password = "";
$database = "prozzal";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die("Unable to select database from select_table");

$query = "SELECT * FROM person";
$result = mysql_query($query) or die(mysql_error()); //notice the mysql_error() to ensure your query executed..

echo "
<style type='text/css'>
	th {font-family:Arial, Helvetica, sans-serif;}
</style>

<div style='font-weight:bold;text-align:center;'>Database Output</div>

<br />
<br />

<table border=0 cellspacing=2 cellpadding=2>
	<tr>
		<th>FName</th>
		<th>LName</th>
		<th>username</th>
		<th>password</th>
		<th>email</th>

	<th>city</th>
	<th>state</th>
	<th>country</th>
	<th>address</th>
	<th>phone</th>
	<th>Age</th>
</tr>
<tr>";

while ($row = mysql_fetch_array($result)){
	echo "
		<th>{$row['FName']}</th>
		<th>{$row['LName']}</th>
		<th>{$row['username']}</th>
		<th>{$row['password']}</th>
		<th>{$row['email']}</th>

	<th>{$row['city']}</th>
	<th>{$row['state']}</th>
	<th>{$row['country']}</th>
	<th>{$row['address']}</th>
	<th>{$row['phone']}</th>
	<th>{$row['Age']}</th>";
}

echo "
	</tr>
</table>";

?>