Hello ppl.
I need some help here, I have a table in a db with 5 columns-> id,name,adress,phone,fax .
Until now I've made this script for showing the data in my php page:
<table border="0" width="415">
<?
require ("database.inc.php");
$result = mysql_query ("SELECT * FROM bank ORDER BY name DESC ");
while ($data = mysql_fetch_array ($result))
{
?>
<tr><td><b><? echo $data["name"]; ?></b></td</tr>
<tr><td><? echo $data["adress"]; ?></td></tr>
<tr><td><? echo $data["phone"]; ?></td></tr>
<tr><td><? echo $data["fax"]; ?></td></tr>
<?
}
?>
</table>
evrything is fine 'til now , but what I want is to display every row from db like this :
<table border="0" width="415">
<tr><td>row1</td><td>row2</td></tr>
<tr><td>row3</td><td>row4</td></tr>
<tr><td>row5</td><td>row6</td></tr>
.......
</table>
When I say row1, row2... I mean :
<? echo $data["name"]; ?>
<? echo $data["adress"]; ?>
<? echo $data["phone"]; ?>
<? echo $data["fax"]; ?>
I hope you understand what I ment, what I need to do... in few words:
instead of one column, I want 2 becose I can display more data in one page.
Any help is appreciated!!
See ya all.