note 38487 deleted from function.mysql-query by nlopess

Note Submitter: red@icuii.com ---- <? function mysql_queryf() { function validate($a, $b) { if ($a == "s") return "'".mysql_escape_string($b)."'"; if ($a == "d") return (int)$b; if ($a == "f") return (float)$b; return "''"; } $args = func_get_args(); if (count($args) < 1) return; $i = 0; $fmt = array_shift($args); $query = preg_replace("/%(s|d|f)/e", 'validate("$1", $args[$i++])', $fmt, count($args)); return mysql_query($query); } ?> Here's my mysql_queryf Works kind of like printf mysql_queryf("select * from a where name=%s and age=%d", "mike", 24);