1. $result = mysql_query("SELECT * FROM `g_anvendare` JOIN `g_forening` ON `g_anvendare`.`iUser` = `g_forening`.`id` ORDER BY `iUser`;");
  2.  
  3. while ($row = mysql_fetch_array($result)) {
  4. if (mysql_query("
  5. INSERT INTO `users` (`username`, `password`, `status`) VALUES
  6. ('{$row['sNick']}', '{$row['sPassword']}', '0');"))
  7. {
  8. $lastid = mysql_insert_id();
  9.  
  10. mysql_query("
  11. INSERT INTO `userdata` (`id`, `firstname`, `lastname`, `personalnumber`, `startdate`, `enddate`, `gender`, `address`, `postalcode`, `city`, `land`, `email`, `phonenumber`) VALUES
  12. ({$lastid}, '{$row['fnamn']}', '{$row['enamn']}', '{$row['pnr']}', '{$row['gickmed']}', '0000-00-00', 'Man', '{$row['adress']}', '{$row['postnr']}', '{$row['postort']}', 'Sverige', '{$row['sEmail']}', '{$row['telnr']}');
  13. ");
  14. }
  15. }