Moved all SQL statements from PHP files into relevant *_db.inc files.

[fa-stable.git] / gl / includes / db / gl_db_rates.inc

diff --git a/gl/includes/db/gl_db_rates.inc b/gl/includes/db/gl_db_rates.inc
index c6d5c530bc159e331bb30bc2d142fee2f00e5e6e..02a782296ae03e54b976049cf30f02659f8f7ac5 100644 (file)
--- a/gl/includes/db/gl_db_rates.inc
+++ b/gl/includes/db/gl_db_rates.inc
@@ -146,4 +146,14 @@ function get_ecb_rate($curr_b)
        return $val;
 }  // end function get_ecb_rate
 
+//-----------------------------------------------------------------------------
+
+function get_sql_for_exchange_rates()
+{
+       $sql = "SELECT date_, rate_buy, id FROM "
+               .TB_PREF."exchange_rates "
+               ."WHERE curr_code=".db_escape($_POST['curr_abrev'])."
+                ORDER BY date_ DESC";
+       return $sql;     
+}
 ?>
\ No newline at end of file