Mysql error
#9

as you done for insert query, do for select, thread it and do this:

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();
in another case
Reply


Messages In This Thread
Mysql error + REP - by Cheesus - 17.11.2014, 00:51
Re: Mysql error - by OsteeN - 17.11.2014, 06:17
Re: Mysql error - by CoaPsyFactor - 17.11.2014, 06:51
Re: Mysql error - by Cheesus - 17.11.2014, 09:15
Re: Mysql error - by CoaPsyFactor - 17.11.2014, 09:27
Re: Mysql error - by Cheesus - 17.11.2014, 10:36
Re: Mysql error - by CoaPsyFactor - 17.11.2014, 11:44
Re: Mysql error - by Cheesus - 17.11.2014, 11:52
Re: Mysql error - by CoaPsyFactor - 17.11.2014, 12:25
Re: Mysql error - by Cheesus - 17.11.2014, 12:42

Forum Jump:


Users browsing this thread: 1 Guest(s)