(error #1054) Unknown column '0' in 'field list'
#1

I know what the error means, but I don't have a '0' column, and I do have every column made in the table, and it is the right table, here's the query below:
Code:
mysql_format(propertiesLine, query, sizeof(query), "INSERT INTO `houses` (`cID`, `Address`, `hX`, `hY`, `hZ`, `hA`, `Level`, `Value`, `SalePrice`, `ForSale`) VALUES (`%d`, `%s`, `%f`, `%f`, `%f`, `%f`, `%d`, `%d`, `%d`, `%d`)",\
				cache_insert_id(), zone, HouseData[id][hX], HouseData[id][hY], HouseData[id][hZ], HouseData[id][hA], HouseData[id][Level], HouseData[id][Value], HouseData[id][Value], 1);
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)