Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(isset($_POST['listAlle'])){
- $tilkobling = KobleTil("hibualumni");
- $say =("select sId,sEpost,sFornavn,sEtternavn,sPassord,sProfilBilde,sAarskull,bType,cNavn,fNavn
- from tblstudent,tblbrukertype,tblcampus,tblfagomrade
- where tblstudent.sbId = tblbrukertype.bId
- and tblbrukertype.bId = tblfagomrade.fId
- and tblfagomrade.fId = tblcampus.cId");
- $ress = mysql_query($say,$tilkobling);
- while($r = mysql_fetch_assoc($ress)){
- $id = $rad['sId'];
- $epost =$rad['sEpost'];
- $fnavn =$rad['sFornavn'];
- $enavn =$rad['sEtternavn'];
- $Aarskull = $rad['sAarskull'];
- $brukertype=$rad['bType'];
- $cNavn=$rad['cNavn'];
- $fNavn=$rad['fNavn'];
- echo"<table>
- <tr>
- <td>ID</td>
- <td><td><td>Fnavn</td></td></td>
- <td>Enavn</td>
- <td><td><td><td>Epost</td></td></td></td>
- <td><td>Brukertype</td></td>
- <td><td><td>Årskull</td></td></td>
- <td><td><td><td>Campus</td></td></td></td>
- <td><td><td><td><td>Fagnavn</td></td></td></td></td>
- </tr>
- <tr>
- <td>{$r['sId']}</td>
- <td><td><td>{$r['sFornavn']}</td></td></td></td>
- <td> {$r['sEtternavn']}</td>
- <td><td><td><td>{$r['sEpost']}</td></td></td></td>
- <td><td>{$r['bType']}</td></td>
- <td><td><td>{$r['sAarskull']}</td></td></td>
- <td><td><td><td>{$r['cNavn']}</td></td></td></td>
- <td><td><td><td><td>{$r['fNavn']}</td></td></td></td></td>
- </tr>
- </table> ";
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement