note 63095 deleted from function.mysql-real-escape-string by danbrown

Note Submitter: keith dot lawrence at jpmh dot co dot uk ---- Here's my version, this replaces empty strings with NULLs instead of using a quoted empty string which was causing a sql error when adding empty values to an integer column which allows nulls. Your mileage may vary. <?php function quote_smart($value) { if (get_magic_quotes_gpc()) $value = stripslashes($value); if($value == '') $value = 'NULL'; else if (!is_numeric($value) || $value[0] == '0') $value = "'" . mysql_real_escape_string($value) . "'"; //Quote if not integer return $value; } ?>