html数据库排序,排序HTML表格用PHP输入之后，从数据库

我创建与MySQL数据库的数据行和一些计算值的HTML表，就像这样：排序HTML表格用PHP输入之后，从数据库

$connection = mysql_connect('localhost','root','') or die('Connection failed!');

mysql_select_db('MyDB', $connection);

$result = mysql_query('SELECT * FROM DB_TABLE');

?>

Heading 1	Tariefplan	Abonnementskost	Maandelijkse korting	Contractduur	Inbegrepen in bundel	Tarieven buiten bundel		Bereken minuten	Bereken SMS'en	Bereken MB's		Totale prijs normaal	Totale prijs promotie	Totale prijs contract

while ($data = mysql_fetch_assoc($result)) {

?>

<?php echo $data['provider']; ?><?php echo $data['planname']; ?>€ <?php echo $data['price_normal']; ?> per maand

_{gedurende <?php echo ($data['contract_duration']-$data['promo_duration']); ?> maanden}

- € <?php echo $data['promo_discount']; ?> per maand

_{gedurende <?php echo $data['promo_duration']; ?> maanden}

_{promotie geldig tot <?php echo $data['promo_valid']; ?>}

<?php echo $data['contract_duration']; ?> maanden

• <?php echo $data['included_min']; ?> minuten
• <?php echo $data['included_sms']; ?> SMS'en
• <?php echo $data['included_mb']; ?> MB's
• € <?php echo $data['included_value']; ?> belwaarde

• € <?php echo $data['price_min']; ?> per minuut
• € <?php echo $data['price_sms']; ?> per SMS
• € <?php echo $data['price_mb']; ?> per MB

if ($_POST['used_min'] <= $data['included_min']) {

$calc_min = 0;

}

else {

$calc_min = ($_POST['used_min'] - $data['included_min']) * $data['price_min'];

}

echo '€ ' . $calc_min;

?>

if ($_POST['used_sms'] <= $data['included_sms']) {

$calc_sms = 0;

}

else {

$calc_sms = ($_POST['used_sms'] - $data['included_sms']) * $data['price_sms'];

}

echo '€ ' . $calc_sms;

?>

if ($_POST['used_mb'] <= $data['included_mb']) {

$calc_mb = 0;

}

else {

$calc_mb = ($_POST['used_mb'] - $data['included_mb']) * $data['price_mb'];

}

echo '€ ' . $calc_mb;

?>

$used_total = ($calc_min + $calc_sms + $calc_mb);

if ($data['included_value'] > $used_total) {

$total_price_normal = $data['price_normal'];

}

else {

$total_price_normal = ($data['price_normal'] + $used_total);

}

echo '€ ' . $total_price_normal . ' per maand';

?>

$total_price_discount = ($total_price_normal - $data['promo_discount']);

echo '€ ' . $total_price_discount . ' per maand';

?>

$total_price_contract = ($total_price_normal * ($data['contract_duration']-$data['promo_duration'])) + ($total_price_discount * $data['promo_duration']);

echo '€ ' . $total_price_contract . ' per maand ' . $data['contract_duration'] . ' na maanden';

?>

在表格的最后一栏是一个变量值女巫计算总量。这不在数据库中列出。 我想输出这个表到一个浏览器页面，让我们排序在最后一列。

随着PHP sort()或不正常工作asort()功能。

是否有人有办法解决吗？

2011-12-16

Jens