<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$koneksi = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $koneksi )
{
  die('Gagal Koneksi: ' . mysql_error());
}
if(isset($_GET['id'])) {
	$id = $_GET['id'];

	$sql = "SELECT id_iklan, judul, pend, bid, wil, isi FROM lowongan WHERE id_iklan=$id"; // comment Zulficar -- yg ini diganti jadi "SELECT * FROM pencari_kerja WHERE bayar != '0'" (kalo yg dipilih semua fieldnya pake tanda bintang *). Ini artinya yg ditampilin di tabel cuma yg udah bayar

mysql_select_db('loker');
$ambildata = mysql_query( $sql, $koneksi);
if(! $ambildata )
{
  die('Gagal ambil data: ' . mysql_error());
} ?>


<?php
while($row = mysql_fetch_array($ambildata, MYSQL_ASSOC))
{
     echo "<tr>";
   echo "<td>".$row['id_iklan']."</td>";
   echo "<td>".$row['judul']."</td>";
   echo "<td>".$row['pend']."</td>";
   echo "<td>".$row['bid']."</td>";
   echo "<td>".$row['jur']."</td>";
   echo "<td>".$row['isi']."</td>";
  }}

?>
</table>