( HELP ME) how to print values in td? (retriving from db)

[rajmohan]

Hai guys now i am facing a problem in printing a values in td

i want to display a bunch of values from database(countless), that should display it in two td's please help me.

[joking]

Can you plz be more specific about wht u want  ?

Can you post some code ?

[code]
<table width=100%>
<?PHP
$strSQL = mysql_query("SELECT FROM table WHERE ...");
while ( $row = mysql_fetch_object($strSQL) ):?>
<tr>
  <td><?PHP echo $row->$value ?></td>
  <td><?PHP echo $row->$value2 ?></td>
</tr>
<?PHP endwhile;
?>
</table>
[/code]

IS what you want similar to this  ?

[rajmohan]

i want answer for this one


$query = (select * from category); o/p will be one,two,three,four,five,six,..............etc

i want to display it as

one    two
three  four
five    six .......

like this please

[logu]

$result = array('one','two','three','four');

echo "<table><tr>
for($i=0;$i<count($result);$i++){
  echo "<td>".$result[$i]."</td>";

  if(($i+1)%2==0){
        echo "</tr><tr>";
  }
}

echo "</tr></table>";

[rajmohan]

$display_query = mysql_query("select * from trade_category");
$no =mysql_num_rows($display_query);

[b]o/p will be one,two,three,four,five,six,..............etc[/b]
i want to display it as

one    two
three  four
five    six .......

while($res = mysql_fetch_array($display_query))
{
// what should want to come here
}





past one is not working ya

[logu]

echo "<table><tr>";
$i=1;
while($res = mysql_fetch_array($display_query))
{
echo "<td>".$res['field_name']."</td>";
if($i%2==0) echo "</tr><tr>";

}

echo "</tr></table>";

[rajmohan]

thank you it is working ya.