Re: While and echoing HTML

oh, and the i++ should be inside the while loop and there is also a missing semi colon after the echo, ie; $i=0; while ($i < $num){ $product_type=mysql_result($result,$i,"product_type_detail"); echo "<tr><td><? echo $product_type ?></td></tr>"; $i++ ; } Mark Sargent wrote, On 10/05/05 02:23 PM:

Hi All, this page, http://www.freewebmasterhelp.com/tutorials/phpmysql/5 has the below code, <? $i=0; while ($i < $num) { $first=mysql_result($result,$i,"first"); $last=mysql_result($result,$i,"last"); $phone=mysql_result($result,$i,"phone"); $mobile=mysql_result($result,$i,"mobile"); $fax=mysql_result($result,$i,"fax"); $email=mysql_result($result,$i,"email"); $web=mysql_result($result,$i,"web"); ?> <tr> <td><font face="Arial, Helvetica, sans-serif"><? echo $first." ".$last; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><? echo $phone; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><? echo $mobile; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><? echo $fax; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><a href="mailto:<? echo $email; ?>">E-mail</a></font></td> <td><font face="Arial, Helvetica, sans-serif"><a href="<? echo $web; ?>">Website</a></font></td> </tr> <? $i++; } echo "</table>"; which I basically understand, except the html generation. I am trying to create something similiar, although, I think there are some errors in even perhaps my logic..? <html> <body> <h1><center>Jumbo Status</center></h1><br> <?php $db = mysql_connect("localhost", "root", "grunger"); mysql_select_db("status",$db); $result = mysql_query("SELECT ProductTypes.product_type_detail FROM ProductTypes",$db); $myrow = mysql_fetch_array($result); $num = mysql_num_rows($result); ?> <table aligh="center" border="2"> <tr> <td>Product Type</td> </tr> <? $i=0; while ($i < $num){ $product_type=mysql_result($result,$i,"product_type_detail"); echo "<tr><td><? echo $product_type ?></td></tr>" } $i++ ?> </table> </body> </html> I get the folowing error, *Parse error*: parse error, unexpected '}', expecting ',' or ';' in */var/www/html/products.php* on line *20 * which is the $i++ section. Cheers. Mark Sargent.