Re: [PHP-WIN] Need Help with database output

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <nagendra802000@xxxxxxxxx>

> 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.
>

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux