The Code-Bin
Links
Home
Add your code!
All Listings
About
Latest Entry
Featured Scripts
Author's Website
Latest Entries
FFMPEG Thumbnail Scr...
PHP, 0.8KB
Jul. 29, 10:24pm
John
Z80 Assembler, 190 bytes
Feb. 17, 3:36am
John
Z80 Assembler, 176 bytes
Sep. 13, 2:19am
John
Z80 Assembler, 77 bytes
Sep. 13, 2:18am
John
Z80 Assembler, 209 bytes
Sep. 13, 2:17am
untitled PHP Code
Posted by: Bodin | August 15, 2010 @ 9:29pm
PHP Code
[
Download
]
$result = mysql_query("SELECT * FROM `g_anvendare` JOIN `g_forening` ON `g_anvendare`.`iUser` = `g_forening`.`id` ORDER BY `iUser`;"); while ($row = mysql_fetch_array($result)) { if (mysql_query(" INSERT INTO `users` (`username`, `password`, `status`) VALUES ('{$row['sNick']}', '{$row['sPassword']}', '0');")) { $lastid = mysql_insert_id(); mysql_query(" INSERT INTO `userdata` (`id`, `firstname`, `lastname`, `personalnumber`, `startdate`, `enddate`, `gender`, `address`, `postalcode`, `city`, `land`, `email`, `phonenumber`) VALUES ({$lastid}, '{$row['fnamn']}', '{$row['enamn']}', '{$row['pnr']}', '{$row['gickmed']}', '0000-00-00', 'Man', '{$row['adress']}', '{$row['postnr']}', '{$row['postort']}', 'Sverige', '{$row['sEmail']}', '{$row['telnr']}'); "); } }
Syntax Highlighting
[
Open in new window
]
Author Comments
none
Rating
4.45 / 8
44 Votes
http://codebin.yi.org/794
page generated in 0.01 seconds