Maar hij geeft voortdurend een fout aan. kan dit opgelost worden. Zie hieronder mijn code
<?php session_start();
include("inc_logged_in.php");
include ("inc_connect.php");//include settings file
$field = $_GET["live"];
$id = $_SESSION["reqid"];
$field = mysql_real_escape_string($field);
$html = '' ;
$html .= '<select name="developer" id="developer" onchange="assigntodeveloper();">' ;
$html .= '<option value="0">- - Select developer - -</option>';
if(substr($field, 0,1) == "*")
{
$field = substr($field, 1,strlen($field)-1);
$result = mysql_query("SELECT * FROM users WHERE use_surname LIKE \"%$field%\" OR use_firstname LIKE \"%$field%\" ORDER BY use_surname ASC ") or die (mysql_error());
}
else $result = mysql_query("SELECT * FROM users WHERE use_surname LIKE \"$field%\" OR use_firstname LIKE \"$field%\" ORDER BY use_surname ASC ") or die (mysql_error());
$query = mysql_query("SELECT * FROM requirements WHERE req_id='$id'") or die (mysql_error());
$rowass= mysql_fetch_array($query) ;
if($_SESSION['editcon'] == "true")
{
//een lus om de gamma's in een listbox te stoppen
while($rowassto = mysql_fetch_array($result))
{ $surname=mysql_real_escape_string($rowassto['use_surname']);
$firstname = mysql_real_escape_string($rowassto['use_firstname']);
if($_SESSION['assigned2'] == $rowassto['use_id'])
{
$html .= "<option selected=\"selected\" name=\"asstp\" value=\"{$rowassto[use_id]}\">{$surname}{$firstname}</option>" ;
}
else
{
$html .= "<option name=\"asstp\" value=\"{$rowassto[use_id]}\">{$surname}{$firstname}</option>" ;
}
}
}
else
{
//een lus om de gamma's in een listbox te stoppen
while($rowassto = mysql_fetch_array($result))
{
if($rowass['use_id_assigned'] == $rowassto['use_id'])
{
$html .= "<option selected=\"selected\" name=\"asstp\" value=\"{$rowassto[use_id]}\">{$surname}{$firstname}</option>" ;
}
else
{
$html .= "<option name=\"asstp\" value=\"{$rowassto[use_id]}\">{$surname}{$firstname}</option>" ;
}
}
}
$html .= "</select>" ;
?>
html=document.getElementById('assignto');
html.innerHTML='<?php echo($html); ?>';