MySql Not Posting data
#1

MySql not uploading any data to database.

Here is the full code :
PHP код:
if(dialogid == DIALOG_PRICE)
    {
        if(
response)
        {
            new 
Float:tmp_x,Float:tmp_y,Float:tmp_z;
            
GetPlayerPos(playerid,tmp_x,tmp_y,tmp_z);
            new 
id;
            
id GetFreeBizID();
            
bInfo[id][b_selling] = 1;
            
bInfo[id][b_price] = strval(inputtext);
            
bInfo[id][b_x] = tmp_x;
            
bInfo[id][b_y] = tmp_y;
            
bInfo[id][b_z] = tmp_z;
            new 
query[512];
            
format(querysizeof(query),"INSERT INTO biz (b_x, b_y, b_z, b_intx, b_inty, b_intz, b_price, h_selling) VALUES ('%f', '%f', '%f', '%f', '%f', '%f', '%i', '1')",bInfo[b_x],bInfo[b_y],bInfo[b_z],bInfo[b_intx],bInfo[b_inty],bInfo[b_intz],bInfo[b_price],bInfo[b_selling]);
            
mysql_function_query(dbhandlequerytrue"OnBizCreated""i"id);
            
UpdateBiz(id);
        }
        return 
1;
    } 
Everything working fine, it also show, but it's temporary. Not saving in database
Reply


Messages In This Thread
MySql Not Posting data - by akib - 26.02.2018, 18:13
Re: MySql Not Posting data - by Eric_White - 26.02.2018, 18:47
Re: MySql Not Posting data - by akib - 26.02.2018, 18:51
Re: MySql Not Posting data - by Eric_White - 26.02.2018, 18:56
Re: MySql Not Posting data - by akib - 26.02.2018, 18:57
Re: MySql Not Posting data - by Eric_White - 26.02.2018, 19:02

Forum Jump:


Users browsing this thread: 1 Guest(s)