Registering data into a database error

Question

Ive got this error when running this script:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/gouda-info.nl/www/admin/artiekeltoevoegen.php on line 15
Error

I dont know why its doing this, I dont see any errors in the script I also tried rewriting but that didnt help too.

Script:

<?php  
if(!empty($_POST['titel']) && !empty($_POST['body']) && !empty($_POST['door']) && !empty($_POST['bron']) && !empty($_POST['samenvatting']) && !empty($_POST['naamimg']))  
{  
    $titel = mysql_real_escape_string($_POST['titel']);   
    $body = mysql_real_escape_string($_POST['body']);  
    $door = mysql_real_escape_string($_POST['door']); 
    $bron = mysql_real_escape_string($_POST['bron']); 
    $samenvatting = mysql_real_escape_string($_POST['samenvatting']); 
    $naamimg = mysql_real_escape_string($_POST['naamimg']); 



     $checkusername = mysql_query("SELECT * FROM nieuws WHERE Titel = '".$titel."'");  

     if(mysql_num_rows($checkusername) == 1)  
     {  
     ?>
            Dit artiekel bestaat al

    <?php
     }  
     else  
     {  
        $registerquery = mysql_query("INSERT INTO nieuws (Titel, Body, Door, Bron, Samenvatting, Naamimg) VALUES('".$titel."', '".$body."', '".$door."', '".$bron."', '".$samenvatting."', '".$naamimg."')");  
        if($registerquery)  
        {  
        ?>

    Artiekel successvol toegevoegd

        <?php
        }  
        else  
        {  
        ?>
            Error

        <?php           
        }         
     }  
}  
else  
{  
    ?>  

    <form action="" method="POST">
<input type="text" name="titel" placeholder="Titel"><p>
<textarea name="body" placeholder="Tekst"></textarea><p>
<input type="text" name="door" placeholder="Geschreven door"><p>
<input type="text" name="bron" placeholder="Eventuele bronnen"><p>
<input type="text" name="samenvatting" placeholder="Korte Sammenvatting"><p>
<input type="text" name="naamimg" placeholder="Naam plaatje"><p>
<input type="submit">
</form>

<?php  
}  
?>

I hope you guys come up with a solution, otherwise this script is rubbish and ready for the trashcan.

cheers

EDIT

Fixed, thank you guys. When I added the die function it worked!

try `mysql_query(....) or die(mysql_error());` what it says ? — M Khalid Junaid, Jan 04 '14 at 11:47

score 1 · Accepted Answer · answered Jan 04 '14 at 11:49

Your error message says it all:

mysql_num_rows() expects parameter 1 to be resource, boolean given in

Probably your $checkusername results in a false -> your query results in an error. Try debugging your query be adding

mysql_query(....) or die(mysql_error());

That will produce some information why your query fails.

Registering data into a database error

1 Answers1