更新mysql_query不更新表

Question

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'])."'"; 
}

Answer 1

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']."' ");