salam...
sy dh tersangkut sikit ni...sy nak buat content filter, where user boleh filter data yang mereka nak by selecting the provided dropdown. ade tiga dropdown yang diberi
1. bulan
2. status aduan
3. jenis kerosakan
kire user boleh filter rekod yg mereka nk by choosing all of the dropdown, pilih dua, pilih salah satu and if user tak pilih apa-apa then trus tekan submit all of the record will be display..masalah sekarang ni ada prob sikit bile user nk filter by selecting only one of the dropdown and bile user tak pilih apa-apa..query dia tak jalan...dh naik juling dh mate ni nk cari error dia, or struktur if...else if yang saya buat ni tak bape betoi...saya pun tak sure dh ni...so kalau boleh nk mintak tolong kengkwn sume...ade suggestion or jln penyelesaian lain tak...
ni structure query yg sy dh buat....kira stat dr query yang bertande problem starts till ke problem ends tu masalah...dia tak boleh ditect selection yang dibuat by user...
sy dh tersangkut sikit ni...sy nak buat content filter, where user boleh filter data yang mereka nak by selecting the provided dropdown. ade tiga dropdown yang diberi
1. bulan
2. status aduan
3. jenis kerosakan
kire user boleh filter rekod yg mereka nk by choosing all of the dropdown, pilih dua, pilih salah satu and if user tak pilih apa-apa then trus tekan submit all of the record will be display..masalah sekarang ni ada prob sikit bile user nk filter by selecting only one of the dropdown and bile user tak pilih apa-apa..query dia tak jalan...dh naik juling dh mate ni nk cari error dia, or struktur if...else if yang saya buat ni tak bape betoi...saya pun tak sure dh ni...so kalau boleh nk mintak tolong kengkwn sume...ade suggestion or jln penyelesaian lain tak...
ni structure query yg sy dh buat....kira stat dr query yang bertande problem starts till ke problem ends tu masalah...dia tak boleh ditect selection yang dibuat by user...
- Code:
<?php
if(isset($_POST['Submit']))
{
$status=$_POST['status'];
$bulan=$_POST['bulan'];
$jenis=$_POST['jenis'];
/*if($status=="#")
{
echo"<script language='JavaScript'>alert('Sila buat pilihan bulan');</script>";
echo'<meta http-equiv="refresh" content="0;URL=query.php">';
}
if($bulan=="#")
{
echo"<script language='JavaScript'>alert('Sila buat pilihan status aduan');</script>";
echo'<meta http-equiv="refresh" content="0;URL=query.php">';
}
if($jenis=="#")
{
echo"<script language='JavaScript'>alert('Sila buat pilihan status jenis kerosakan');</script>";
echo'<meta http-equiv="refresh" content="0;URL=query.php">';
}*/
if ($bulan == "semua")
{
echo $qry ="SELECT * FROM aduan,kerosakan WHERE aduan.status='$status' AND kerosakan.jenis_kerosakan='$jenis' AND aduan.kolej='$kolej' AND aduan.no_aduan = kerosakan.no_aduan GROUP BY kerosakan.no_aduan";
$qid = mysql_query($qry);
}
else if ($status == "semua")
{
echo $qry ="SELECT * FROM aduan,kerosakan WHERE (DATE_FORMAT(aduan.tarikh_aduan, '%M %Y')='$bulan' AND kerosakan.jenis_kerosakan= '$jenis') AND aduan.kolej='$kolej' AND aduan.no_aduan = kerosakan.no_aduan GROUP BY kerosakan.no_aduan";
$qid = mysql_query($qry);
}
else if ($jenis == "semua")
{
echo $qry ="SELECT * FROM aduan,kerosakan WHERE (DATE_FORMAT(aduan.tarikh_aduan, '%M %Y')='$bulan' AND aduan.status='$status') AND aduan.kolej='$kolej' AND aduan.no_aduan = kerosakan.no_aduan GROUP BY kerosakan.no_aduan";
$qid = mysql_query($qry);
}
else if (($bulan == "semua") && ($status == "semua")) <------problem starts
{
echo $qry ="SELECT * FROM aduan,kerosakan WHERE kerosakan.jenis_kerosakan='$jenis' AND aduan.kolej='$kolej' AND aduan.no_aduan = kerosakan.no_aduan GROUP BY kerosakan.no_aduan";
$qid = mysql_query($qry);
}
else if (($status == "semua") && ($jenis == "semua"))
{
echo $qry ="SELECT * FROM aduan,kerosakan WHERE DATE_FORMAT(aduan.tarikh_aduan, '%M %Y')='$bulan' AND aduan.kolej='$kolej' AND aduan.no_aduan = kerosakan.no_aduan GROUP BY kerosakan.no_aduan";
$qid = mysql_query($qry);
}
else if (($bulan == "semua") && ($jenis == "semua"))
{
echo $qry ="SELECT * FROM aduan,kerosakan WHERE aduan.status='$status' AND aduan.kolej='$kolej' AND aduan.no_aduan = kerosakan.no_aduan GROUP BY kerosakan.no_aduan";
$qid = mysql_query($qry);
}
else if (($bulan == "semua") && ($status == "semua") && ($jenis == "semua"))
{
echo $qry ="SELECT * FROM aduan,kerosakan WHERE aduan.kolej='$kolej' AND aduan.no_aduan = kerosakan.no_aduan GROUP BY kerosakan.no_aduan";
$qid = mysql_query($qry);
} <---------problem ends
else
{
echo $qry ="SELECT * FROM aduan,kerosakan WHERE (DATE_FORMAT(aduan.tarikh_aduan, '%M %Y')='$bulan' AND aduan.status='$status' AND kerosakan.jenis_kerosakan='$jenis') AND aduan.kolej='$kolej' AND aduan.no_aduan = kerosakan.no_aduan GROUP BY kerosakan.no_aduan";
$qid = mysql_query($qry);
}
.................
?>