[madzat]

thx man for your help

--------------- Added [DATE]1451870478[/DATE] at [TIME]1451870478[/TIME] ---------------

Hi all i still have smal problem with sql is here i made new table spmembers and have spusername im using like that and is not working to add all list to sql

PHP Code:

$spmember = $db->query_read("SELECT username, field7 FROM ". TABLE_PREFIX ."user LEFT JOIN mo_userfield ON(mo_user.userid=mo_userfield.userid) WHERE usergroupid IN(12,13)");

$i=0;
while ($array2 = $db->fetch_array($spmember))
{
    // Do something with the current row here
    if($i==0)
    {
        $res_html.= "<tr><td width='50%' style='color:#e37616;'>".$array2['field7']."</td></tr>";
        $i++;
    }
    else
    {
        
        spmember = $db->query_write("INSERT INTO " . TABLE_PREFIX . "spmembers (spusername) VALUES field7");
            $res_html.= "<tr><td width='50%' style='color:#e37616;'>".$array2['field7']."</td></tr>";

    }
    
} 


i want to add field7 to sql i tested with array not not working and i dont know haw to fix plz any help thx

PHP Code:

spmember = $db->query_write("INSERT INTO " . TABLE_PREFIX . "spmembers (spusername) VALUES field7");