hi, I'm converting some DBI to SQLx and am having troubles with one little part.
Code:
if ( !dbi_query(g_dbc,"UPDATE `%s` SET name='%s',date=NOW(),row1=%i,row2=%i,row3=%i,row4=%i,row5=%i WHERE authid='%s'", g_sqlstats_table, g_sPStatsNames[i], g_iPStats[i][row1], g_iPStats[i][row2], g_iPStats[i][row3], g_iPStats[i][row4],g_iPStats[i][row5], g_sPStatsIds[i]) )
dbi_query(g_dbc,"INSERT INTO `%s` (authid, name, date,row1,row2,row3,row4,row5) values('%s','%s',NOW(),%i,%i,%i,%i,%i)",g_sqlstats_table,g_sPStatsIds[i],g_sPStatsNames[i],g_iPStats[i][row1],g_iPStats[i][row2],g_iPStats[i][row3],g_iPStats[i][row4],g_iPStats[i][row5])