PHP/MySQL problem

Discussion in 'PHP' started by gilbertsavier, Aug 17, 2009.

  1. #1
    Hi

    I have just had a site transferred to me that has [Removed false authorship of website: this is a joke I assume, no such authorship exists in the real world, techAdmin] - and I cannot, for the life of me, understand why it will not properly connect to the MySQL database.
    I have done many before - so it is not likely to be a just basic error.

    When selecting on the search button bottom left I end up with the following message:

    "Error en la Base de Datos al ejecutar
    select * from fichas where
    tipo=''
    and precio>= and precio<= and terretam <= and casatam <= order by puntos descYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and precio<= and terretam <= and casatam <= order by puntos desc' at line 3"


    The site is [link] - my server "experts" have tried everything and confess to being "flumoxxed !!

    Bizarrely - the images that have downloaded (and there are a number genuinely missing) - show in Opera and Firefox - but not in IE !!

    Can anyone help or advise me? I can provide all FTP details etc.

    ------------------------
    Thanks & regards
    Lokananth
    <a href="http://www.mioot.com" >Live Chat Software</a>
     
    gilbertsavier, Aug 17, 2009 IP
  2. pixie_hollow

    pixie_hollow Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    It seems like it is connecting to the DB but the SQL statement is incorrect

    tipo='' -> tipo = what??? (value of tipo is missing)
     
    pixie_hollow, Aug 17, 2009 IP
  3. premiumscripts

    premiumscripts Peon

    Messages:
    1,062
    Likes Received:
    48
    Best Answers:
    0
    Trophy Points:
    0
    #3
    premiumscripts, Aug 17, 2009 IP