help me please..

[dina85]

require("conn.php");
$sql = "select * from pemohon where kp_baru='$kp';";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
    if($row == TRUE)
    {
     echo $row['kp_baru']; // can display
    }
    else
    {
        echo "No KP tiada didalam pangkalan data."; // can't display
    }
}

[RoryGren]

What is your question?

[dina85]

line 12 can't display at the browser...

[TonyG_cyprus]

$sql = "select * from pemohon where kp_baru='$kp';";
the first semi-colon (;) is un-neccessary.
Try

if($row['kp_baru']=='')
{
 echo "No KP tiada didalam pangkalan data."; 
}
else
{
    echo $row['kp_baru']; 
}

instead.

[RoryGren]

I'm not certain, but I think your $row will always be true. It contains an array with the result set from your query.
You need to select a value in each row of your query to check.
Another tip - try and avoid SELECT * FROM ... Rather select specific fields. That way there's less data being retrieved from the database and the query will run faster.

SELECT field1, field2, field3, `kp_baru` FROM pemohon where kp_baru='$kp';
...
while($row = mysql_fetch_array($result)) 
{
    if (field2 == requiredvalue) 
    {
         echo $row['kp_baru'];
    }
    else
    {
        echo "No KP tiada didalam pangkalan data.";
    }
}

I hope this helps... :-)

[dina85]

still give blank page

[minitauros]

Then have you checked if there is something wrong with conn.php? Also make sure your error reporting is turned on. In the first line of your root script, put this line to do that:

error_reporting(E_ALL ^ E_NOTICE);

[dina85]

conn.php is right coz line 8 can display.

[minitauros]

Aaaah I think I understand what the problem is now. I thought nothing was displaying at all :). Try this if you will:

require("conn.php");
$sql = "select * from pemohon where kp_baru='$kp';";
$result = mysql_query($sql);

$has_results = false; // To be validated below.

while($row = mysql_fetch_array($result))
{
    // If the loop can be executed at least once, it means that results have been found.
    $has_results = true;

    // Display the row.
    echo $row['kp_baru'];
}

if(!$has_results)
{
    // The while loop has never been executed. No results were found.
    echo "No KP tiada didalam pangkalan data.";
}

[dina85]

yeah.. u are right... tq dear..