displaying in a tabular format

Anon

Hello

The following code displays all the records in one line.I would like to display them in a tabular format.

How can i do that?

<?php
$username = "SYSDBA";
$password = "masterkey";
$connection = @ibase_connect('localhost:C:\Myfile\Mydatabase.GDB', $username, $password);
if (!$connection)
{
exit ("Unable to connect to database: $connection");
}
$db = 'Select * from TBL_CUSTOMERS';
$bsc = ibase_query($connection, $db);
while ($row = ibase_fetch_row($bsc)) {
echo $row[0]. "\n";
echo $row[1]. "\n";
}

ibase_free_result($bsc);
ibase_close($connection);

?>

Thanks

Anon

You can mingle HTML and php code. A simple way here is to insert HTML code around your echo statements i.e

...
while ($row = ibase_fetch_row($bsc)) {

<head>
<title>table of records</title>
</head>
<body>
<table>
<tr>
<td>
<?echo $row[0].;?>
</td>
</tr>
<tr>
<td>
<?echo $row[1].;?>
</td>
</tr>
</table>
</body>

<?
}

                      ibase_free_result($bsc);

...etc

Good luck!

/claire

garethlisle

How would you set the alignment within each cell, say to vertical left and horizontal top?

claire

/claire

Anon

Hello claire

None of my records are displayed.I dont know why??

Anon

I fixed it up!

Thank you