Select Code to Download

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

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

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