Jump to content


Photo

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


  • Please log in to reply
6 replies to this topic

#1 rajmohan

rajmohan
  • Members
  • PipPipPip
  • Advanced Member
  • 169 posts

Posted 01 September 2006 - 05:45 AM

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.



#2 joking

joking
  • Members
  • PipPip
  • Member
  • 29 posts
  • LocationLebanon

Posted 01 September 2006 - 05:51 AM

Can you plz be more specific about wht u want  ?

Can you post some 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>

IS what you want similar to this  ?

Just JoKinG

#3 rajmohan

rajmohan
  • Members
  • PipPipPip
  • Advanced Member
  • 169 posts

Posted 01 September 2006 - 06:20 AM

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

#4 logu

logu
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts

Posted 01 September 2006 - 06:28 AM

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

#5 rajmohan

rajmohan
  • Members
  • PipPipPip
  • Advanced Member
  • 169 posts

Posted 01 September 2006 - 06:43 AM

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

o/p will be one,two,three,four,five,six,..............etc
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

#6 logu

logu
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts

Posted 01 September 2006 - 06:56 AM

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

#7 rajmohan

rajmohan
  • Members
  • PipPipPip
  • Advanced Member
  • 169 posts

Posted 01 September 2006 - 07:10 AM

thank you it is working ya.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users