I guess it is the missing semicolon. And you can write: echo "<tr><td><? echo $product_type ?></td></tr>" as simply echo "<tr><td>$product_type</td></tr>" Prathap ---------- Original Message ----------- From: Mark Sargent <powderkeg@xxxxxxxxxxxxxxxx> To: php-general@xxxxxxxxxxxxx Sent: Tue, 10 May 2005 13:23:51 +0900 Subject: While and echoing HTML > 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. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php ------- End of Original Message ------- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
