[RESOLVED] help - Undefined index

[fandhie]

hi
i'm just learning php
can you help me with the following errors :

Notice: Undefined index: halaman in C:\wamp\www\latihan\paging_1.php on line 14

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\latihan\paging_1.php on line 29

<?php 
mysql_connect("localhost","root","");
mysql_select_db("belajar");

$batas = 5;
$halaman = $_GET['halaman'];   <---- LIne 14
if(empty($halaman))
	{
	$posisi = 0;
	$halaman = 1;
	}
else
	{
	$posisi = ($halaman-1) * $batas;
	}

$tampil="SELECT * FROM LIMIT $posisi,$batas";
$hasil=mysql_query($tampil);

$no=1;
while ($data=mysql_fetch_array($hasil))   <--- LIne 29
	{
	echo "<tr><td>$no</td>
	      <td>$data[nama]</td>
		  <td>$data[alamat]</td></tr>";

$no++;
}
echo "</table>";

$tampil2 = mysql_query("select * from anggota");
$jmldata = mysql_num_rows($tampil2);
$jmlhalaman = ceil($jmldata/$batas);

echo "<br/>Halaman : ";

for($i=1;$i<=$jmlhalaman;$i++)
if ($i != $halaman)
	{
	echo " <a href=$_SERVER[PHP_SELF]?halaman=$i>$i</a> | ";
	}
else	
	{
	echo " <b>$i</b> | ";
	}
echo "<p>Total anggota : <b>$jmldata</b> orang</p>";
?>

[halojoy]

Is because
was no value halaman i URL

So we can test if $_GET['halaman'] is set ... or not

Line 14.
If isset then we take the value $GET['halaman']
else we let $halaman = 0

$halaman = isset($_GET['halaman']) ?   $_GET['halaman'] : 0;

You have no tablename here

$tampil="SELECT * FROM tablename LIMIT $posisi,$batas"; 

[fandhie]

thank u halojoy...

how about the error on line 29?

[bradgrafelman]

fandhie wrote:

how about the error on line 29?

As halojoy pointed out above, you forgot to include the tablename in your SQL query:

$tampil="SELECT * FROM LIMIT $posisi,$batas"; 

SELECT * FROM... where? 🙂

[fandhie]

hi brad..
I already put the table name like following

$tampil="SELECT * FROM belajar LIMIT $posisi,$batas";
$hasil=mysql_query($tampil);

$no=1;
while ($data=mysql_fetch_array($hasil))   <-- LIne 29
	{
	echo "<tr><td>$no</td>
	      <td>$data[nama]</td>
		  <td>$data[alamat]</td></tr>";

$no++;

but there are still the same error : Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\latihan\paging_1.php on line 29

[bradgrafelman]

What this error message means is that the parameter for mysql_fetch_array() ($hasil in this case) is a boolean (hence "boolean given") rather than a MySQL resource. This means that [man]mysql_query/man must have returned FALSE, which it will do when your SQL query has an error.

The way I normally debug SQL errors quickly would be to alter your code like so:

$tampil="SELECT * FROM belajar LIMIT $posisi,$batas"; 
$hasil=mysql_query($tampil) or die("SQL error: " . mysql_error() . "<br><br>Query: $tampil");

Change your code such that it looks like what I have above and let us know what the MySQL error message is as well as what your query looks like.

[fandhie]

thank u bradgrafelman...

i've already found the problem using your guide...

I was wrong using database name as table name 🙂