0){ $row = mysql_fetch_assoc($result); $q2 = "INSERT into `las_word` (`wordid`, `lemma`) VALUES ( '".$row['wordid']."', '".$row['lemma']."' )"; $result2 = mysql_query($q2) or print('mysql_query:2'.mysql_error()); $q3 = "SELECT * FROM `sense` WHERE `wordid` = '".$row['wordid']."'"; $result3 = mysql_query($q3) or print('mysql_query:3'.mysql_error()); $num_rows3 = mysql_num_rows($result3); for($i = 0; $i< $num_rows3; $i++){ $row3 = mysql_fetch_assoc($result3); $q4 = "INSERT INTO `las_sense` (`wordid`, `synsetid`, `rank`) VALUES ('".$row3['wordid']."', '".$row3['synsetid']."', '".$row3['rank']."')"; $result4 = mysql_query($q4) or print('mysql_query:4'.mysql_error()); $q5 = "SELECT * FROM `synset` WHERE `synsetid` = '".$row3['synsetid']."'"; $q6 = "SELECT * FROM `sample` WHERE `synsetid` = '".$row3['synsetid']."'"; $result5 = mysql_query($q5) or print('mysql_query:5'.mysql_error()); $num_rows5 = mysql_num_rows($result5); $result6 = mysql_query($q6) or print('mysql_query:6'.mysql_error()); $num_rows6 = mysql_num_rows($result6); for($j = 0;$j < $num_rows5; $j++){ $row5 = mysql_fetch_assoc($result5); $def = addslashes($row5['definition']); $q7 = "INSERT INTO `las_synset` (`synsetid`, `pos`, `definition`) VALUES ('".$row5['synsetid']."', '".$row5['pos']."', '".$def."')"; $result7 = mysql_query($q7) or print('mysql_query:7'.mysql_error().$q7); } for($k = 0;$k < $num_rows6; $k++){ $row6 = mysql_fetch_assoc($result6); $sample = addslashes($row6['sample']); $q8 = "INSERT INTO `las_sample` (`synsetid`, `sampleid`, `sample`) VALUES ('".$row6['synsetid']."', '".$row6['sampleid']."', '".$sample."')"; $result8 = mysql_query($q8) or print('mysql_query:8'.mysql_error()); } } $num_rows --; //echo "
".$row['wordid'].":".$row['lemma']; } if(num_rows == 0) echo "Done :)"; ?>