PHP/MYSQL

[akrytus]

I dont understand why, but everytime I do this querry with php it seems to find the record, although it doesnt exist.  If I do this querry through mysql at the dbase the record does not exist.  After I did the querry and it did not find the record, I had it produce the code and inserted it into my php and it doesnt looks as if it found it.  What am I doing wrong? Perhaps my if($result) is incorrect?

 

$sql='SELECT * FROM `Attendance` WHERE `Date` = \''.$HTTP_POST_VARS['Date'].'\' AND `First` LIKE CONVERT(_utf8 \''.$value[1].'\'USING latin1) COLLATE latin1_swedish_ci AND `Last` LIKE CONVERT(_utf8 \''.$value[2].'\' USING latin1) COLLATE latin1_swedish_ci';

$result = mysql_query($sql);      				
if($result){echo "$fullname on day ".$HTTP_POST_VARS['Date']." was Found<br>";}    
if(!$result){echo "$fullname was Not Found<br>"; /*