mysql problem

Discussion in 'MySQL' started by tdd1984, May 25, 2007.

0
  1. #1
    I'm having a problem with mysql my queries worked fine on my local host, but when I imported all my sql data into my web host server it inserted just fine, but there is a query that won't work on my web host server, but works just fine on my local host same data.

    I even re imported the data 3 times thinking something went wrong the mysql version sare different the one I'm having problems with is running version 4.0.27 standard, and I'm using 5.0

    here is my query
    SELECT Items.ItemID, Items.YR2, Items.Item_Name, Items.QCode, `Condition`.`Condition`, Items.Price, Items.Picture, Items.Dated, Items.Code, Year.YR FROM Items INNER JOIN Year ON Items.YR2 = Year.YR2 INNER JOIN `Condition` ON Items.MaterialID = `Condition`.Code INNER JOIN Series ON Items.SeriesID = Series.SeriesID INNER JOIN Material ON Items.MaterialID = Material.MaterialID INNER JOIN Category ON Items.CatID = Category.CatID WHERE Items.CatID = '4' ORDER BY Item_Name
     
    tdd1984, May 25, 2007 IP
  2. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #2
    can you past here the mysql error after you run that query?
     
    gibex, May 26, 2007 IP
  3. randomIntellections

    randomIntellections Well-Known Member

    Messages:
    985
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    180
    #3
    have you added remote host access to the server ?
     
    randomIntellections, May 26, 2007 IP