更新mysql_query不更新表

Im having trouble with the UPDATE command.

Im trying to update my db but its just not happening. Ive been trying to get this to work for the last 10 days and its driving me nuts.

Here is the code:

$a = mysql_query("UPDATE `findacab` SET `lat` = ".$ads['Latitude']." , `long` = ".$ads['Longitude']."
                WHERE `eeventendtime` = ".$ads['Postcode']."  ");

Table:

$q = mysql_query("SELECT Postcode, Latitude, Longitude FROM postcodes");
while($ads = mysql_fetch_array($q)) 
{ 
    mysql_query("UPDATE findacab SET lat = '".$ads['Latitude']."' , long = '".$ads['Longitude']."' WHERE eeventendtime = '".$ads['Postcode']."' ");
    echo $ads['Latitude']." ".$ads['Longitude']." ".$ads['Postcode']."</br>";
     //$query = "select count(*) from findacab where eeventendtime = '".mysql_real_escape_string($ads['Postcode'])."'"; 
}

Unless your complete table consists of only integer you should add quotations around your strings

$a = mysql_query("UPDATE `findacab` SET 
    `lat` = '".$ads['Latitude']."' , 
    `long` = '".$ads['Longitude']."' 
    WHERE 
    `eeventendtime` = '".$ads['Postcode']."' ");

$query = "select count(*) from findacab where eeventendtime = '".mysql_real_escape_string($ads['Postcode'])."'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
echo $row[0]

If it returns 0 then you just don't have records to update. Another possible reason - you are trying to update table with same values as stored. In this case update will not change the data.