loop not working

[Anon]

I want to write a scrip that displays data in a list form. However I just want it to display 75 items and then create a new column (basically another cell in a one row HTML table) to display the data.

I've tried two ways to create this but for some reason the inner loop doesn't work.

$max is the number of columns that will be created and this does work. Assume for now that $max = 2 so I want 2 columns created.

$info = mysql_query("SELECT * FROM data WHERE id > 30 ORDER BY id ASC LIMIT 75");
echo "<TABLE width=650>";
for ($counter=0; $counter < max; $counter++)
{
echo "<TD>";
for ($count=1; $count < 75; $count++)
{
$result = mysql_fetch_row($info);
print $result[0];
print $result[1];
print $result[9];
}
echo "</TD>";
}

The print commands never work. I've always tried just printing things in the inner loop but it just skips over anything in there. I've also tried a variation like this

while ($result = mysql_fetch_row($info);
{

blah
}

but that doesn't work either.

Why is the inner loop being ignored?

[brandonschnell]

1) does it print the table row tags? "<TD>"?

2) what is "max"? shouldn't that be set to a value or be $max, a variable?

[Anon]

Max should be $max and I fixed it. Thanks for spotting that out. Once I did that it would print out the <TD> tags. Now I have a new problem.
$test = mysql_query("SELECT FROM topic WHERE newest > 30");
$max = mysql_num_rows($test);
print $max;
$net = $max;
$max = ($max / 75);
$max = ceil($max);
$info = mysql_query("SELECT FROM topic WHERE newest > 30 ORDER BY newest ASC LIMIT '$net'");
echo "<TABLE width=650>";
print $max;
print $net;
echo "<BR>";
for ($counter=1; $counter < $max; $counter++)
{
echo "<TD>";
print $max;
while ($result = mysql_fetch_row($info) )
{
if ($result[4] != "")
{
echo result[1]...[7];
echo "<BR>";
}
echo "</TD>";
}
?>

And this is the error I get
Warning: 0 is not a MySQL result index in /home/blah.php3 on line 33

Line 33 is: print $max;

I think it dies when it gets to the inner loop the first time.

[brandonschnell]

1) make sure you're counting the lines correctly

2) make sure that the previous mysql_query() is completing successfully. run "echo mysql_error();" right after the mysql_query() and see if what happens

[kparker]

Oops, you are exactly right, except the table row tag should be &lt;TR&gt;
not TD.

[kparker]

You're still missing Brandon's first item, which is that you're forgetting to put any ROWS in your table using &lt;TR&gt; and &lt;/TR&gt;