[SOLVED] weird server behaviour

[ukscotth]

Hi,

 

Whenever I run this script my server freaks out and I end up having to reboot it. Any ideas why ? there are 19000 pictures but ive run similar scripts and had no problems

 

<?php 
include("include/configvb.inc.php");

$pics = mysql_query("SELECT * FROM picture");

			while ($got_pics = mysql_fetch_array($pics)){

mysql_query("INSERT INTO albumpicture (`albumid`,`pictureid`) 

VALUES 

('".$got_pics['userid']."','".$got_pics['pictureid']."')");

}

?>

[rhodesa]

nope...not sure, but why wouldn't you just do this:

 

INSERT INTO `albumpicture` (`albumid`,`pictureid`) SELECT (`userid`,`pictureid`) FROM picture

 

no PHP loop needed

[JonnoTheDev]

Why do you need a script to do this. Also you do not need a loop. Read on MySQL insert select i.e.

INSERT INTO albumpicture (albumid, pictureid) SELECT albumid, pictureid FROM picture

[ukscotth]

coz im a newbie lol

 

but thanks so all i need to use is that single line yes ?

 

 

[rhodesa]

yup...just that one query, run once. and use the code by @neil.johnson, mine shouldn't have the extra parenthesis in the select portion

[JonnoTheDev]

Wouldn't run through a browser either. Straight into mysql server.

[ukscotth]

ok thanks very much, il give it a go now

[ukscotth]

thnx peeps, looks like its worked doing it that way