Re: While and echoing HTML

Mark Sargent <powderkeg@xxxxxxxxxxxxxxxx> · Tue, 10 May 2005 14:57:11 +0900

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 <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><? echo $first." 
".$last; ?></td> <td><font face="Arial, Helvetica, sans-

serif"><? echo $phone; ?></td> <td><? echo $mobile; ?></td> <td><? echo $fax; ?></td> 
<td><a href="mailto:<? 
echo $email; ?>">E-mail</a></td> <td><a href="<? echo $web; ?>">Website</a></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