TalkPHP - View Single Post

Karl · 10-06-2007, 02:22 PM

Hey, you need to encapsulate the percentage signs within your string. Change this:

PHP Code:


			
$szSQL = sprintf("SELECT user,id,rank FROM users WHERE user LIKE '%s' ORDER BY id", %$szUsername%);

to this:

PHP Code:


			
$szSQL = sprintf("SELECT user,id,rank FROM users WHERE user LIKE '%s' ORDER BY id", "%$szUsername%");

10-06-2007, 02:22 PM	#20 (permalink)
Karl The Reckoner Join Date: Sep 2007 Posts: 437 Thanks: 22	Hey, you need to encapsulate the percentage signs within your string. Change this: PHP Code: `$szSQL = sprintf("SELECT user,id,rank FROM users WHERE user LIKE '%s' ORDER BY id", %$szUsername%);` to this: PHP Code: `$szSQL = sprintf("SELECT user,id,rank FROM users WHERE user LIKE '%s' ORDER BY id", "%$szUsername%");`