I have a question for u...
I have more than four tables rigth now..but i want to query only four tables among them to get the teacher name and subject name base on the date in the date table..here are my four query that i made before..
Expand|Select|Wrap|Line Numbers
- $view = mysql_query("SELECT DISTINCT absen.id_matakuliah, dosen.id_dosen, dosen.nama_dosen, kelasdosen.id_dosen, kelasdosen.id_matakuliah, matakuliah.id_matakuliah, matakuliah.nama_matakuliah FROM absen, dosen, kelasdosen, matakuliah WHERE absen.id_matakuliah=matakuliah.id_matakuliah and matakuliah.id_matakuliah=kelasdosen.id_matakuliah and kelasdosen.id_dosen=dosen.id_dosen and absen.tanggal='2012-10-23'");
"Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\absenkelas\absen\regis\test1.php"
this the php syntaks that i made
Expand|Select|Wrap|Line Numbers
- $view = mysql_query("select absen.id_matakuliah, dosen.id_dosen, dosen.nama_dosen, kelasdosen.id_dosen, kelasdosen.id_matakuliah, matakuliah.id_matakuliah, matakuliah.nama_matakuliah from absen, dosen, kelasdosen, matakuliah where absen.id_matakuliah=matakuliah.id_matakuliah and matakuliah.id_matakuliah=kelasdosen.id_mataku
- liah and kelasdosen.id_dosen=dosen.id_dosen and absen.tanggal='2012-10-23'");
- if($no = 1)
- {
- while($hasil=mysql_fetch_array($lihat))
- {
- echo "<tr> <td>$no</td> <td>$hasil[nama_dosen]</td> <td>$hasil[nama_matakuliah]</td> </tr>";
- ++$no;
- }