mysql_fetch_field_row - Printable Version

mysql_fetch_field_row - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: mysql_fetch_field_row (/showthread.php?tid=132635)

mysql_fetch_field_row - Anwix - 08.03.2010

I'm in need of help from getting a string from a database, im using 'mysql_fetch_field_row' and its not actually getting nothing, maybe im doing something wrong, but i don't know.

I want to select the owner of a business from a database and mysql_log is printing:

Код:

[15:18:37] >> mysql_fetch_field_row( Connection handle: 1 )
[15:18:37] CMySQLHandler::FetchField("owner") -

my code is:

pawn Код:

format(query, sizeof(query), "SELECT * FROM businesses WHERE busid = '%d' LIMIT 1", id);
mysql_query(query);
mysql_store_result();
mysql_fetch_field_row(query, "owner");
format(Business[id][Owner], 60, "%s", query);

Can anyone spot what im doing wrong? : D

Re: mysql_fetch_field_row - Anwix - 09.03.2010

bump