Jump to content

Displaying two rows


fighnight

Recommended Posts

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>";

}

Link to comment
https://forums.phpfreaks.com/topic/83499-displaying-two-rows/
Share on other sites

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>";

?>

Link to comment
https://forums.phpfreaks.com/topic/83499-displaying-two-rows/#findComment-424833
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.