Re: ->>coding help

McShen wrote: > 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 Try adding a ; after the \n