[Openfirst-cvscommit] logger index.php,1.11,1.12 rawdata.php,1.11,1.12
Brought to you by:
xtimg
From: Tim G. <xt...@us...> - 2004-04-07 11:59:26
|
Update of /cvsroot/openfirst/logger In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv6673 Modified Files: index.php rawdata.php Log Message: Change database query to reflect ANSI standard (ref: http://dotgeek.org/guruarticles.php?guru=view&id=27) Index: rawdata.php =================================================================== RCS file: /cvsroot/openfirst/logger/rawdata.php,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** rawdata.php 24 Dec 2003 19:32:20 -0000 1.11 --- rawdata.php 7 Apr 2004 11:46:22 -0000 1.12 *************** *** 47,51 **** } ! $query = ofirst_dbquery("SELECT * FROM ofirst_logger LIMIT $min,$max"); $amount = ofirst_dbnum_rows($query); --- 47,51 ---- } ! $query = ofirst_dbquery("SELECT * FROM ofirst_logger LIMIT $min OFFSET $max"); $amount = ofirst_dbnum_rows($query); Index: index.php =================================================================== RCS file: /cvsroot/openfirst/logger/index.php,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** index.php 24 Dec 2003 19:32:20 -0000 1.11 --- index.php 7 Apr 2004 11:46:21 -0000 1.12 *************** *** 47,51 **** } ! $query = ofirst_dbquery("SELECT * FROM ofirst_logger GROUP BY `IPAddress` ORDER BY `ID` DESC LIMIT $min,$max"); $amount = ofirst_dbnum_rows($query); --- 47,51 ---- } ! $query = ofirst_dbquery("SELECT * FROM ofirst_logger GROUP BY `IPAddress` ORDER BY `ID` DESC LIMIT $min OFFSET $max"); $amount = ofirst_dbnum_rows($query); |