[RESOLVED] Simple, short script reaches maximum execution time.. ?

[kernelgpf]

$query=mysql_query("select todragonID,fromdragonID from dragonsmating");
$num=mysql_fetch_array($query);
for($i=0;$i<$num;$i++){
$row=mysql_fetch_array($query);
mysql_query("update dragons set atcave='yes' where id='$row[todragonID]'");
mysql_query("update dragons set atcave='yes' where id='$row[fromdragonID]'");
}
mysql_query("truncate dragonsmating");

 

I've looked at it over and over again.. what's wrong with it?

[Glyde]

$num should equal mysql_num_rows($query) instead of mysql_fetch_array($query)

[taith]

also... its much easier to do it this way... no icky stuffs... just plain and simple :-)

 

$query=mysql_query("select todragonID,fromdragonID from dragonsmating");
while($row=mysql_fetch_array($query)){
mysql_query("update dragons set atcave='yes' where id='$row[todragonID]'");
mysql_query("update dragons set atcave='yes' where id='$row[fromdragonID]'");
}
mysql_query("truncate dragonsmating");

[kernelgpf]

Ah, so easy. Thanks guys.