Simple if/else

I'm trying to check the DB for a name and return the error if its not found


if(!$checkname) {
$row1 = "$player not found";
}
else {
$row1 = "Name: $data->playername Rank: $data->rank Score: $data->totalscore MVP: $data->mvp Rank Points: $data->rankpoints";
$row2 = "Kills: $data->totalkills Deaths: $data->totaldeaths Games: $data->games GDI: $data->gdi Nod: $data->nod";
}
}

when the name is found its fine, but when no name is found it does not show the error message

Full code



<?php

include "config.php";


$FontFile="/home/xxx/www/stats_sig/arial.ttf";

$player = "$_GET[player]";
$imgurl = "$_GET[imgurl]";
$colour = "$_GET[colour]";

if ($image == gdi) $ImageURL="images/gdi.png";
elseif ($image == nod) $ImageURL="images/nod.png";
elseif ($image == users) $ImageURL="".$imgurl."";
else $ImageURL="images/default.png";

$checkname = mysql_query("SELECT * FROM ranks where playername = '".$player."'");
while($data = mysql_fetch_object($checkname)) {

if(!$checkname) {
$row1 = "$player not found";
}
else {
$row1 = "Name: $data->playername Rank: $data->rank Score: $data->totalscore MVP: $data->mvp Rank Points: $data->rankpoints";
$row2 = "Kills: $data->totalkills Deaths: $data->totaldeaths Games: $data->games GDI: $data->gdi Nod: $data->nod";
}
}

$TextX=5;
$TextY=5;
$size = ImageTTFBbox (15, 0, $FontFile, "meh");
$im_x=abs($size[4]-$size[0]);
$im_y=abs($size[5]-$size[1]);

if (substr($ImageURL,strlen($ImageURL)-3,3)=="png") {
Header("Content-type: image/png");
Header("Expires: " . gmdate("D, d M Y H:i:s", time() + 900) . " GMT");

$im_size = GetImageSize ($ImageURL);
$imageWidth = $im_size[0];
$imageHeight = $im_size[1];

$im = ImageCreateFromPNG($ImageURL);

if ($colour == white) $text_color = imagecolorclosest ($im, 255, 255, 255);
elseif ($colour == black) $text_color = imagecolorclosest ($im, 0, 0, 0);
else $text_color = imagecolorclosest ($im, 255, 255, 255);


if ($TextX+$im_x>$imageWidth){$TextX=$imageWidth-$im_x-2;}
if ($TextY>$imageHeight){$TextY=$imageHeight-2;}
if($row1)imagettftext ($im, 10, 0, $TextX+10, $TextY+24, $text_color, $FontFile, $row1);
if($row2)imagettftext ($im, 10, 0, $TextX+10, $TextY+47, $text_color, $FontFile, $row2);

Imagepng ($im);
ImageDestroy ($im);
}

?>

How about using:

$checkname='';
$checkname = mysql_query("SELECT * FROM ranks where playername = '".$player."'");


Then:

if($checkname =='')

D.

I already tried that way with no luck :/

What about mysql_num_rows. If num_rows is 0 then player does not exist. otherwise get player data?

$checkname = mysql_query("SELECT * FROM ranks where playername = '".$player."'");
while($data = mysql_fetch_object($checkname)) {

$row1 = "$player not found";
$row2 = "";
if(strlen($checkname)>0) {
$row1 = "Name: $data->playername Rank: $data->rank Score: $data->totalscore MVP: $data->mvp Rank Points: $data->rankpoints";
$row2 = "Kills: $data->totalkills Deaths: $data->totaldeaths Games: $data->games GDI: $data->gdi Nod: $data->nod";
}

}




.