how query four tables from the database

[g30r9e]

Hi,

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..

$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'");

and when I run it in php...i got an error which says..

"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

$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;
     }

i'm an indonesian so i'm using indonesia language in my syntaks...thanks before for helping me...i really need the answer

[Rabbit]

Please use code tags when posting code.

On line 5, you're trying to fetch data from a variable called $lihat. But as far as I can tell, $lihat is not set to anything. Shouldn't you be trying to fecth data from $view? It's the variable that has the result of the query you ran.