This first bit of code works, but the second does not.
Can anyone see the problem?
Thanks
Paul
Code: Select all
<td>Result</td>
<td><select name="result" >
<?php
$query1 = "SELECT name FROM result";
$result1 = mysql_query($query1, $linkID);
if(mysql_num_rows($result1)) {
// we have at least one user, so show all users as options in select form
while($row = mysql_fetch_row($result1))
{
print("<option value="$rowї0]">$rowї0]</option>");
}
} else {
print("<option value="">No users created yet</option>");
}
$query = "SELECT abr FROM result where name='$result'";
$result = mysql_query($query, $linkID);
?>Code: Select all
<td>Course</td>
<td><select name="coursename" >
<?php
$query3 = "SELECT course_name FROM course";
$result3 = mysql_query($query3, $linkID);
if(mysql_num_rows($result3)) {
// we have at least one user, so show all users as options in select form
while($row = mysql_fetch_row($result3))
{
print("<option value="$rowї0]">$rowї0]</option>");
}
} else {
print("<option value="">No course created yet</option>");
}
$query9 = "SELECT course_id FROM course where course_name='$coursename'";
$course_id = mysql_query($query9, $linkID);
?>Code: Select all
$sql = "INSERT INTO subjects (unit_no, unit_name, abr, sem, year, uni_id, course_id ) VALUE ('$unit_no', '$unit_name', '$result', '$sem', '$year', '$uni_id', '$course_id')";feyd | please use
Code: Select all
tags while theCode: Select all
tags are down![/color]