dsg

I have a page that allows a user to select an student to work with. In the code below, I have saved each student id in an array so I can get the value by perhaps a javascript which would look something like this: var id = document.form.select_list[selectedIndex].text; document.form.id = id; Any idea of exactly how I should do it? I would like to use php only and no javascript but I am a little clueless on how to do this. My final goal is to register the \"id\" in a session and pass it back to the calling page. <?php echo \"<input type = \"hidden\" name = \"id\">\"; echo \"<select name = \"select_list\">\"; $i = 0; $arr = array(); while ($row = mysql_fetch_assoc($result)) { echo \"<option>\".$row[\'last\'].\", \".$row[\'first\'].\"</option>n\"; $arr[$i++] = $row[\'id_number\']; } echo \"</select>\"; ?>

How do you execute table creation scripts from within MySQL? I know in Oracle, it is \"@script.sql\" ....what is the equivalent command in MySQL. Sorry it is a simplistic question but I haven\'t found the answer after some research.