|
13
874
|
/* We have now connected, unless you got an error message */
/* We now select one news post, and bring it into some text boxes */
$query = "SELECT tittel, nyhet FROM news WHERE id = $_GET['id']";
$result = mysql_query($query);
while($newsss = mysql_fetch_array($result)) {
/* This bit sets our data from each row as variables, to make it easier to display */
$tittel["tittel"];
$nyhet["nyhet"];
/* Now lets display the titles */
echo "<form method=\"post\" action=\"?side=endrenyhet2&id=$_GET[id]\">
<p>Tittel :
<input type=\"text\" name=\"tittel\" value=\"$tittel\">
</p>
<?php
include_once("config.php");
if($logged[username] && $logged[eier] =='1'){
$id = $_GET['id'];
/* We have now connected, unless you got an error message */
/* We now select one news post, and bring it into some text boxes */
$query = "SELECT tittel, nyhet FROM news WHERE id = $id";
$result = mysql_query($query);
while($newsss = mysql_fetch_array($result)) {
/* This bit sets our data from each row as variables, to make it easier to display */
$tittel["tittel"];
$nyhet["nyhet"];
/* Now lets display the titles */
echo "<form method=\"post\" action=\"?side=endrenyhet2&id=$_GET[id]\">
<p>Tittel :
<input type=\"text\" name=\"tittel\" value=\"$tittel\">
</p>
<p>Nyhet :</p>
<p>
<textarea name=\"nyhet\" cols=\"40\" rows=\"6\">".nl2br($nyhet)."</textarea>
</p>
<p>
<input type=\"submit\" name=\"Submit\" value=\"Save\">
</p>
</form>";
}
echo("<br><br><br><br>");
$newss = mysql_query("Select * from news order by id asc");
while($news = mysql_fetch_array($newss))
{
//makes a list of all the users
echo("<a href=\"?side=endrenyhet&id=$news[id]\">$news[tittel]</a><br />");
//displays the user's names
}
}
else
{
}
?>
$query = "SELECT tittel,nyhet FROM news WHERE id='$id'");
// Eller
$query = "SELECT tittel,nyhet FROM news WHERE id='$_GET[id]'");
// Store bokstaver i Queryen her (har egentlig ikke så mye å si)
$newss = mysql_query("SELECT * FROM news ORDER BY id ASC");
$id = mysql_escape_string($_GET['id']);
|
|
TAKK!