Changeset 37
- Timestamp:
- Oct 15, 2006, 8:56:31 AM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/npemap.org.uk/cgi/submit.fcgi
r28 r37 77 77 # We are guaranteed to have the first two 78 78 $outward = $first . $second; 79 $inward = $third if $third; 79 $inward = ''; 80 $inward .= $third if $third; 80 81 $inward .= $fourth if $fourth; 81 82 } else { … … 88 89 # corroboration factor; this just catches accidental double-submission 89 90 # really. 90 $sth = $dbh->prepare('SELECT *FROM postcodes WHERE raw_postcode = ? AND easting = ? AND northing = ? AND ip = ?');91 $sth = $dbh->prepare('SELECT raw_postcode FROM postcodes WHERE raw_postcode = ? AND easting = ? AND northing = ? AND ip = ?'); 91 92 unless ($sth->execute($raw_postcode, $easting, $northing, $ENV{'REMOTE_ADDR'})) { 92 93 print_err('Database error when checking for duplicate data :(');
Note: See TracChangeset
for help on using the changeset viewer.