17.11.2014, 12:25
as you done for insert query, do for select, thread it and do this:
in another case
pawn Код:
mysql_store_result(); // Store the results of the query
while(mysql_fetch_row(query, "|"))
{
mysql_fetch_field("id_member", query);
VariableToStoreMemberID = strval(query); // Get the value from member_id field and turn it into a int instead of a string. (that is if you're saving it as a VARCHAR or alike)
format(query, sizeof(query), "INSERT INTO smf_log_online (session, log_time, id_member, id_spider, ip, url) VALUES (0, 0, '%d', 0, 0, 0)",VariableToStoreMemberID);
mysql_query(query);
}
mysql_free_result();