rajmohan Posted September 1, 2006 Share Posted September 1, 2006 Hai guys now i am facing a problem in printing a values in tdi want to display a bunch of values from database(countless), that should display it in two td's please help me. Quote Link to comment Share on other sites More sharing options...
joking Posted September 1, 2006 Share Posted September 1, 2006 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 ? Quote Link to comment Share on other sites More sharing options...
rajmohan Posted September 1, 2006 Author Share Posted September 1, 2006 i want answer for this one$query = (select * from category); o/p will be one,two,three,four,five,six,..............etci want to display it asone twothree fourfive six .......like this please Quote Link to comment Share on other sites More sharing options...
logu Posted September 1, 2006 Share Posted September 1, 2006 $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>"; Quote Link to comment Share on other sites More sharing options...
rajmohan Posted September 1, 2006 Author Share Posted September 1, 2006 $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 asone twothree fourfive six .......while($res = mysql_fetch_array($display_query)){// what should want to come here}past one is not working ya Quote Link to comment Share on other sites More sharing options...
logu Posted September 1, 2006 Share Posted September 1, 2006 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>"; Quote Link to comment Share on other sites More sharing options...
rajmohan Posted September 1, 2006 Author Share Posted September 1, 2006 thank you it is working ya. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.