Originally posted by Weedpacket
What are the last few lines of PHP before line 71? It looks like there's something wrong there which left PHP expecting something different from what it saw, and got confused.
ok! here is the complete thing:
<?php require_once('../Connections/lokalen.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}
if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE lokal_goralista SET lokal_gora_klar=%s, lokal_gora_rubrik=%s, lokal_gora_beskrivning=%s, lokal_gora_vem=%s, lokal_gora_senast=%s, lokal_gora_avs=%s, lokal_gora_visa=%s WHERE lokal_gora_id=%s",
GetSQLValueString(isset($HTTP_POST_VARS['lokal_gora_klar']) ? "true" : "", "defined","'Y'","'N'"),
GetSQLValueString($HTTP_POST_VARS['lokal_gora_rubrik'], "text"),
GetSQLValueString($HTTP_POST_VARS['lokal_gora_beskrivning'], "text"),
GetSQLValueString($HTTP_POST_VARS['lokal_gora_vem'], "text"),
GetSQLValueString($HTTP_POST_VARS['lokal_gora_senast'], "text"),
GetSQLValueString($HTTP_POST_VARS['lokal_gora_avs'], "text"),
GetSQLValueString($HTTP_POST_VARS['lokal_gora_visa'], "int"),
GetSQLValueString($HTTP_POST_VARS['lokal_gora_id'], "int"));
mysql_select_db($database_lokalen, $lokalen);
$Result1 = mysql_query($updateSQL, $lokalen) or die(mysql_error());
}
$colname_gora_mecka = "1";
if (isset($HTTP_GET_VARS['lokal_gora_id'])) {
$colname_gora_mecka = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['lokal_gora_id'] : addslashes($HTTP_GET_VARS['lokal_gora_id']);
}
mysql_select_db($database_lokalen, $lokalen);
$query_gora_mecka = sprintf("SELECT * FROM lokal_goralista WHERE lokal_gora_id = %s ORDER BY lokal_gora_id ASC", $colname_gora_mecka);
$gora_mecka = mysql_query($query_gora_mecka, $lokalen) or die(mysql_error());
$row_gora_mecka = mysql_fetch_assoc($gora_mecka);
$totalRows_gora_mecka = mysql_num_rows($gora_mecka);
mysql_select_db($database_lokalen, $lokalen);
$query_vannerna = "SELECT lokal_user_name FROM lokal_users";
$vannerna = mysql_query($query_vannerna, $lokalen) or die(mysql_error());
$row_vannerna = mysql_fetch_assoc($vannerna);
$totalRows_vannerna = mysql_num_rows($vannerna);
?>
<html>
<head>
<title>redigera att-göra</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#6699CC">
<form method="post" name="form1" action="<?php echo $editFormAction; ?>">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Lokal_gora_klar:</td>
<td><input type="checkbox" name="lokal_gora_klar" value="" <?php if (!(strcmp($row_gora_mecka['lokal_gora_klar'],"Y"))) {echo "checked";} ?>>
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Lokal_gora_rubrik:</td>
<td><input type="text" name="lokal_gora_rubrik" value="<?php echo $row_gora_mecka['lokal_gora_rubrik']; ?>" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right" valign="top">Lokal_gora_beskrivning:</td>
<td>
<textarea name="lokal_gora_beskrivning" cols="50" rows="5"><?php echo $row_gora_mecka['lokal_gora_beskrivning']; ?></textarea>
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Lokal_gora_vem:</td>
<td>
<select name="lokal_gora_vem">
<?php
do {
?>
<option value="<?php echo $row_vannerna['lokal_user_name']?>"<?php if (!(strcmp($row_vannerna['lokal_user_name'], "$row_gora_mecka[\'lokal_gora_vem\']"))) {echo "SELECTED";} ?>><?php echo $row_vannerna['lokal_user_name']?></option>
<?php
} while ($row_vannerna = mysql_fetch_assoc($vannerna));
$rows = mysql_num_rows($vannerna);
if($rows > 0) {
mysql_data_seek($vannerna, 0);
$row_vannerna = mysql_fetch_assoc($vannerna);
}
?>
</select>
</td>
<tr valign="baseline">
<td nowrap align="right">Lokal_gora_senast:</td>
<td><input type="text" name="lokal_gora_senast" value="<?php echo $row_gora_mecka['lokal_gora_senast']; ?>" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Lokal_gora_visa:</td>
<td><input <?php if (!(strcmp($row_gora_mecka['lokal_gora_visa'],1))) {echo "checked";} ?> type="checkbox" name="checkbox" value="checkbox">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="ändra göra!">
</td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form1">
<input type="hidden" name="lokal_gora_id" value="<?php echo $row_gora_mecka['lokal_gora_id']; ?>">
<input name="hiddenField" type="hidden" value="<?php echo $name?>">
</form>
<p> </p>
</body>
</html>
<?php
mysql_free_result($gora_mecka);
mysql_free_result($vannerna);
?>