Zhenia
Компетентный
PHP:
[19:48:13] CMySQLHandler::Query(SELECT * FROM accounts WHERE `id` = '1') - Successfully executed.
[19:48:13] >> mysql_store_result( Connection handle: 1 )
[19:48:13] CMySQLHandler::StoreResult() - Result was stored.
[19:48:13] >> mysql_num_rows( Connection handle: 1 )
[19:48:13] CMySQLHandler::NumRows() - Returned 1 row(s)
[19:48:13] >> mysql_fetch_field_row( Connection handle: 1 )
[19:48:13] CMySQLHandler::FetchField(name) - You cannot call this function now. (Reason: Fields/Rows are empty.)
PHP:
stock GetNameForDB(idp)
{
new string[64];
new name[24];
format(string, sizeof(string), "SELECT * FROM "TABLE_ACCOUNT" WHERE `id` = '%d'", idp);
mysql_query(string);
mysql_store_result();
if(mysql_num_rows() > 0)
mysql_get_field("name", name);
mysql_free_result();
return name;
}