webForumDet fria alternativet

mysql query

0 svar · 104 visningar · startad av Alpha II

Alpha IIMedlem sedan maj 20002 579 inlägg
#1

Varför fungerar inte det här? Variabeln $sida får inget värde...

[%logincheck]
<?php
if(IsSet($stage))
 mysql_query("UPDATE pages SET name = '$rd_name' and dir = '$rd_dir' and rubrik = '$rd_rubrik' and content = '$rd_content' WHERE name = '$sida'");

if(IsSet($s_sida) and IsSet($s_dir)) {
 $sida = mysql_fetch_array("SELECT * FROM sidor WHERE dir = '$s_dir' and name = '$s_sida'");
?>
<form method="get" action="main.php">
<input type="hidden" name="id" value="redigera">
<input type="hidden" name="dir" value="admin">
<input type="hidden" name="stage" value="1">
[%p]
Namn:<br>
<input type="text" name="rd_name" value="<?php echo($sida[name]); ?>"><br>
Katalog:<br>
<input type="text" name="rd_dir" value="<?php echo($sida[dir]); ?>"><br>
Rubrik:<br>
<input type="text" name="rd_rubrik" value="<?php echo($sida[rubrik]); ?>"><br>
Text:<br>
<textarea name="rd_content" rows="6" cols="40"><?php echo(htmlspecialchars($sida[name])); ?></textarea><br>
<input type="submit" value="Spara">
[/%p]
</form>
<?php
}

	echo("<table border=0 cellspacing=1 cellpadding=0>\n");
	echo("<tr><td bgcolor=#C0C0C0><font face=\"verdana, arial\" size=1><b>Katalog/Sida</b></font></td><td bgcolor=#C0C0C0><font face=\"verdana, arial\" size=1><b>Senast uppdaterad</b></font></td></tr>\n");
	$result = mysql_query("SELECT * FROM sidor");
	while($sida = mysql_fetch_array($result)) {
		$datumtid = date($sida[lastmodified]);
		if($sida[name]==$s_sida && $sida[dir]==$s_dir)
			echo("<tr><td bgcolor=#FFFFFF><font face=\"verdana, arial\" size=1>>> <a href=\"main.php?id=redigera&dir=admin&s_sida=".$sida[name]."&s_dir=".$sida[dir]."\">".$sida[dir]."/".$sida[name]."</a></font></td><td bgcolor=#FFFFFF><font face=\"verdana, arial\" size=1>".date("m/d/Y",$sida[lastmodified])."</font></td></tr>\n");
		else
			echo("<tr><td bgcolor=#FFFFFF><font face=\"verdana, arial\" size=1><a href=\"main.php?id=redigera&dir=admin&s_sida=".$sida[name]."&s_dir=".$sida[dir]."\">".$sida[dir]."/".$sida[name]."</a></font></td><td bgcolor=#FFFFFF><font face=\"verdana, arial\" size=1>".date("m/d/Y",$sida[lastmodified])."</font></td></tr>\n");
	}
	echo("</table>\n");
?>
[/%logincheck]

------------------
I have not failed. I´ve just found 10.000 ways that won´t work. // Thomas Edison

Genererad på 371 ms · cache AV · v20260730165559-full.f96bc7eb