|
|
Posted by Mark Sargent on 05/10/05 08:57
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@snow.email.ne.jp>
>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.
[Back to original message]
|