- Joined
- Sep 10, 2005
- Messages
- 51
- Reaction score
- 2
i need help. how to display all data from database table
the code show only the first incode record.
table name = record
column name =
Sender
Credit
Debit
Date
Total
Remarks
Thank you for Advance
the code show only the first incode record.
table name = record
column name =
Sender
Credit
Debit
Date
Total
Remarks
PHP:
<?php
$query = mssql_query("SELECT sender, debit, credit,date, remarks,total from record");
$result = mssql_fetch_row($query);?>
<article class="rankingWrap">
<ul class="shadowz" style="width:200px;">
<li class="du">Server Funds/Expenses</li></ul>
<table width="100%" class="rankTable" align="center">
<thead>
<tr>
<th width="20%"><b>Sender</b></th>
<th width="15%"><b>Debit</b><rth>
<th width="15%"><b>Credit</b></th>
<th width="20%"><b>Date</b></th>
<th width="20%"><b>Remarks</b></th>
<th width="15%"><b>total</b></th>
</tr>
</thead>
<tbody>
<h1 align="center" class="heading">Server Funds </h1>
<?php
echo'
<tr align="center">
<td>'.$result[0].'</td>
<td>'.$result[1].'</td>
<td>'.$result[2].'</td>
<td>'.$result[3].'</td>
<td>'.$result[4].'</td>
<td>'.$result[5].'</td>
</tbody></table></article>
</tr>'; ?>
Thank you for Advance