php - mysql查询: date_format and sprintf()

Question

我想在 MySQL 查询中使用 sprintf() 和 date_format。

这里是查询:

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 FROM events WHERE eventid = %s", GetSQLValueString($colname_eventeditrs, "int")); 

我得到的错误是:

“Warning: sprintf() [fun
ction.sprintf]: Too few arguments. Query was Empty” 

请帮忙

Answer 1

你必须用额外的 % 来转义日期格式字符串，试试这个:

sprintf("SELECT eventid, groupid, title, 
DATE_FORMAT(dateofevent, '%%W, %%M %%d, %%Y'), 
ti meofevent, location, details, presenter, bio 
FROM events 
WHERE eventid = %s", GetSQLValueString($colname_eventeditrs, "int"));