Re: Need Help with database output
| From: | Phansys Corp | Date: | Sat, 28 Aug 2010 19:57:05 +0000 |
| Subject: | Re: Need Help with database output | ||
| References: | 1 | Groups: | php.db php.windows |
| Request: | Send a blank email to php-db+get-47349@lists.php.net to get a copy of this message | ||
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@gmail.com>
> 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.
>