Ok so I'm still going to go sqlite way, and have been messing with it for some time. Figured since its an item db, an auction house which is almost another item db, it will be needed eventually, and to go ahead and use it now.
Also just to note, all the temp.vars are full and correct. This was working perfectly find when I was using a dbnpc, so I saw no real need to post where they came from.
I have this in a function
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