TalkPHP - View Single Post

Wildhoney · 05-31-2009, 09:12 PM

As a simple example you are able to concatenate the string using the following operator .=

php Code:

$szSQL = "SELECT * FROM members WHERE ";
$szSQL .= sprintf("name = '%s' ", 'Wildhoney');
$szSQL .= sprintf("AND dob = '%d-%d-%d'", 10, 10, 1985);
echo $szSQL;

05-31-2009, 09:12 PM	#4 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	As a simple example you are able to concatenate the string using the following operator `.=` php Code: $szSQL = "SELECT * FROM members WHERE "; $szSQL .= sprintf("name = '%s' ", 'Wildhoney'); $szSQL .= sprintf("AND dob = '%d-%d-%d'", 10, 10, 1985); echo $szSQL; __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.