Nested While Loop

[tjverge]

I think the problem is with    echo "<td>".$row["countnow($i)"]."</td>"; it's not showing anything, any ideas how to fix it?

$i = 1;
While ($i <25)
{
?>
  <tr>
    <td><?php echo $i; ?></td>
    <?php 
$sql = "SELECT * FROM `systems` WHERE `solarSystemName` LIKE $sname" or die (mysql_error());
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)){
    echo "<td>".$row["countnow($i)"]."</td>";
}
?>
<tr>
<?php
$i++;
}

[Pikachu2000]

Do you actually have fields in the `systems` table named `countnow1`, `countnow2`, `countnow3` . . . `countnow24`?

[tjverge]

No column names are 1 - 24, countnow is a function

[Pikachu2000]

Actually, countnow($i) is a string by virtue of the fact that it's quoted. Remove the quotes if its to be treated as a function.

[tjverge]

It worked that time, I could of swore I tried that earlier and it would not work. thank again for the help