Welcome Guest, Not a member yet? Register   Sign In
Multiple MySql insert problem
#8

[eluser]polish[/eluser]
I am not lazy n0xie but you are great!!! Yours solution was in 99 % good and this is the working solution:

Code:
function tagi_add($data)
{
        $sql = 'INSERT INTO newstags (ttags_id, nnews_id) VALUES ';
        if (is_array($data['ttags_id']))
        {
            foreach($data['ttags_id'] as $key=>$value)
            {
                $sql .= "($value, $data[nnews_id]),";
            }
            $sql = substr($sql,0,-1);
        }
        else
        {
            $sql .= "($data[ttags_id], $data[nnews_id])";
        }
        $query = $this->db->query($sql);
}



Topic solvedSmile!!!


Messages In This Thread
Multiple MySql insert problem - by El Forum - 06-18-2009, 09:24 AM
Multiple MySql insert problem - by El Forum - 06-18-2009, 09:34 AM
Multiple MySql insert problem - by El Forum - 06-18-2009, 09:36 AM
Multiple MySql insert problem - by El Forum - 06-18-2009, 09:54 AM
Multiple MySql insert problem - by El Forum - 06-18-2009, 10:13 AM
Multiple MySql insert problem - by El Forum - 06-18-2009, 10:38 AM
Multiple MySql insert problem - by El Forum - 06-18-2009, 11:01 AM
Multiple MySql insert problem - by El Forum - 06-18-2009, 11:58 AM
Multiple MySql insert problem - by El Forum - 06-18-2009, 05:45 PM



Theme © iAndrew 2016 - Forum software by © MyBB