Re: [PHP] Help with '&' character

[Chris Bruce]

The problem is that the '&' character is already in a database. I am 
trying to do a query where I need to have it as '&', but like I said, 
when it comes into the script from the url it gets truncated.

--

Chris Bruce
[EMAIL PROTECTED]
Idextrus
E-Business Architects
http://www.idextrus.com
3282 Wilmar Cres.
Mississauga, ON
L5L4B2
CA
905.828.9189
****************************************************************
This e-mail and its contents are privileged, confidential and
subject to copyright.  If you are not the intended recipient,
please delete this e-mail immediately.  Any unauthorized use
or disclosure of the information herein is prohibited.
On Feb 17, 2004, at 12:40 PM, Miguel J. Jiménez wrote:

Have you tried using '&' ?

Chris Bruce wrote:

I am having trouble with a string becoming truncated at an '&' 
character. I am passing the variable via a link

(http://...&campaign=MBI%20List%20-%20Steel%20&%20Concrete) and then 
when I try to grab the incoming value of campaign into a SELECT 
query, it becomes

SELECT sum(sends) from campaigns where name='MBI List - Steel '

I have tried to urlencode the variable, and also use htmlentities, 
etc. to no avail.

Does anyone have a solution for this?

Thanks.
<mjjimenez.vcf>