php - Mysql query : date_format and sprintf() -

i want use sprintf() along date_format in mysql query.

here query:

mysql_select_db($database_exdb, $expdb); $query_eventeditrs = sprintf("select eventid, groupid, title, date_format(dateofevent, '%w, %m %d, %y'), timeofevent, location, details, presenter, bio events eventid = %s", getsqlvaluestring($colname_eventeditrs, "int"));  

i getting error :

“warning: sprintf() [fun ction.sprintf]: few arguments. query empty”  

plz

you have escape date format string %'s, try this:

sprintf("select eventid, groupid, title,  date_format(dateofevent, '%%w, %%m %%d, %%y'),  ti meofevent, location, details, presenter, bio  events  eventid = %s", getsqlvaluestring($colname_eventeditrs, "int"));