note 108145 added to function.mysql-query

@ ghighiaw at yahoo dot com A simple solution might be: write the query as a format string, and when it's time to query, replace the specifier bij the variable value using sprintf(). <?php $query = "SELECT emp_no FROM employees WHERE dpt_no = '%s'"; (....) $var = 'dpt_it'; $qstring = sprintf($query, $var); // $qstring will now be equivalent to: // SELECT emp_no FROM employees WHERE dpt_no = 'dpt_it'; mysql_query($qstring); ?> ---- Server IP: 91.199.167.223 Probable Submitter: 212.204.170.233 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-query.php Edit -- https://master.php.net/note/edit/108145 Del: integrated -- https://master.php.net/note/delete/108145/integrated Del: useless -- https://master.php.net/note/delete/108145/useless Del: bad code -- https://master.php.net/note/delete/108145/bad+code Del: spam -- https://master.php.net/note/delete/108145/spam Del: non-english -- https://master.php.net/note/delete/108145/non-english Del: in docs -- https://master.php.net/note/delete/108145/in+docs Del: other reasons-- https://master.php.net/note/delete/108145 Reject -- https://master.php.net/note/reject/108145 Search -- https://master.php.net/manage/user-notes.php