title: UPDATE mysql_query not updating table
body: <p>Im having trouble with the UPDATE command.</p>
  
  <p>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.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>$a = mysql_query("UPDATE `findacab` SET `lat` = ".$ads['Latitude']." , `long` = ".$ads['Longitude']."
                  WHERE `eeventendtime` = ".$ads['Postcode']."  ");
  </code></pre>
  
  <p>Table:</p>
  
  <pre><code>$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']."&lt;/br&gt;";
       //$query = "select count(*) from findacab where eeventendtime = '".mysql_real_escape_string($ads['Postcode'])."'"; 
  }
  </code></pre>