The following code prints the table headers but not the actual field values.
What am I doing woring?
<?php
//set the variables fro the database accerss
$Host="localhost";
$User="root";
$Password="123";
$DBName= "NewDatabase";
$TableName= "Feedback2";
$Link = mysql_connect ($Host, $User, $Password);
$Query = "SELECT * from $TableName" ;
$result = mysql_db_query ($DBName,$Query, $Link);
echo $Query."<BR>";
if(mysql_error())
echo mysql_error();
//create a table for display
print ("<TABLE BODER=1 WIDTH=\"75%\"
CELLSPACING=2 CELLPADDING =2
ALIGN=CENTER >\n");
print ("<TR ALIGN=CENTER VALIGN=TOP>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Company</td>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Activity</td>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Contact</td>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Phone</td>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Mobile</td>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Email</td>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Add1</td>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Add2</td>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Add3</td>\n");
print("</tr>\n");
//Fetch the results from the database
echo $company;
echo $Company;
while ($row = mysql_fetch_array($result)){
print ("<TR ALIGN=CENTER VALIGN=TOP>\n");
print ("<TD align=center valign=top>$Array[company]</td>\n");
print ("<TD align=center valign=top>$Array[Logo]</td>\n");
print ("<TD align=center valign=top>$Array[Strapline]</td>\n");
print ("<TD align=center valign=top>$Array[Activity]</td>\n");
print ("<TD align=center valign=top>$Array[Contact]</td>\n");
print ("<TD align=center valign=top>$email</td>\n");
print ("<TD align=center valign=top>$Add1</td>\n");
print ("<TD align=center valign=top>$Add2</td>\n");
print ("<TD align=center valign=top>$Add3</td>\n");
print("</tr>\n");
}
mysql_close($Link);
print ("</table>\n");
?>
