Hello Firends. I have the following code. I am getting the query results but they are not displaying in the table. I presume there is something wrong with a "}" in the "while" statement. Can someone please tell me where I am wrong?
Quote : <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <p> </p> <p> </p> <?php require 'common.inc'; if(!($link=mysql_pconnect($DB_SERVER,$DB_LOGIN,$DB_PASSWORD))){ DisplayErrMsg(sprintf("internal error %d:%s\n", mysql_errno(),mysql_error())); return 0; } if ($link){ Print ""; } else { Print "No connection to the database"; } if (!mysql_select_db("MyDomain_com")){ Print "Couldn't connect database"; } else { Print ""."<br>\n"; }?> <table width="75%" border="1"> <tr bgcolor="#006600"> <td><strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">Company's name</font></strong></td> <td><strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">Company's address</font></strong></td> <td><strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">Company's website</font></strong></td> <td><strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">Company's logo</font></strong></td> </tr> <?PHP $sql="select * from CompanyData" ; if ($result=mysql_query($sql)) { $numofrows=mysql_num_rows($result); } while($row=mysql_fetch_array($result)){ ?> <tr> <td width="12%" align="center" height="6"><font face="Tahoma" color="#000000"><?php Print " $row[CompanyName]" ;?></font> </td> <td width="12%" align="center" height="6"><font face="Tahoma" color="#000000"><?php Print " $row[CompanyAddress]" ;?></font> </td> <td width="12%" align="center" height="6"><font face="Tahoma" color="#000000"><?php Print " $row[Companywebsite]" ;?></font> </td> <td width="12%" align="center" height="6"><font face="Tahoma" color="#000000"><?php Print " $row[Companytel]" ;?></font> </td> </tr> </table> <p> </p> </body> </html> Unquote Thanks very much denis