Code: Select all
function mySQLmatch($col, $data, $mySQLtable) {
//DB connect
$link = $this->dbConnect();
//MySQL query
$query = sprintf("SELECT %1$s FROM %s WHERE %1$s = '%s'",
mysql_real_escape_string($col, $link),
mysql_real_escape_string($mySQLtable, $link),
mysql_real_escape_string($data, $link));
if(!$result = @mysql_query($query)) {
$this->errorMSG[] = "Query failed: " . mysql_error();
return false;
exit;
} else {
return mysql_num_rows($result);
}
}I need to use $col twice.
Error:
Warning: sprintf() [function.sprintf]: Too few arguments in C:\wamp\www\test\MySQL\mySQLConnect.php on line 181
Thanks