[noodleboy347]

I've been struggling with getting this to work, as I'm running multiple queries to get different columns of data from a database. How can I get multiples items using a single query ("SELECT * FROM"), or is this not possible?

[Leonardo]

PHP Code:

while(SQL_FetchRow(hQuery)) // rows
{
    SQL_FetchString(hQuery, 0, sBuffer, sizeof(sBuffer));
    SQL_FetchString(hQuery, 1, sBuffer, sizeof(sBuffer));
    // columns...
} 


[Monkeys]

I would like to suggest not using SELECT * though, but to declare every column you're using, even if you're using them all.
Because SM reads column by number, meaning you need to know their order. * uses the order of the table, but you don't know what that is from looking at the code.

[berni]

Or use SMLIB, it has some functions for reading data by column names:

http://forums.alliedmods.net/showthr...93#post1398793

stock SQL_FetchIntByName(Handle:query,  String:fieldName[],  &DBResult:result=DBVal_Error);
stock bool:SQL_FetchBoolByName(Handle:query,  String:fieldName[],  &DBResult:result=DBVal_Error);
stock Float:SQL_FetchFloatByName(Handle:query,  String:fieldName[],  &DBResult:result=DBVal_Error);
stock SQL_FetchStringByName(Handle:query,  String:fieldName[],  String:buffer[],  maxlength,  &DBResult:result=DBVal_Error); 

[Leonardo]

looks like advertisement

[FaTony]

It's 266 stocks! Sure I'll be popping in almost every thread from this time.

[berni]

Originally Posted by Leonardo looks like advertisement

I participate in this thread, what I can't say from you, when it is useful
I don't see why I shouldn't tell when it is exactly that what is needed.

/me smiles at your sig

[noodleboy347]

Originally Posted by berni Or use SMLIB, it has some functions for reading data by column names: http://forums.alliedmods.net/showthr...93#post1398793 stock SQL_FetchIntByName(Handle:query, String:fieldName[], &DBResult:result=DBVal_Error); stock bool:SQL_FetchBoolByName(Handle:query, String:fieldName[], &DBResult:result=DBVal_Error); stock Float:SQL_FetchFloatByName(Handle:query, String:fieldName[], &DBResult:result=DBVal_Error); stock SQL_FetchStringByName(Handle:query, String:fieldName[], String:buffer[], maxlength, &DBResult:result=DBVal_Error);

This is great, thanks