Re: Need Help with database output

Hi Nagendra!

<?php

///...require to $link_resource mysql

$query = 'SELECT Col1, Col2, Col3 FROM table';
$rs_query = mysql_query($query, $link_resource);
$row_rs_query = mysql_fetch_assoc($rs_query);
$total_row_rs_query = mysql_num_rows($rs_query);

if ($total_row_rs_query > 0) {
  echo
'<table><thead><tr><th>Col1</th><th>Col2</th><th>Col3</th></tr></thead>';
  do {
    echo '<tr><td>', $row_rs_query['Col1'], '</td><td>', $row_rs_query['Col2'],
'</td><td>', $row_rs_query['Col3'], '</td></tr>';
  } while($row_rs_query = mysql_fetch_assoc($rs_query));
  echo '</table>';
}
mysql_free_result($rs_query);

?>

2010/8/28 nagendra prasad <[email protected]>

> Hi All,
>
> I have a database and I want to show it in 3 columns Like
>
> Col1       Col2     Col3
> data1       data2   data3
> data4       data5   data5
> ........       .......    ........
>
>
> I tired using table but its not working. Please help me.
>
> Best,
> guru.
>