Displaying data from database with design....any idea please

duelist

hi, do you have any idea,how can i insert the code in the coding below to make better display.

<?
$database = "tresco";
mysql_connect (localhost,"","");
@mysql_select_db($database) or die("Unable to select database");
$query = "SELECT * FROM petty_cash";
$result = mysql_query ($query);

$num = mysql_numrows($result);

mysql_close();

$i = 0;
while ($i < $num) {
$payee = mysql_result($result, $i, "payee");
$payment_of = mysql_result($result, $i, "payment_of");
$pv = mysql_result($result, $i, "pv");
$petty_month = mysql_result($result, $i, "petty_month");
$petty_day = mysql_result($result, $i, "petty_day");
$petty_year = mysql_result($result, $i, "petty_year");
$cheque = mysql_result($result, $i, "cheque");
$doc = mysql_result($result, $i, "doc");
$inv = mysql_result($result, $i, "inv");
$amount = mysql_result($result, $i, "amount");
$total_amount = mysql_result($result, $i, "total_amount");

echo "<b>Payment:$payee<br>Name:$payment_of<br>P.V. No:$pv<br>Date:$petty_day 	$petty_month $petty_year<br>Cheque No.:$cheque<br>Purpose:$doc<br>Invoice No.:$inv<br>Amount:$amount<br><hr><br>";

$i++;
}

the display you can see from the attchment

so,do u have any idea how to enhance the display,let say it can be display in table form etc

thanks.

sneakyimp

yes try using a table. output your <table> tag and a header row before you enter the while loop and then for each iteration of the while loop output a new table row with each data point in its own table cell.

you may also want to alternate colors for each row. this is helpful when viewing a bunch of records.

Houdini

This is not tested but should give you a better looking result, It puts table headers then rows of data, and with a little tweaking you could do what you want with it.

$i = 0;
echo "<table border=1><tr>";
echo"<th>Payment:</th><th>Name:</th><th>P.V. No:</th><th>Date:</th><th>Cheque No.:</th>
<th>Purpose:</th><th>Invoice No.:</th><th>Amount:</th>";
while ($i < $num) {
$payee = mysql_result($result, $i, "payee");
$payment_of = mysql_result($result, $i, "payment_of");
$pv = mysql_result($result, $i, "pv");
$petty_month = mysql_result($result, $i, "petty_month");
$petty_day = mysql_result($result, $i, "petty_day");
$petty_year = mysql_result($result, $i, "petty_year");
$cheque = mysql_result($result, $i, "cheque");
$doc = mysql_result($result, $i, "doc");
$inv = mysql_result($result, $i, "inv");
$amount = mysql_result($result, $i, "amount");
$total_amount = mysql_result($result, $i, "total_amount");

echo "<td>$payee</td><td>$payment_of</td></td>$pv</td><td>$petty_day $petty_month $petty_year</td><td>$cheque</td><td>$doc</td><td>$inv</td><td>$amount</td></tr><tr>";

$i++;
echo "</table>";
}

Roger_Ramjet

2 things:

Don't use mysql_result
"When working on large result sets, you should consider using one of the functions that fetch an entire row (specified below). As these functions return the contents of multiple cells in one function call, they're MUCH quicker than mysql_result(). "
Use mysql fetch array instead.
the use of mysql_close() is not necessary or recommended
" Using mysql_close() isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution."

and
"Due to the reference-counting system introduced with PHP 4's Zend Engine, it is automatically detected when a resource is no longer referred to (just like Java). When this is the case, all resources that were in use for this resource are made free by the garbage collector. For this reason, it is rarely ever necessary to free the memory manually by using some free_result function."
I'm also surprised that you get to display anything as it was my understanding that closing the db connection would destroy the results as well. PHP must be smart enough to see that you still want the resultset and so hold the db resource for you.