mysql INSERT: double-query

[notset]

Hello,

$sql = "INSERT INTO msg SET to_id = SELECT id FROM users WHERE username = 'test'";

I want to make something like that, but i don't know the right syntax.

Please help.

[devinemke]

$sql = "INSERT INTO msg SET to_id = (SELECT id FROM users WHERE username = 'test')";

note: you must have mySQL 4.1 or higher to use subqueries