sqrt() of 3 displays, !sqrt() of 3 doesnt

[Kudose]

I have this code, if the number of rows is a square root of 3 (the number of columns I want displayed, then everything is fine. But if it is not, then my footer (bottom.php) is not displayed. Can anyone help?

$kind = $HTTP_GET_VARS['kind']; 
$query = mysql_query("SELECT * FROM auto WHERE kind='$kind'") or die(mysql_error()); 
$num=mysql_num_rows($query) or die(mysql_error()); 

$i=0;

While($i<$num)
{
  $cols = 0; 
  $root = sqrt($cols);
  while($cols!=3) { 
    $row = mysql_fetch_array($query) or die(mysql_error()); 

$link = $row['stockid']; 
$year = $row['year']; 
$make = $row['make']; 
$model = $row['model']; 
$image = $row['image'];

echo "<td><a href='show.php?stockid=$link'><img src='$kind/$image' width='250' 
height='100'><br> $year $make $model </a></td>"; 
   $cols++;
     $i++;
  } if($root == 3){  } else{ echo "</tr><tr>";
   }
} 

Thanks!

[Moonglobe]

first: there is the != operator...

second: where do you change the value of $root ever? its always zero...

[Kudose]

New script, same issue.

<? 
include('top.php'); 
include('left.php'); 
include('dbinfo.inc.php'); 
echo" <td width='81%'><table><tr>"; 

$kind = $HTTP_GET_VARS['kind']; 
$query = mysql_query("SELECT * FROM auto WHERE kind='$kind'") or die(mysql_error()); 
$num=mysql_num_rows($query) or die(mysql_error()); 

$i=0;
$root = sqrt($num); 
while($i<$num)
{
  $cols = 1;   

  while($cols<=3) { 
    $row = mysql_fetch_array($query) or die(mysql_error()); 

$link = $row['stockid']; 
$year = $row['year']; 
$make = $row['make']; 
$model = $row['model']; 
$image = $row['image'];

echo "<td><a href='show.php?stockid=$link'><img src='$kind/$image' width='250' 
height='100'><br> $year $make $model </a></td>"; 
   $cols++;
     $i++;
  } if($root == 3){ echo "</tr>"; } else{ echo "</tr><tr>"; }
} 
echo"
</table> 

</td></tr></table>
<table width='100%' border='0' background='images/bottombg.jpg'><tr>
              <td width='127%' height='15' style='text-align: center'><p align='center'><font size='1' face='Tahoma' color='#000000'><br>
        <strong>©2004 Boulevard Auto Sales, INC &amp; Spechal Effextc Design <br>
        This site is currently managed by <a href='mailto:[e-mail]' target='_blank'>Spechal 
        Effextc</a><br>Website best viewed with IE 6+ and 1024 x 768 resolution.</strong></font></p></td></tr>
    </table>
    </center></div></td>
  </tr> 
 <EMBED SRC='audio/thumbsaudio.mp3' AUTOSTART='true' HIDDEN='true'>
</table></table>
</body>
</html> "; ?> 

Like I said if the num rows query is a square root of 3 then everything is fine, if it isnt, then the bottom include is not displayed.

To see check this:

http://www.blvdcars.com/showcars.php?kind=SUV <-BAD
http://www.blvdcars.com/showcars.php?kind=Car <-GOOD

THANKS

[Kudose]

grr. 🙁

[Moonglobe]

you don't want square root, you want modulus, which is % in php i.e.:

if ($numrows % 3 == 0) //divisible by three evenly
{
    //...
}
else
{
    //..
}

[Kudose]

changed to this with 0 effects 🙁

$kind = $HTTP_GET_VARS['kind']; 
$query = mysql_query("SELECT * FROM auto WHERE kind='$kind'") or die(mysql_error()); 
$num=mysql_num_rows($query) or die(mysql_error()); 

$i=0;
while($i<$num)
{
  $cols = 1;   

  while($cols<=3) { 
    $row = mysql_fetch_array($query) or die(mysql_error()); 

$link = $row['stockid']; 
$year = $row['year']; 
$make = $row['make']; 
$model = $row['model']; 
$image = $row['image'];

echo "<td><a href='show.php?stockid=$link'><img src='$kind/$image' width='250' 
height='100'><br> $year $make $model </a></td>"; 
   $cols++;
     $i++;
  } if($num %3 == 0){ echo "</tr>"; } else{ echo "</tr><tr>"; }
}