Need help with £ displaying as ?

Discussion in 'PHP' started by syted, Mar 20, 2007.

  1. #1
    Hi, I've had a php script installed on LinkLister directory which provides the rss feed to bbc.co.uk news. I know nothing about php and apart from the problem above I'd like the links, when clicked, to open in a new window/tab rather than in the same window as they do now. Can anybody help me with this?
     
    syted, Mar 20, 2007 IP
  2. m0nkeymafia

    m0nkeymafia Well-Known Member

    Messages:
    399
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    125
    #2
    It is a problem with the language / local your mysql database is set to. So it interprets £'s as ?'s.

    Look at it and change it
     
    m0nkeymafia, Mar 20, 2007 IP
  3. syted

    syted Notable Member

    Messages:
    2,086
    Likes Received:
    319
    Best Answers:
    0
    Trophy Points:
    290
    #3
    Thanks for your reply, I've looked and googled but can't see how to do this? I'll happily pay somebody to fix this for me.
     
    syted, Mar 21, 2007 IP
  4. krakjoe

    krakjoe Well-Known Member

    Messages:
    1,795
    Likes Received:
    141
    Best Answers:
    0
    Trophy Points:
    135
    #4
    take some screenshots of phpmyadmin so we can have a look .... want the screen you get just after you select a database NOT after you select a table in the database .....
     
    krakjoe, Mar 21, 2007 IP
  5. syted

    syted Notable Member

    Messages:
    2,086
    Likes Received:
    319
    Best Answers:
    0
    Trophy Points:
    290
    #5
    OK here you go...
     

    Attached Files:

    syted, Mar 21, 2007 IP
  6. m0nkeymafia

    m0nkeymafia Well-Known Member

    Messages:
    399
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    125
    #6
    I have a similar problem on my DB and haven't been arsed to fix it

    Try change the collation on one of the tables to ascii something [i forget which one] or maybe unicode, experiment
    Everytime you add one add a fresh entry to the db to check it

    One will work, I unfortunately dont know which, so try UNICODE first then ASCII.
     
    m0nkeymafia, Mar 31, 2007 IP
  7. metallic07039

    metallic07039 Peon

    Messages:
    272
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Maybe I am the only one but do you want the links to open in a new window or is your question about the character problems?

    To open in a new window: Edit your HTML links to look like this: <a href="LINK" target="_new">TEXT</a>
     
    metallic07039, Apr 1, 2007 IP