Hvad er der galt her??
Jeg har et skript der indholder følgende data:<? require(\"../settings.htm\"); ?>
<?
if ($Submit == \"Update\") {
$conn_id = mysql_connect($dbserver,$dbuser,$dbpass);
mysql_select_db($dbase);
$res_id = mysql_query(\"UPDATE $table SET title=\'$title\',text=\'$text\' WHERE newsid=\'$newsid\'\");
mysql_close($conn_id);
Header(\"Location: $adminloc\");
}
if ($Modify)
$conn_id = mysql_connect($dbserver,$dbuser,$dbpass);
mysql_select_db($dbase);
$query = \"SELECT * FROM $table WHERE newsid=\'$newsid\'\";
$res_id = mysql_query($query,$conn_id);
while($row = mysql_fetch_array($res_id)){
$date = $row[\"date\"];
$author = $row[\"author\"];
$title = $row[\"title\"];
$text = $row[\"text\"];
print \"<html>
<head>
<title>Condat\'s News Administration (Modify)</title>
<meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html; charset=iso-8859-1\\\">
</head>
<body bgcolor=\\\"#FFFFFF\\\" text=\\\"#000000\\\" background=\\\"../../images/backgrnd.gif\\\">
<table width=\\\"100%\\\" border=\\\"0\\\">
<tr>
<td><font size=\\\"5\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\"><b>Condat
A/S - News Administration (Modify)</b></font></td>
</tr>
</table>
<table width=\\\"100%\\\" border=\\\"0\\\">
<tr>
<td> </td>
</tr>
</table>
<table width=\\\"100%\\\" border=\\\"0\\\">
<tr>
<td>
<form name=\\\"form1\\\" method=\\\"post\\\" action=\\\"modify.htm\\\">
<input type=\\\"hidden\\\" name=\\\"newsid\\\" value=\\\"$newsid\\\">
<table width=\\\"100%\\\" border=\\\"0\\\">
<tr>
<td width=\\\"12%\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">Date:</font></td>
<td width=\\\"88%\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\"><B>$date</B></font></td>
</tr>
<tr>
<td width=\\\"12%\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">Author:</font></td>
<td width=\\\"88%\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">
<select name=\\\"author\\\">
<option value=\\\"$author\\\">$author</option>
</select>
</font></td>
</tr>
<tr>
<td width=\\\"12%\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">
</font></td>
<td width=\\\"88%\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">
</font></td>
</tr>
<tr>
<td width=\\\"12%\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">Password:</font></td>
<td width=\\\"88%\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">
<input type=\\\"password\\\" name=\\\"password\\\" size=\\\"30\\\" maxlength=\\\"30\\\">
</font></td>
</tr>
<tr>
<td width=\\\"12%\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">Title:</font></td>
<td width=\\\"88%\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">
<input type=\\\"text\\\" name=\\\"title\\\" size=\\\"90\\\" maxlength=\\\"255\\\">
</font></td>
</tr>
<tr>
<td width=\\\"12%\\\" valign=\\\"top\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">Body:</font></td>
<td width=\\\"88%\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">
<textarea name=\\\"text\\\" cols=\\\"90\\\" rows=\\\"15\\\"></textarea>
</font></td>
</tr>
<tr>
<td width=\\\"12%\\\" height=\\\"21\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">
</font></td>
<td width=\\\"88%\\\" height=\\\"21\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">
</font></td>
</tr>
<tr>
<td width=\\\"12%\\\"><font size=\\\"3\\\" face=\\\"Verdana, Arial, Helvetica, sans-serif\\\">
</font></td>
<td width=\\\"88%\\\">
<input type=\\\"submit\\\" name=\\\"Submit\\\" value=\\\"Update\\\">
<input type=\\\"reset\\\" name=\\\"Submit2\\\" value=\\\"Reset\\\">
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<p> </p>
</body>
</html>\";
mysql_close($conn_id);
}
?>
------------------
Og når jeg aktiverer det, får jeg følgende besked:
Warning: Supplied argument is not a valid MySQL-Link resource in C:\\apache\\htdocs\\admin\\news\\modify.htm on line 16
Warning: Supplied argument is not a valid MySQL result resource in C:\\apache\\htdocs\\admin\\news\\modify.htm on line 17
Hvad kan der være galt??
