Prathaban Mookiah wrote:
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 <[EMAIL PROTECTED]> To: php-general@lists.php.net Sent: Tue, 10 May 2005 13:23:51 +0900 Subject: [PHP] 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 -------
Hi All,
Thanx. I saw the extra echo and removed it. Problem with that code, though. It displays only the 1st record, repeatedly, causing the browser to hang. Can anyone see what is wrong..? Cheers.
Mark Sargent.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
