RE: [PHP] ->>coding help
| From: | Jason Lotito | Date: | Sun, 24 Jun 2001 04:39:26 +0000 |
| Subject: | RE: [PHP] ->>coding help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-55011@lists.php.net to get a copy of this message | ||
This should work...
<?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";
for ($j = 0; $j < $num; $j++)
{
echo '<tr>\n';
for ($i = 0; $i <= 1; $i++)
{
@$result = mysql_fetch_array($result);
@$id = $result[id];
@$title = $result[title];
echo "<td>\n";
echo "$title";
echo "</td>\n";
}
echo "</tr>\n";
}
echo "</table>";
echo "<br><br>\n";
?>
Jason Lotito
www.NewbieNetwork.net
PHP Newsletter: http://www.newbienetwork.net/ciao.php
PHP, MySQL, PostgreSQL Tutorials, Code Snippets, and so much more
> -----Original Message-----
> From: McShen [mailto:webmaster@celeritieszones.com]
> Sent: Saturday, June 23, 2001 11:22 PM
> To: php-general@lists.php.net
> 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.