Advertisement
Guest User

Untitled

a guest
Jul 29th, 2014
190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. $sql = 'SELECT blahblah, bla FROM databasename WHERE lat >= ? AND lat <= ? AND lon >= ? AND lon <= ?';
  2. $params = array( $minlat, $maxlat, $minlon, $maxlon );
  3. if ( isset( $_GET['sear'] ) ) {
  4. $sql .= "AND (searcher LIKE ?)";
  5.  
  6. $params[] = '%'.$_GET['sear'].'%';
  7.  
  8. }
  9.  
  10. $sql = 'SELECT blahblah, bla FROM databasename WHERE lat >= ? AND lat <= ? AND lon >= ? AND lon <= ? ORDER BY autoinc DESC LIMIT 30';
  11. $params = array( $minlat, $maxlat, $minlon, $maxlon );
  12. if ( isset( $_GET['sear'] ) ) {
  13. $sql .= "AND searcher LIKE ? ";
  14.  
  15. $params[] = '%'.$_GET['sear'].'%';
  16.  
  17.  
  18. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement