Re: ->>coding help

Oh yeah: I forgot: *AFTER* the loop, you need to add another spurious </TR>. You'll have an empty row with no TD's in it, and the browser won't even put in a blank line or anything. Just spew out an extra </TR> at the end and call it done. -- WARNING richard@zend.com address is an endangered species -- Use ceo@l-i-e.com Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm ----- Original Message ----- From: "McShen" <webmaster@celeritieszones.com> Newsgroups: php.general Sent: Saturday, June 23, 2001 10:13 PM Subject: [PHP] ->>coding help > Hi > > I have a script which queries mySQL and outputs 32 links at once. Here is my > scipt > ---- > <?php > > $connection = mysql_connect("***","****","****"); > if ($connection==false) > { > echo mysql_errno().":".mysql_error().""; > exit; > } > > $end = $list + 16; > > $query = "SELECT * FROM refer ORDER BY hits desc LIMIT $list, $end"; > $result = mysql_db_query ("celebzone", $query); > > $num = mysql_num_rows($result); > > $j=0; > $i=0; > echo "<table border=0>\n"; > echo "<tr>\n"; > while ($j!=$num) > { > @$r = mysql_fetch_array($result); > @$id = $r[id]; > @$title = $r[title]; > > echo "<td>\n"; > echo "$title"; > echo "</td>\n"; > // new row in table every other link > $i++; > if (($i % 2) < 1) > { > echo "</tr>\n<tr>\n"; > } > > $j++; > } > echo "</table>"; > > echo "<br><br>\n"; > > > ?> > ----------------------- > And here is the link to see it in action > http://www.celebritieszones.com/ln.php?list=0 > > If you check my HTML source, at the end, right before </table>, you will see > an extra <tr>. I know the cause of this. It's because of this > ------- > " > $i++; > if (($i % 2) < 1) > { > echo "</tr>\n<tr>\n"; > } > " > ----- > > I don't know how to fix the problem. Please help me re-write the script a > bit so that it doesn't add the extra <tr>. > > Thanks in advance. > > > > -- > 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 >