X-Git-Url: http://andersk.mit.edu/gitweb/sql-web.git/blobdiff_plain/4cae200cb65ec7c7b9f7c3c7ad8f2266668cf46e..35d6bcaee2327c5c7bf5519044ba88f9cffb6a82:/lib/joe/util.lib.php

diff --git a/lib/joe/util.lib.php b/lib/joe/util.lib.php
index 1ce55cc..3cabb1e 100644
--- a/lib/joe/util.lib.php
+++ b/lib/joe/util.lib.php
@@ -125,7 +125,7 @@ function buildSQLSet($fields, $values=null, $safeFields=false) {
         foreach($fields as $field) {
             if ($c++) $sql .= ',';
 			$value = array_shift($values);
-			if (is_numeric($value))
+			if ((string)intval($value)===(string)$value)
 				$sql .= " `$field`=".mysql_real_escape_string($value);
 			else
 				$sql .= " `$field`='".mysql_real_escape_string($value)."'";
@@ -135,7 +135,7 @@ function buildSQLSet($fields, $values=null, $safeFields=false) {
             if ($c++) $sql .= ',';
             if (in_array($value,$ex) || (is_array($safeFields) && in_array($field,$safeFields))) {
                 $sql .= " `$field`=$value";
-            } elseif (is_numeric($value)) {
+            } elseif ((string)intval($value)===(string)$value) {
                 $sql .= " `$field`=".mysql_real_escape_string($value);
 			} else {
                 $sql .= " `$field`='".mysql_real_escape_string($value)."'";
@@ -161,7 +161,7 @@ function buildSQLInsert($array, $table=null, $safeFields=false) {
             $sql .= " $value ";
 		} else {
         	$value = mysql_real_escape_string($value);
-			if (is_numeric($value)) {
+			if ((string)intval($value)===(string)$value) {
 				$sql .= " $value ";
 			} else {
 				$sql .= " '$value' ";