Code:
$sql_pm = "INSERT INTO {$db_prefix}pm_recipients (`id_pm`, `id_member`,`labels`,`bcc`,`is_read`,`is_new`,`deleted`)
ovo je ok
Code:
VALUES ($last_id, id_member FROM {$db_prefix}members WHERE member_name = '$member' , '-1','0', '0', '1', '0') " ;
ovo ne valja .. ne moze VALUES FROM WHERE
mozda si hteo
Code:
SELECT $last_id, id_member , '-1','0', '0', '1', '0' FROM {$db_prefix}members WHERE member_name = '$member' " ;
tako ce da radi
dakle
Code:
$sql_pm = "INSERT INTO {$db_prefix}pm_recipients (`id_pm`, `id_member`,`labels`,`bcc`,`is_read`,`is_new`,`deleted`)
SELECT $last_id, id_member , '-1','0', '0', '1', '0' FROM {$db_prefix}members WHERE member_name = '$member' " ;