Problem with seemingly simple query - Help please

[frank5050]

I have a database table with a column 'phonecarriers' that has some network names stored in it such as,

phonecarriers
AT&T
Tmobile
Verizon

Some values in the column 'phonecarriers' have ampersand (&) such as AT&T while others don't (TMobile or Verizon)


When I query the database with the follwing query:

$sql="SELECT * FROM table WHERE phone= '$model' and phonecarriers = '$network' ";



I get correct results if $network variable is either TMobile or Verizon.

I do not get results if $network variable is AT&T.

I also get correct results if instead of '$network' , I plug and type network = 'AT&T' directly in the query.


What can I do differently, or how can I write the query so that that when the '$network' variable is AT&T that the query would fetch results from the table where phonecarriers is AT&T.


Any help would be appreciated,
Thanks

[sunfighter]

How are you defining $network? I don't think the problem is in using an ampersand, because you obtain results with network = 'AT&T'.