Sql syntax error c++ (help)

[jmulhern345]

SO i am getting a syntax error around the name my Arcemu-world says.

This is the SQL
____________________________________________________________
CREATE TABLE `Puchase_Items` (
`ID` int(10) NOT NULL auto_increment,
`Name` varchar(100) NOT NULL,
`entryID` int(10) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`),
KEY `Name` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=18272 DEFAULT CHARSET=latin1;


____________________________________________________________
This is the C++
____________________________________________________________
case BUYITEM_MENU:
{
char pItem5[100];
objmgr.CreateGossipMenuForPlayer(&Menu, pObject->GetGUID(), 1, Plr);
sprintf(pItem5, "Enter Item Name [%u]", MORPH_COST/DIVIDER);
Menu->AddItem(ICON_WHEEL, pItem5, BUYITEM_FUNCTION, 1);
Menu->SendTo(Plr);
}break;

case BUYITEM_FUNCTION:
{
QueryResult *pItem5 = WorldDatabase.Query("Select `entryID` FROM Purchase_Items where `Name` = '%s'", Code);

if(pItem5)
{
Field *Fields = pItem5->Fetch();
uint32 entryID = Fields[0].GetUInt32();
Plr->SetUInt32Value(INVENTORY_SLOT_NOT_SET, entryID);
Plr->GetItemInterface()->SafeAddItem(entryID, INVENTORY_SLOT_NOT_SET, 23);
Plr->Gossip_Complete();
}
}break;
________________________________________________________________


See any problems?

Srry im not sure how to make text boxes lol.

[Reflection]

Write the text in [code]Text goes here[/ code] without the space.

About the error, the SQL is fine to me. I even tried to run the query, and it worked perfectly.

However, I'm unable to help with the c++ error (although the SQL syntax error got something to do with the sql)

[Function]

Cant help you with SQL as when I did my EMU I didnt do the sql. I am more of Game programmer, i have other people do the SQL database, But if you want through me the source and I will check out the Syntax error

[TheSpidey]

CREATE TABLE `Puchase_Items` (
`ID` int(10) NOT NULL auto_increment,
`Name` varchar(100) NOT NULL,
`entryID` int(10) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`),
KEY `Name` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=18272 DEFAULT CHARSET=latin1;


QueryResult *pItem5 = WorldDatabase.Query("Select `entryID` FROM Purchase_Items where `Name` = '%s'", Code);

Puchase vs Purchase

[jmulhern345]

Lol thx thespidey but i already figured it out i make stupid lil mistakes. My only problem is that....... i get a duplicate item error when i use the function. Got a clue and i can only spawn it into my first bag not my second or any others.