Extract error after MYSQL query

K0108788

Hi All,

I keep getting an extract function error on the extract($row) line after the mysql_fetch_array query. Can anyone help?

<?php 
session_start(); 
include "conn.inc.php";

$projectid = $_REQUEST['projectid'];

$query = 	"SELECT * FROM student_project WHERE project_ID='$projectid' ";
$result =	mysql_query($query)
	or die(mysql_error());

$row = mysql_fetch_array($result);
extract($row);
?>
<html>
<head>
<title>Edit Project: <?php  echo $project_name; ?></title>
</head>
<body>
<p>
<?php 
if (isset($_POST['submit']) && $_POST['submit'] == "Update Project") {
	if ($_POST['lecturer_role'] != " " &&
		$_POST['SK_ID'] != " " &&
		$_POST['project_name'] != " "  &&
		$_POST['project_description'] != " ")  {

	/* UPDATE QUERY */
	 $query = 	"UPDATE student_project sp " .
       					"SET sp.lecturer_role='$lecturer_role', sp.SK_ID='$SK_ID', " .
      					"sp.project_name='$project_name', sp.project_desc='$project_desc' " .
       					"WHERE project_ID = $pr_id";			
	$result =    mysql_query($query) 
		or die(mysql_error()); 
		}
}
	if (mysql_num_rows($result) !=0) {
?>
	<form action = "editproject.php" method="post">
		<table border="0" cellpadding="15">
<tr>
	<td>Select Lecturer Role:<br></td>
	<td>
		<input type="radio" name="role" value="Supervisor"
		<?php echo $lecturer_role=='Supervisor' ? ' checked' : '';?>>Supervisor<br>
		<input type="radio" name="role" value="Second Marker"
		<?php echo $lecturer_role=='Second Marker' ? ' checked' : '';?>>Second Marker<br>
		<input type="radio" name="role" value="Third Marker"
		<?php echo $lecturer_role=='Third Marker' ? ' checked' : '';?>>Third Marker<br>
		<input type="radio" name="role" value="Fourth Marker"
		<?php echo $lecturer_role=='Fourth Marker' ? ' checked' : '';?>>Fourth Marker<br>
	</td>
</tr>
<br>
<tr>
	<td>Project Name:</td>
	<td><input type="text" name="project_name" size="61"
				value="<?php echo $project_name; ?>">
	</td>
</tr>
<br>
<tr>
	<td>Project Description:</td>
	<td><input type="text" name="project_desc" size="61"
		value="<?php echo $project_desc; ?>">
	</td>
</tr>
<td colspan="2">
      <input type="submit" name="submit" value="Update Project">
	   <input type="reset">
<?php } ?>
    </td>
  </tr>
</table>
</form>
</p>
</body>
</html>

Roger_Ramjet

Have you checked if any rows were returned by the query? Most likely problem is that there is nothing in $row to extract.

K0108788

Yes there are rows returned by the query as I have taken out the extract($row) line and it doesn't bring up any of the values that should appear in the form. If there are values stored in the $row variable why is it causing an error when I press 'Update Project'?

I have echoed $row as well and it displays 'Array'.

I get the feeling that there may be a problem with the UPDATE query and the form, does that check out OK for use the extract function??