Tack för hjälpen.. detta funkade:
Kod:
$query = mysql_query("INSERT INTO tabell1(account_id, membership_id, price, accept_after_confirm, cdate, status) VALUES((SELECT id FROM tabell2 WHERE user = '$infos[1]'),'7','30.00','1',NOW(),'APPROVED')") or die(mysql_error());
PaLL3