Displaying two rows

[fighnight]

I am trying to make a sell page where it shows two rows of information but I get this error/glitch that shows me the same thing over and over again.

 

$myinfo= mysql_query("SELECT * FROM $table WHERE owner = '0' ORDER BY timesold ASC");

while($db_info= mysql_fetch_array($myinfo))
{
echo "<tr><td>$db_info[name] </td> <td>$db_info[name] </td></tr>";

}

[GingerRobot]

Yeah, that would happen. $db_info[name] will contain the same value during each iteration of the while loop. Since you echo it twice in the same iteration, you get the information twice.

 

See here for the FAQ on how to do what you're after.

[Barand]

try

<?php
include 'db.php';

define ("NUMCOLS", 2);

$res = mysql_query("SELECT col1, col2 FROM mytable");

$count = 0;
echo "<TABLE border=1>";
while (list($col1, $col2) = mysql_fetch_row($res)) {

    if ($count % NUMCOLS == 0) echo "<TR>\n";  # new row

    echo "<TD>$col1<br>$col2</TD>\n";
    $count++;

    if ($count % NUMCOLS == 0) echo "</TR>\n";  # end row
}

# end row if not already ended

if ($count % NUMCOLS != 0) {
   while ($count++ % NUMCOLS) echo "<td> </td>";
   echo "</TR>\n";
}
echo "</TABLE>";

?>

[fighnight]

Gingerbot, that code only displays one row and the  

[GingerRobot]

What code would that be?

[fighnight]

Yeah, that would happen. $db_info[name] will contain the same value during each iteration of the while loop. Since you echo it twice in the same iteration, you get the information twice.

 

See here for the FAQ on how to do what you're after.

The current one :]

[GingerRobot]

Your original code? As has been stated by both myself and Barand, it's incorrect. Try one of the solutions we've posted.