//$tgl_masukD & $tgl_keluarD = variabel u/tgl inap tamu.
$result1=mysql_query("select * from tabel_kamar order by tarif_kamar asc");
while($myrow1=mysql_fetch_array($result1)){
$id_kamarN=$myrow1["id_kamar"];
$result2=mysql_query("select * from tabel_pesan where
id_kamar='$id_kamarN' and ((tgl_masuk>='$tgl_masukD' and
tgl_masuk<='$tgl_keluarD') or (tgl_masuk<='$tgl_masukD' and
tgl_keluar>='$tgl_masukD'))");
$myrow2=mysql_fetch_array($result2);
if($myrow2["id_kamar"]==0) print $myrow1["no_kamar"]." belum
ditempati.";
}
Semoga membantu,
Handoko Luwanto
----- Original Message -----
From: NewNux
To: [email protected]
Sent: Wednesday, March 28, 2007 1:59 PM
Subject: Re: [ITCENTER] tanya : query pencarian berdasarkan tanggal
On 3/27/07, erfin_gustaman <[EMAIL PROTECTED]> wrote:
>
> buat skripsi ku nih... mohon bantuaanya kk..
>
> relasi tabel untuk pemesanan kamar hotel:
>
> [tabel tamu]
> id_tamu(*)
> nama
> no_identitas
> alamat
> telepon
>
> [tabel pesan]
> id_tamu(**)
> id_kamar(**)
> tgl_masuk
> tgl_keluar
> tgl_pesan
>
> [tabel kamar]
> id_kamar(*)
> tipe_kamar
> fasilitas
> tarif_kamar
> gambar
> no_kamar
>
> bingung kalo pesannya di tanggal yang beda tapi di nomor kamar yang
> sama..
> contoh kasus:
> a) tamu 1 pesan kamar untuk tgl 17-03-2007 s/d 24-03-2007, dikasih no
> kamar 1
> b) tamu 2 pesan kamar untuk tgl 25-03-2007 s/d 31-03-2007, dikasih no
> kamar 1 juga
>
> nah..
> c) tamu 3 pesan kamar untuk tgl 19-03-2007 s/d 31-03-2007,
> dikasihkamar yang masih kosong
>
> querynya gimana ya?? ato relasinya masih salah gitu, harusnya gmn??
>
> NB : dbnya pake mysql
:07 AM
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
## Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
