[steki.]

I don't know why and how, but it seems I ain't in a luck day.

Check it out.

pawn Код:

format( str, 256, "SELECT * FROM vehicleinfo WHERE id=%d AND owner=%d", vehicleInfo[v][vOwner], playerInfo[playerid][pCid] );

As I said, I don't know why does it gives up "LECT * FROM vehicleinfo...".

Any light from the sky? :<

[JaTochNietDan]

I think you might want to provide more information and explain it, because reading this I really don't know what you mean, I can only make a wild guess from extracting some of your vague explanation, which is, when the query string is formatted it doesn't have the "SEL" part of the string in it?

[steki.]

Code:

pawn Код:

new str[256];
                        format( str, 256, "SELECT * FROM vehicleinfo WHERE id=%d AND owner=%d", vehicleInfo[v][vOwner], playerInfo[playerid][pCid] );
                        mysql_query( query );
                        mysql_store_result();
                        new n = mysql_num_rows();
                        mysql_free_result();

What I get:

[Pinguinn]

Nvm, that wasnt the error

[JaTochNietDan]

That's not showing that the string is missing pieces, it's only highlighting a part of the SQL syntax that is not correct (Indeed it is not very clear in this state, although it is designed to deal with much larger more complex queries). I can't see any problem really with the syntax, although it may be expecting your table name to be enclosed in quotes, for example:

pawn Код:

SELECT * FROM `vehicleinfo` WHERE id = %d AND owner = %d

To prove my point, simply print the query string and you will see that there is nothing missing from it.

[steki.]

Thanks. I'll figure out what's the actual problem later.