problem when selling items

[destroyer555]

when i sell items i get this

You sold 1000 Small Medikit(s) for $300000QUERY ERROR: 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 'orange'>Small Medikit(s) for $300000')' at line 4

Query was INSERT INTO itemselllogs (isID,isUSER,isITEM,isTOTALPRICE,isQTY,isTIME,isCONTENT) VALUES ('', 1, 12, 300000, 1000, unix_timestamp(),'Alex sold 1000 Small Medikit(s) for $300000')

[AbsentCrisis]

Re: problem when selling items

Check the query which inserts the sale in to the "itemselllogs" im guessing.

[Haunted Dawg]

Re: problem when selling items

Your most probably using in the query:

Alex sold 1000 <font color='green'>Small Medikit(s)</font> for $300000

Which screws with the code.

[destroyer555]

Re: problem when selling items

so what should i put instead and in which query in itemselllogs?

[destroyer555]

Re: problem when selling items

my items are screwed up badly when i try to buy an item from the market i get this aswell :cry:

QUERY ERROR: 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 'FROM `itemmarket` im LEFT JOIN `items` i ' at line 3

Query was SELECT `imID`,`imITEM`,`imADDER`,`imPRICE`,`imCURRENCY`, FROM `itemmarket` im LEFT JOIN `items` i ON i.itmid = 0 WHERE imID = 79

[AbsentCrisis]

Re: problem when selling items

Maybe you should look to hire a coder or look for someone to help you, since you are having many problems with your game and seem kind of clueless of how to fix them.