Problem with seemingly simple query - Help please
I have a database table with a column 'phonecarriers' that has some network names stored in it such as,
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,