[onosrider]

i use the same code for two plugins to test someting, but i always get errors with longer and more advanced sql querys.

a verry simple one works perfect:

result = dbi_query(dbc,"SELECT rank FROM my_stats WHERE steamid='%s'",authid)

but this one dosen't:

result = dbi_query(dbc,"SELECT a.userid, a.rank, b.userid, b.kills, b.onlinetime FROM my_stats AS a, my_stats_2 AS b WHERE a.userid = b.userid AND steamid='%s'",authid)

can anyone tell me why?

[jtp10181]

and the error is....

[Des12]

MYSQL queries often don't give errors

AS a, my_stats_2 AS b

Does what?

[onosrider]

i have to setup a testserver again and debug...

L 03/19/2006 - 02:09:00: [AMXX] Run time error 10 (plugin "sqltest.amxx") - debug not enabled! L 03/19/2006 - 02:09:01: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes). L 03/19/2006 - 02:09:14: [MYSQL] Invalid result handle -1

code now:

new rank[32]
        dbi_nextrow(result)
        dbi_result(result,"rank",rank,32)

the only i do not know is, do i have to add a. and b. in dbi_result?

example...?

new rank[32]
        dbi_nextrow(result)
        dbi_result(result,"a.rank",rank,32)

[jtp10181]

invalid result handle error you can get when you dont do proper error checking

[Brad]

Originally Posted by Des12 MYSQL queries often don't give errors

How sure are you about that? It's been my experience that I always get an error if one occurs.

[jtp10181]

Originally Posted by Brad Originally Posted by Des12 MYSQL queries often don't give errors How sure are you about that? It's been my experience that I always get an error if one occurs.

yeah, it always gives errors if there is one, mysql is very picky about syntax and it does not quietly ignore your problem.

[Des12]

On compile they don't for me

[jtp10181]

amxx compiler does not care about your mysql syntax....
nor does it care about how well you have done error checking.

[onosrider]

my query string works, it is something about amxx, this for sure.