Hi All,
I am trying to get the following code working. It is supposed to display a selection box for the project_ID and two read only text boxes for the project_name and project_desc. However the two read only boxes don't seem to display anything. The project_ID does display in the selection box. Any help appreciated.
<?php
$sql = "SELECT student_ID, project_name FROM student_project";
$result = mysql_query($sql) or die ($sql . '<br />' . mysql_error());
if (!$result) {
echo 'Query failed';
exit;
}
$optionsHTML = '';
$optionsJS = "var projectData = new Array();\n";
$query = 'SELECT project_ID, project_name, project_desc FROM student_project';
$result = mysql_query($query) or die("error in query:" . mysql_error());
function jsSafe($str) {
return addslashes(htmlspecialchars(preg_replace("/[\n\r]+/",'', $str)));
}
while($row = mysql_fetch_assoc($result)) {
$optionsHTML .= '<option value="'.$row['project_ID'].'">'.$row['project_ID'].'</option>';
$optionsJS .= sprintf('projectData[%d] = new Array("%s","%s");'."\n",
$row['project_ID'],
jsSafe($row['project_name']),
jsSafe($row['project_desc']));
}
echo '<script type="text/javascript">';
echo $optionsJS;
echo '</script>';
echo '<select onchange="v=this.options[this.selectedIndex].value;this.form.text1.value=projectData[v][0];this.form.text2.value=projectData[v][1];">';
echo $optionsHTML;
echo '</select>';
echo '<input type="text" name="text1" readonly="readonly" />';
echo '<input type="text" name="text2" readonly="readonly" />';
?>
Here is what I got from HTML View Source for <script type="text/javascript"> onwards:
<script type="text/javascript">var projectData = new Array();
projectData[18] = new Array("TEST1","TEST DESC1");
</script><select onchange="v=this.options[this.selectedIndex].value;this.form.text1.value=projectData[v][0];this.form.text2.value=projectData[v][1];"><option value="18">18</option></select><input type="text" name="text1" readonly="readonly" /><input type="text" name="text2" readonly="readonly" /></td>
</table>
<br>
<input type="submit" name="submit" value="Join Project">
