Multiple MySql insert problem

[eluser]n0xie[/eluser]
[quote author="polish" date="1245358464"]

Code:

INSERT INTO newstags (ttags_id, nnews_id) VALUES (1, 27), (2, 27), (5, 27)......

this solution is bad!
[/quote]

What's bad about this solution exactly? Sounds to me you're just lazy.

Fine I'll SPELL it out for you.

Code:

$data = array(
                'ttags_id' => array(
                    0    =>  1,
                    1    =>    2,
                    2   =>    5),
                'nnews_id' => 27
                );
        $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])";
        }

        echo $sql;