Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2001062

[PHP] ->>coding help From: McShen (webmaster <email protected>)
Date: 06/23/01

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 <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>