Zhenia
Компетентный
Мне нужно взять стринговую строку по ID
PHP:
format(query, sizeof(query), "SELECT * FROM users WHERE ID = '%i'", TR[listitem][baOwner]);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows())
BaseGet("Name", vl);
mysql_free_result();
PHP:
BaseGet(fields[],perms[])//Функция взятия String-а из бд
{
new fetch[256];
mysql_fetch_field_row(fetch,fields);
strmid(perms, fetch, 0, strlen(fetch), 255);
}
>> mysql_query( Connection handle: 1 )
[22:01:15] CMySQLHandler::Query(SELECT * FROM users WHERE ID = '24') - Successfully executed.
[22:01:15] >> mysql_store_result( Connection handle: 1 )
[22:01:15] CMySQLHandler::StoreResult() - Result was stored.
[22:01:15] >> mysql_num_rows( Connection handle: 1 )
[22:01:15] CMySQLHandler::NumRows() - Returned 1 row(s)
[22:01:15] >> mysql_fetch_field_row( Connection handle: 1 )
[22:01:15] CMySQLHandler::FetchField(Name) - You cannot call this function now. (Reason: Fields/Rows are empty.)
[22:01:15] >> mysql_free_result( Connection handle: 1 )
[22:01:15] CMySQLHandler::FreeResult() - Result was successfully free'd.
[22:01:15] CMySQLHandler::Query(SELECT * FROM users WHERE ID = '24') - Successfully executed.
[22:01:15] >> mysql_store_result( Connection handle: 1 )
[22:01:15] CMySQLHandler::StoreResult() - Result was stored.
[22:01:15] >> mysql_num_rows( Connection handle: 1 )
[22:01:15] CMySQLHandler::NumRows() - Returned 1 row(s)
[22:01:15] >> mysql_fetch_field_row( Connection handle: 1 )
[22:01:15] CMySQLHandler::FetchField(Name) - You cannot call this function now. (Reason: Fields/Rows are empty.)
[22:01:15] >> mysql_free_result( Connection handle: 1 )
[22:01:15] CMySQLHandler::FreeResult() - Result was successfully free'd.
