But then you here is one code for case sensitive
foreach (array as key => $value) {
if (key == 'uid' || key == 'status') {
$query[] = "key = %d";
params[] = value;
}
else if (key == 'pass') {
query[] = "pass = '%s'";
params[] = md5(value);
}
else {
query[]= "LOWER($key) = LOWER('%s')";
params[] = value;
}
}
well i am also not sure with this code but yes with the help of if else you can get what you want...:rose::thumbsup: