how coding to sort data by field..i try my codinhg but filed...this is my coding..
<?
include 'dbase.php';
$query ="SELECT * FROM mohon WHERE idpengguna ='$idpengguna' SORT BY id ASC LIMIT 1";
$result = mysql_db_query($dbname,$query);
$row = mysql_fetch_array($result);
$id = $row["id"];
$idpengguna = $row["idpengguna"];
$nama = $row["nama"];
$bahagian = $row["bahagian"];
$masa = $row["masa"];
$tarikh = $row["tarikh"];
$namapengguna = $row["namapengguna"];
$bil = $row["bil"];
$tujuan = $row["tujuan"];
$tarikhprj = $row["tarikhprj"];
$destinasi = $row["destinasi"];
$jam = $row["jam"];
$minit = $row["minit"];
$waktu = $row["waktu"];
$jam2 = $row["jam2"];
$minit2 = $row["minit2"];
$waktu2 = $row["waktu2"];
?>
