Belajar select join sukses di elearning

<?php
session_start();

if(isset($_POST['kirim'])){
$src = $_POST['cari'];
}else{
$src = $_SESSION['cari'];
}
$_SESSION['cari'] = $src ;
?>
<form method="post" action="">
<left><input type="text" id="cari" class="form-control" style="width:350px; vertical-align:middle;" name="cari" placeholder="Cari nama dosen" value="<?=$src?>">
                <button type="submit" name="kirim" class="btn">Cari</button><br></form>
<hr>
<center>
<link rel="stylesheet" type="text/css" href="wahid74.css" />




<?php

//=============PAGING ========================
$batas=20;
$halaman=$_GET['halaman'];
$posisi=null;
if(empty($halaman)){
$posisi=0;
$halaman=1;
}else{
$posisi=($halaman-1)* $batas;
}
//=============PAGING ========================



$query1 = mysql_query("
SELECT a.id, a.firstname, a.city, a.lastname, b.roleid, b.contextid, c.instanceid, e.name, e.parent  FROM `info_user` a
left join info_role_assignments b on b.userid=a.id
left join info_context c on c.id=b.contextid
left join info_context d on d.id=c.instanceid
left join info_course_categories e on e.id=c.instanceid
WHERE a.firstname LIKE 'teknik' and b.roleid='3' and e.parent='13'
and (a.firstname LIKE '%$src%' or a.lastname LIKE '%$src%' )

ORDER BY `a`.`lastaccess` DESC LIMIT $posisi,$batas");



while($row=mysql_fetch_array($query1)){
?>


<div class="wahid_dosen">
<table width="100%" border="0">
<tbody>
<tr><td width="10px" valign="top">
<a href="/course/category.php?id=<?=$row['instanceid']?>" class="alumni-2"><img src="../user/pix.php?file=/<?=$row['id']?>/f1.jpg" width="80px" height="80px"/></a>
</td><td valign="top"><div class="rightDownRadius">

<?=$row['lastname']?><br>
<?=$row['city']?><br>
<a href="/course/category.php?id=<?=$row['instanceid']?>">Matakuliah yang diampu :</a>
</div>
</td></tr></tbody></table>

</div>


<?} ?>
<h3>
<br>
<?php
//=============PAGING ========================
$sql_paging = mysql_query("SELECT a.id, a.firstname, a.city, a.lastname, b.roleid, b.contextid, c.instanceid, e.name, e.parent  FROM `info_user` a
left join info_role_assignments b on b.userid=a.id
left join info_context c on c.id=b.contextid
left join info_context d on d.id=c.instanceid
left join info_course_categories e on e.id=c.instanceid
WHERE a.firstname LIKE 'teknik' and b.roleid='3' and e.parent='13'and (a.firstname LIKE '%$src%' or a.lastname LIKE '%$src%' ) ");
$jmldata = mysql_num_rows($sql_paging);
$jumlah_halaman = ceil($jmldata / $batas);

echo "Halaman :";
for($i = 1; $i <= $jumlah_halaman; $i++)
if($i != $halaman) {
echo "<a href=http://elearning.unmuhjember.ac.id/dosen_ti/?all=new?&halaman=$i>$i</a>,";
} else {
echo "<b>$i</b>,";
}
mysql_close();

?>


</center>
<br>
NB: Dimohon untuk edit profile melengkapi biodata.
<?
$row2=mysql_fetch_array (mysql_query("SELECT count(*) as ini FROM `data` ORDER BY `data`.`date` DESC"));
?>

<!-- <?=$row2['ini']?>
<! yg ini href=/user/view.php?id=<?=$row['id']?>--------bwt profile>

Belajar select join sukses di elearning Rating: 4.5 Diposkan Oleh: Catatanku