title: too few arguments sprintf
body: <p>I have done this many times before, to re-use a value passed into the sprintf() function.  But this code is returning a "Warning: sprintf() [function.sprintf]: Too few arguments in..." message.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>$search_clause = sprintf(" (msgBody LIKE %%%1$s%% OR msgSubject LIKE '%%%1$s%%' ) ", mysql_real_escape_string($match1));
  </code></pre>
  
  <p>Ideally the value of $match1 will be inserted into the segment of the SQL WHERE clause shown above - twice, each wrapped by '%' characters for a wildcard search. </p>
  
  <p>If $match1 = "test", the resulting string value of $search_clause would be:</p>
  
  <pre><code>(msgBody LIKE '%test' OR msgSubject LIKE '%test%' )
  </code></pre>
  
  <p>What is the obvious mistake I'm making??</p>