long string on mutiple lines?

[Anon]

$update = "UPDATE info SET fname = '$fName', lname = '$lName', team = '$Team' WHERE pno = '$Pid'";

how can I put that on mutiple lines so it doesnt strech all over in my php file? (I actually have about 10 more things to add to it so I wanted to make it look "cleaner" in my code.

with VBSCRIPT and ASP you just put _ at the end ...but I tried that with PHP and it didn't work.

[Anon]

It may be because I'm using PostgreSQL to try this out, or PHP4.0.5 (I can't remember when strings became able to do this) but I got success just using ordinary line breaks!

$update = "UPDATE info SET
fname = '$fName',
lname = '$lName',
team = '$Team'
WHERE pno = '$Pid'";

Heredoc notation might also work:

$update = <<< EOQ
UPDATE info SET
fname = '$fName',
lname = '$lName',
team = '$Team'
WHERE pno = '$Pid'
EOQ;

If that doesn't work for you for whichever reason, perhaps the alternative would be a pile of string concatenations:

$update = "UPDATE info SET";
$update .= "fname = '$fName',";
$update .= "lname = '$lName',";
$update .= "team = '$Team'";
$update .= "WHERE pno = '$Pid'";";

Yuck.

[Anon]

Dont know why it worked now..I swear I tried it before.

anyway it worked thanks.