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:
Code:
result = dbi_query(dbc,"SELECT rank FROM my_stats WHERE steamid='%s'",authid)
but this one dosen't:
Code:
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?
__________________