help with mysql_fetch_array

[ungovernable]

ok i have this really basic script, basically it just output a list of the rows inside a table

<table><?php
$f5 = "$bbuserinfo[field5]";
$query = "SELECT * FROM quebec_userfield WHERE field5='$f5' ORDER BY userid DESC";
$res = mysql_query($query) or die(mysql_error());  

while($row = mysql_fetch_array($res)) { 
$id = $row["userid"];

$query = "SELECT username, userid FROM quebec_user WHERE userid=$id ORDER BY userid DESC";
$res = mysql_query($query) or die(mysql_error());  

while($row = mysql_fetch_array($res)) { 
$nom = $row["username"];
echo "<tr><td><a href=\"member.php?username=$nom\"> &#8226; ";
echo $nom;
echo "</a></td></tr>";
}

}
?></table>

As you can see i made a HTML table, and a new <tr> is created for each entry

the result is something like

<table>
<tr><td>entry1</td></tr>
<tr><td>entry2</td></tr>
<tr><td>entry3</td></tr>
<tr><td>entry4</td></tr>
<tr><td>entry5</td></tr>
<tr><td>entry6</td></tr>
</table>

what i want to do is list TWO ENTRY per line....

so i want a result like

<table>
<tr><td>entry1</td><td>entry2</td></tr>
<tr><td>entry3</td><td>entry4</td></tr>
<tr><td>entry5</td><td>entry6</td></tr>
</table>

could someone help me with this?

[halojoy]

you make a flag,
that
flips value 1-0-1-0-1, for each while loop

the easiest way to flip such a flag is: $new = 1 - $old;

Regards 🙂
halojoy - your coder

<!-- start of table -->
<table>
<?php
$f5 = "$bbuserinfo[field5]";
$query = "SELECT * FROM quebec_userfield WHERE field5='$f5' ORDER BY userid DESC";
$res = mysql_query($query) or die(mysql_error());  

while($row = mysql_fetch_array($res)) { //WHILE #1
$id = $row["userid"];

$query = "SELECT username, userid FROM quebec_user WHERE userid=$id ORDER BY userid DESC";
$res = mysql_query($query) or die(mysql_error());  

$flag = 0;  // initial value
while($row = mysql_fetch_array($res)) { //WHILE #2

$nom = $row["username"];
$flag = 1-$flag;
if ( $flag ){ // is 1
    echo "<tr><td><a href=\"member.php?username=$nom\"> &#8226; ";
    echo $nom;
    echo "</a></td>";
}else{ // is 0
    echo "<td><a href=\"member.php?username=$nom\"> &#8226; ";
    echo $nom;
    echo "</a></td></tr>";
}

} //END WHILE #2

// FIX to close row for Un-Even number of items: 1,3,5,7 ..
if ( $flag ){ // is 1
    echo "<td></td></tr>"; // empty <td>
}

} //END WHILE #1

?>
</table>
<!-- end of table -->

[ungovernable]

This is working perfectly! I had to take out the fix for un-even number of items because else it was displaying only one item per row, but it is still working even with uneven numbers!

thanks once again for the help, and for the very-well commented code!

i learned something again 🙂

[laserlight]

PHP has a boolean type, so you might want to use that instead for a flag. You would just change:

$flag = 0;

to

$flag = false;

and change:

$flag = 1-$flag;

to:

$flag = !$flag;

That said, a flag only works when you have two columns. A more general solution would involve keeping a row count and using modulo to determine when to begin and row and when to end a row.