Check if row exists

[SkyRanger]

I am having problem with checking if a row exists with no errors being displayed:

 

$queryged = "SELECT * FROM `gedcom` WHERE `client`='$loggedin' limit 1";
$resultged = $mysqli->query($queryged) or die($mysqli->error.__LINE__);

while($rowged = $resultged->fetch_assoc()){

if ($rowged['client'] == 0 ) {
            echo "No";
} else {
            echo "<a href=\"client/".$loggedin."/personal/".$rowged['ged']."\">YES</a>  Updated: ".$rowget['gedup']."";
        }    } 	

 

 

[AyKay47]

Since you are returning only 1 row, you do not need a while loop.

A good debugging habit to get into is to also output the SQL statement and check for errors there.

What output is being displayed?

Edited March 2, 2013 by AyKay47

[SkyRanger]

Thanks for catching that AyKay47.  Never even realized I left the  while loop in there which caused the error.  Removed it and it works fine.  Thank you.