[solved] Why is this not working now? Error in code message!
Posted: Thu Apr 24, 2008 6:59 am
Hi,
I keep getting the follow error with the code below
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Gift' ORDER BY product_Name' at line 7
I cannot understand this as this script has been running correctly for a few months now and all of a sudden this error appeared. I have tried various different changes but nothing is clering it. I think the problem might be with AND category_Name = '$xHeading[category_Name]' (which was working) and I have tried '$xHeading[“category_Name”]' '$xHeading[‘category_Name’]' but neither of these work the.
Has anyone any idea as to what this might be? This site is running on Server: Apache/1.3.37 . When I view it and test on my local PC IIS it works fine so I’m really puzzled.
Thanks very much
I keep getting the follow error with the code below
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Gift' ORDER BY product_Name' at line 7
I cannot understand this as this script has been running correctly for a few months now and all of a sudden this error appeared. I have tried various different changes but nothing is clering it. I think the problem might be with AND category_Name = '$xHeading[category_Name]' (which was working) and I have tried '$xHeading[“category_Name”]' '$xHeading[‘category_Name’]' but neither of these work the.
Has anyone any idea as to what this might be? This site is running on Server: Apache/1.3.37 . When I view it and test on my local PC IIS it works fine so I’m really puzzled.
Thanks very much