concatenation: Php and SQL

Concatenating php vars that hold sql statements

[ryanoasis]

I want to shorten my sql statements (i have many that do similar things)

$strSQL = "tblsrstudent.strSIN, tblsremail.strEmail, tblsrphone.strAC,
tblsrphone.strPrefix, tblsrphone.strSuffix
FROM tblsrstudent
LEFT OUTER JOIN tblsrphone
ON tblsrstudent.lngStudentPK = tblsrphone.lngStudentFK
AND tblsrphone.lngValue = 1
LEFT OUTER JOIN tblsremail
ON tblsrstudent.lngStudentPK = tblsremail.lngStudentFK
AND tblsremail.lngValue % 2 = 1";

$strSQLLastName = " WHERE $strLastName LIKE '%$txtLastName%'";
$strSQL.=$strSQLLastName;

any help would be cool, thanks

I've also tried:
$strSQLLastName = " WHERE ".$strLastName." LIKE '%".$txtLastName."%'";

[jatar_k]

any particular reason why you want to make them shorter?

[ryanoasis]

Just for cleaner, easier to read code and maybe a bit more efficient.