Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Feb 2011
    Posts
    32
    Thanks
    3
    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,

    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
    Last edited by frank5050; 12-10-2012 at 04:43 AM.

  • #2
    Senior Coder
    Join Date
    Jan 2011
    Location
    Missouri
    Posts
    4,713
    Thanks
    25
    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'.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •