use DBI;
$dbh = connect(.........);
$dbh->prepare('INSERT INTO weathercache (latitude, longitude, weather, cached) VALUES (?, ?, ?, NOW())')->execute(50.530998, -4.949000, '');

##</code><code>##

$sth = $dbh->prepare('SELECT * FROM weathercache WHERE latitude = 50.530998 AND longitude = -4.949000')->execute();

##</code><code>##

$sth = $dbh->prepare('SELECT * FROM weathercache WHERE latitude = ? AND longitude = ?')->execute(50.530998, -4.949000);