[almcaeobtac]

I'm trying to fix a friend's code, but I don't understand SQL at all. Basically no data is loading. It might be because it isn't saving too. The only error in the logs is this:

[SM] Native "SQL_FetchInt" reported: Error fetching data from field 3

What does this mean?

[Dravu]

In your SQL query, you only return 2 columns. Your coding is trying to grab a 3rd column that doesn't exist.

[Monkeys]

Columns use indexes, so you start with getting from column "0"

(It's a lot easier to see what's wrong if you show what you did, aka. your query ;p)

[almcaeobtac]

It's difficult. It's not my code, and he doesn't want to share it. Plus, in the error logs, it doesn't even return the correct line number for the error.

[Monkeys]

Well, most likely it's just a wrong index used for the column.

Check the query, the "SELECT ... FROM" part. The results are arranged exactly as they are there. Each column is seperated by a comma and they start with index 0.

So this "SELECT alpha, and, omega FROM universe WHERE god = 0;"
would result in
column 0: alpha
column 1: and
column 2: omega

In his case, he probably fetched from column 3 while he meant column 2. Or column 3 isn't an int.


(Offtopic: That isn't a query I just made up, it's actually part of a project I once made )

[almcaeobtac]

What about when it's like this:

Format(buffer, sizeof(buffer),"SELECT * FROM Player WHERE STEAMID = '%s';",SteamId);

[Monkeys]

Originally Posted by almcaeobtac What about when it's like this: Format(buffer, sizeof(buffer),"SELECT * FROM Player WHERE STEAMID = '%s';",SteamId);

You'll need to know how your Player table is made up. It'll follow that format.
But I'd like to suggest that you never use *, just for this very reason
You don't need all data anyway.

[almcaeobtac]

I'm completely confused xD, thanks anyway though.

[Antithasys]

When dealing with a database as a coder, you... the coder, need access to the database through some means... like phpmyadmin for mysql or something. There you can see all the tables and fields in the database.

The problem you are having is that you are selecting all the fields (SELECT * ) in the "Player" table and you don't actually know what those fields are, or what datatypes they are.

SQL SELECT queries are formatted like this:

PHP Code:

SELECT field1, field2, field3 FROM table1 WHERE field1 = 'matchme'; 


You are selecting all the fields with a wildcard * from the Players table if the steam id matches. It is possible that you are not getting any results at all (no matches for that steamid), or you do not have the field count/datatype right. Always check to make sure you actually got results before asking for them.

[almcaeobtac]

Ahh ok, so I have to remove the * and format it like that?