[SOLVED] if($row%2 == 0) is not working, why ?

[plodos]

<?php
$q = "select * from research_field order by id asc";
$query = mysql_query($q);
echo "<table border='0' width='100%' id='table3'><tr>";

while ($row = mysql_fetch_array($query))
{
   $opstr ="<td><input type='checkbox' name='state[]' value='{$row['id']}'>{$row['field']}</td>";
   if($row%2 == 0)
   {  
      echo "</tr><tr>".$opstr;
   }
   else
   {
      echo $opstr;
   }
}
echo "</tr></table>";
?>

 

but the output is like that (side by side)....there must be </tr><tr> after 2,4,6...

<table border='0' width='100%' id='table3'><tr><td><input type='checkbox' name='state[]' value='1'>Acoustics</td><td><input type='checkbox' name='state[]' value='2'>Antennas/RF Front Ends </td><td><input type='checkbox' name='state[]' value='3'>Biological and Medical </td><td><input type='checkbox' name='state[]' value='4'>Computer aided design: linear</td> . . . 

 

i want to seperate with 2 colums....this part is not working, why ?

  if($row%2 == 0)
   {  
      echo "</tr><tr>".$opstr;
   } 

[Mark Baker]

Because $row is an array of data from the mysql_fetch_array($query), not a numeric value

[tomfmason]

try

<?php
$q = "select * from research_field order by id asc";
$query = mysql_query($q);
echo "<table border='0' width='100%' id='table3'><tr>";
$i=0;
while ($row = mysql_fetch_array($query))
{
   $opstr ="<td><input type='checkbox' name='state[]' value='{$row['id']}'>{$row['field']}</td>";
   if($i%2)
   {  
      echo "</tr><tr>".$opstr;
   }
   else
   {
      echo $opstr;
   }
    $i++;
}
echo "</tr></table>";
?>

[plodos]

thank you