Re: More PHP and MySQL Problems with My Script

Hi Austin, if they don't show up then they are most propably empty ! make sure that the variables has values, like $manufacturername I dont see any assignment for it in your script(the part you sent), and if you are calling a function make sure that you are passing the right arguments, send the whole script to see whats exactly this while loop is doing. Ahmed Farouk ""Austin Carpenter"" <phprocks9000@hotmail.com> wrote in message news:F193QgeDKvPEkGhAj5p00004e90@hotmail.com... > Hi, > > Thanks to those who helped on my previous question. > > Well, now the loop is not working. It is not outputting the html. Here it > is: > while ($row = mysql_fetch_array($result)) { > $fname = $row['fname']; > $lname = $row['lname']; > $email = $row['email']; > $level = $row['level']; > $id = $row['id']; > $date = $row['date']; > $rating = $row['rating']; > $homeriver = $row['homeriver']; > $strengths = $row['strengths']; > $weaknesses = $row['weaknesses']; > $summary = $row['summary']; > $style = $row['style']; > $productyear = $row['productyear']; > $productexperience = $row['productexperience']; > $similar = $row['similar']; > > > $name = $fname." ".$lname; > > if ($date == "0000-00-00") { > $date = "[unknown]"; > } > $ratingphoto = "/rating".$rating.".gif"; > $display_block = ' > > <table bgcolor=\"#ffffff\" width=75%> > <tr> > <td width=\"75%\" height=\"30\" colspan=\"2\" > align=\"left\" > valign=\"middle\" bgcolor=\"#85b2ad\" border=\"0\" > cellspacing=\"1\" > cellpadding=\"0\"> > <font face=\"verdana, arial, helvetica\" size=\"-1\"> > Submitted by > <b><A HREF=\"mailto:<? echo $email; ?> > \"><? echo $name; ?></A> > a <? echo $style; ?> Kayaker > from <? echo location; ?> > <br>Date Reviewed: <b><? echo date; ?></b> > </font> > </td> > </tr> > <tr> > <td width=\"20%\" align=\"left\" valign=\"top\" > bgcolor=\"#efefdf\"><font face=\"verdana, arial, helvetica\" > size=\"-1\"> > <b>Home River:</b></font></td> > <td width=\"100%\" align=\"left\" valign=\"top\" > bgcolor=\"#efefdf\"><font face=\"verdana, arial, helvetica\" size=\"-1\"><? > echo $homeriver; ?></font></td> > </tr> > > <tr> > <td width=\"20%\" align=\"left\" valign=\"top\" > bgcolor=\"#efefdf\"><font face=\"verdana, arial, helvetica\" > size=\"-1\"> > <b>Product Experience:</b></font></td> > <td width=\"100%\" align=\"left\" valign=\"top\" > bgcolor=\"#efefdf\"><font face=\"verdana, arial, helvetica\" size=\"-1\"><? > echo $productexperience; ?></font></td> > </tr> > > > > > > > > <tr> > <td width=\"20%\" align=\"left\" valign=\"top\" > bgcolor=\"#efefdf\"><font face=\"verdana, arial, helvetica\" > size=\"-1\"> > <b>Strengths:</b></font></td> > <td width=\"100%\" align=\"left\" valign=\"top\" > bgcolor=\"#efefdf\"><font face=\"verdana, arial, helvetica\" size=\"-1\"><? > echo $strengths: ?></font></td> > </tr> > > <tr> > <td width=\"20%\" align=\"left\" valign=\"top\" > bgcolor=\"#efefdf\"><font face=\"verdana, arial, helvetica\" > size=\"-1\"> > <b>Weaknesses:</b></font></td> > <td width=\"100%\" align=\"left\" valign=\"top\" > bgcolor=\"#efefdf\"><font face=\"verdana, arial, helvetica\" size=\"-1\"><? > echo $weaknesses; ?></font></td> > </tr> > > <tr> > <td width=\"20%\" align=\"left\" valign=\"top\" > bgcolor=\"#efefdf\"><font face=\"verdana, arial, helvetica\" > size=\"-1\"> > <b>Similar Products Tried:</b></font></td> > <td width=\"100%\" align=\"left\" valign=\"top\" > bgcolor=\"#efefdf\"><font face=\"verdana, arial, helvetica\" size=\"-1\"><? > echo $similar; ?><BR></font></td> > </tr> > > > > > <tr> > <td width=\"20%\" align=\"left\" valign=\"top\" > bgcolor=\"#efefdf\"><font face=\"verdana, arial, helvetica\" > size=\"-1\"> > <b>Summary:</b></font></td> > <td width=\"100%\" align=\"left\" valign=\"top\" > bgcolor=\"#efefdf\"><font face=\"verdana, arial, helvetica\" size=\"-1\"><? > echo $summary; ?></font></td> > </tr> > > > <tr> > <td colspan=2 width=\"100%\" align=\"left\" valign=\"middle\" > bgcolor=\"#efefdf\"> > > <font face=\"verdana, arial, helvetica\" size=\"-1\"> > > > <b>Overall Rating:</b> <img src="<? echo $ratingphoto; ?>" > alt="5" > border="0" align=center> > </font> > > </td> > </tr> > > </table> > <br> > '; > > and here is the html: > <div align="left"> > <ul> > <br> > <!-- BEGIN REVIEWS --> > > > <? eval ("$display_block"); ?> > > <!-- END REVIEWS--> > <br> > </ul> > </div> > > Does anyone have any ideas why this isn't fully working? Here is the link: > http://theplayspot.com/genericreviewshow.php > > Also, it is not showing the manufacturer's url like it looks like it should > be. Here is the html for that: > <td> > <!-- End Review Summary --> > <br> > <font face="verdana, arial, helvetica" size="1" > color="000000"> > > </font> > <br> > <font face="verdana, arial, helvetica" size="1" > color="000000"> > <b><? echo $manufacturerurl; ?></b> </font> > <BR> > <font face="verdana, arial, helvetica" size="1" > color="000000"> > <b><a href="<? echo $manufacturerurl; ?>" > target="new"><? echo > $manufacturername; ?></a> </b> > </font> > </td> > > Sorry it is kind of a long e-mail, but I just can't figure this out :(. > Thanks in advance for the help. > > Thanks, > Austin > > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at > http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com. > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >