function

Create function newid ( id int(8)) returns int(8)begindeclare newid int(8);select gs.user_id into newid from sjames_gssite.phpbb_users gs left join development.phpbb_users dev on dev.username=gs.username where (select username from development.phpbb_users where user_id = id ) = dev.username ;return newid;end