Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Lars Wichmann
Added: Feb 9, 2021 1:04 PM
Views: 2
  1. //Example 1, gets the SECOND LAST VALUE AND NOT the LAST. IF there are deleted ROWS BETWEEN the ids they will note it AND make it RIGHT!
  2. //FOR example LAST id IS 1700 AND secand LAST IS 1643 there are deleted ROWS AND Max-1 IS would WORK correct them
  3. IF(empty($results33)){
  4.         $querry33 = 'SELECT id AS LastAfterCurrent, wassertemp, zeitTemp FROM riverwassertemp order by LastAfterCurrent DESC LIMIT 1,1';
  5.      $results33 = $wpdb->get_results($querry33);
  6. }
  7.  
  8.  
  9.