[jasper199069]

hello goor people,

i am trying to make a nice list from a mysql query but at the moment i can only display one list while i'd like to display three different results next to each other.

this is the code i already have:

<?php
$sql = "SELECT * FROM tbl_users WHERE `school`='".$w_user->user_school."' AND `group`='".$w_user->user_group."' AND `function`='student'";

$result = mysql_query( $sql );

echo("<table border=\"1\">");
while( $row = mysql_fetch_array( $result ) )
{
  ?>
  <tr>
  <td><input type="checkbox" name="check[<?php echo( $num ); ?>]" value="<?php echo( $row["ID"] ); ?>"></td><td><?php echo( $row["name"]." ".$row["a_naam"]." ".$row["last_name"] ); ?></td>
  </tr>
  <?php
  $num++;
}
echo("</table>");

?>

can someone help me with this

greets japie

[CTphpnwb]

If you echo $sql, does the query look like you intended?

[jasper199069]

CTphpnwb, on 22 June 2010 - 06:40 AM, said:

If you echo $sql, does the query look like you intended?

Yes the sql is exactly what i intended

the only thing is that i want is a table with different results im more colums.

thanks in advance

[Dormilich]

you mean like 3 times [ID, name, last_name] in a row?

[no2pencil]

Try passing MYSQL_ASSOC to the mysql_fetch_array function. If that doesn't work, then use looping integers rather than ID, name, a_naam, & last_name.