
 artbuilders - 2007-11-01 04:00:47
 
When testing your example:
$values["Name"] = MySQL::SQLValue("Violet");
$values["Age"] = MySQL::SQLValue(777, MySQL::SQLVALUE_NUMBER);
echo MySQL::BuildSQLInsert("MyTable", $values);
It spawns the results: 
"INSERT INTO `MyTable` (`Name`, `Age`) VALUES ('Violet' AS "Name", 777 AS "Age")" instead of "...VALUES ('Violet',777)" The former fails to insert into MySQL db
Check out the MySQL Class, specifically in the "BuildSQLInsert" function. 
Shouldn't the line "$values  = self::BuildSQLColumns($valuesArray, false)" instead read "$values  = self::BuildSQLColumns($valuesArray, false, false);"? - added second "false"