TalkPHP - View Single Post

maZtah · 03-18-2008, 11:56 AM

How would you do this with sprintf:

PHP Code:


			
$szQuery = sprintf("SELECT DATE_FORMAT(postDate, '%d/%m/%Y') AS postDate FROM table WHERE id = %d", $iId);

This gives an error because of the %d from the DATE_FORMAT.

03-18-2008, 11:56 AM	#25 (permalink)
maZtah The Acquainted Join Date: Oct 2007 Posts: 172 Thanks: 18	How would you do this with `sprintf`: PHP Code: `$szQuery = sprintf("SELECT DATE_FORMAT(postDate, '%d/%m/%Y') AS postDate FROM table WHERE id = %d", $iId);` This gives an error because of the `%d` from the `DATE_FORMAT`.