% sign as charector with sprintf

Anon

What I am trying to do is get sprintf to see % as a charector and not look for more input.

Here is the code that is problematic

$dynamicquery=($dynamicquery . " AND M.title LIKE '%%s%' ");
$dynamicquery=sprintf($dynamicquery, $title);

I have also tried to get it to work as follows
LIKE '%s' ");
$title = '%' . $title . '%';

Now eventually this is going into a postgres
sql Query with a Like statement with wildcards before and after a user inputed text.The query works fine at the psql prompt but I cannot get sprintf to accept this or figure out how to get sprint to just print out the needed percent signs.

Thanks in Advance.

Anon

%% in the format string gives you a literal % in the output.

Anon

This did not work
I attempted to use this code
'%%s%%%'

since I need sprintf to print out.
since sprintf is going to into a variable

WHERE SOMETHING='%something%' AND... AND... AND....

It keeps given me an error message
Any other suggestions?

Anon

Just try counting/sequencing things correctly. sprintf() reads from left to right, resulting in the following interpretation of '%%s%%%':

<ul>
<li>a literal percent-sign
<li>an 's' character (since it's no longer preceded by a %, it's no longer a format specifier)
<li>another literal percent-sign
<li>a single percent-sign (which is an error since it's at end-of-string)
</ul>

What you probably meant here was:

'%%%s%%'

providing a literal percent, a string-format specifier, and another literal percent.