'; $result=mysql_query($sql); } $sql='CREATE TABLE Diseases (ID int, disease VARCHAR(30), PRIMARY KEY (ID,disease))'; $result=mysql_query($sql); for($i=0;$i<50;$i++) { $id=rand(1,100); $mal=$malady[array_rand($malady)]; $sql='INSERT INTO Diseases(ID,disease) VALUES("'.$id.'","'.$mal.'")'; $result=mysql_query($sql); } mysql_close(); echo '100 records for Patients and Diseases created.
'; ?>