Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
12-10-2012, 04:40 AM #1
- Join Date
- Feb 2011
- Thanked 0 Times in 0 Posts
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,
Last edited by frank5050; 12-10-2012 at 04:43 AM.
12-10-2012, 05:29 AM #2
- Join Date
- Jan 2011
- Thanked 660 Times in 659 Posts
How are you defining $network? I don't think the problem is in using an ampersand, because you obtain results with network = 'AT&T'.