Quote:
Originally Posted by sssssssssss
This was working perfectly find when I was using a dbnpc, so I saw no real need to post where they came from.
|
You mean the code was working when it was in a DBNPC? If so, where is it now?
Quote:
Originally Posted by sssssssssss
PHP Code:
temp.reqitem = requestsql("SELECT id FROM Items WHERE name = '" @temp.item@ "'", true);
temp.blue = 1;
temp.queryString = requestsql("INSERT INTO Auction_Selling VALUES (" @temp.blue@ ", " @temp.sellacct@ ", " @temp.reqitem["rowid"]@ ", " @temp.blue@ ", " @temp.blue@ ", " @temp.price@ ", " @temp.reqitem["category"]@ ")", true);
echo(temp.queryString);
requestsql(temp.queryString, true);
and all im getting back is this
PHP Code:
SQLRequest_325830
dont understand why. :x |
You're getting SQLRequest_325830 because requestsql returns a "request object", so it's not actually a string like the variable name queryString implies. Also, since you're doing INSERT in the query the query object won't contain very much data like it would if you were SELECTing something.
Maybe you meant to do this?
PHP Code:
temp.queryString = "INSERT INTO Auction_Selling VALUES (" @temp.blue@ ", " @temp.sellacct@ ", " @temp.reqitem["rowid"]@ ", " @temp.blue@ ", " @temp.blue@ ", " @temp.price@ ", " @temp.reqitem["category"]@ ")";
echo(temp.queryString);
requestsql(temp.queryString, true);