Problems with ARRAY_SLICE()

[nicdp]

I have a query and want to divide up the results into 2 table columns. I tried with array_slice() but it doens't work. Here is my code.

<table width="360">
<?php

require("../required/config.php");
$connect = mysql_connect($server,$user,$pass);
$select_db = mysql_select_db($db, $connect);

$query = mysql_query("SELECT * FROM partyround_categorie ORDER BY nome", $connect);
$num_rows = mysql_num_rows($query);
$i=$num_rows/2;

$input = mysql_fetch_array($query);
$output1 = array_slice ($input, 0, $i);
$output2 = array_slice ($input, $i);
?>

<tr>
<td width="50%">

<?php
while($cat1 = mysql_fetch_array($output1)){
$nome1 = $cat1["nome"];
echo $nome1; ?><br><?php } ?>

</td>

<td width="50%">

<?php
while($cat2 = mysql_fetch_array($output2)){
$nome2 = $cat2["nome"];
echo $nome2; ?><br><?php } ?>

</td>

</table>

[nemonoman]

I think your code is a bit screwy is all...

Try something like:
$query = mysql_query("SELECT * FROM partyround_categorie ORDER BY nome", $connect);
$num_rows = mysql_num_rows($query);
$i=$num_rows/2;

for ($i=0,i<$num_rows/2,$i++){
$cat1 = mysql_fetch_array($query))
$nome1 = $cat1["nome"];
echo $nome1;
}

for ($i=$num_rows/2, $i<$num_rows, $i++){
$cat2 = mysql_fetch_array($query))
$nome2 = $cat2["nome"];
echo $nome2;
}

[nicdp]

Thanks! It works with a couple of changes...

Here is the final code... maybe it can help someone with my same problem.

  <?php  

require("../required/config.php");
$connect = mysql_connect($server,$user,$pass);
$select_db = mysql_select_db($db, $connect);

$query = mysql_query("SELECT * FROM partyround_categorie ORDER BY nome", $connect);
$num_rows = mysql_num_rows($query);
$half_rows=$num_rows/2;

?>

            <tr bgcolor="#C4E4FF"> 
              <td width="50%" valign="top"> <?php 

for($i=0; $i<$half_rows; $i++){
$cat1 = mysql_fetch_array($query);
$id1 = $cat1["id"];
$nome1 = $cat1["nome"];
?>
<input class="medium" type="checkbox" name="cat<?php echo $id1; ?>" value="1">
<font class="medium"><?php echo $nome1."<br>"; ?></font><?php } ?>
</td>
<td width="50%" valign="top"> <?php
for($i=$half_rows; $i<$num_rows; $i++){
$cat2 = mysql_fetch_array($query);
$id2 = $cat2["id"];
$nome2 = $cat2["nome"];
?>
<input class="medium" type="checkbox" name="cat<?php echo $id1; ?>" value="1">
<font class="medium"><?php echo $nome2."<br>"; ?></font><?php } ?>
</td>

            </tr>