Nyhetsscript hjelp

[DanielP]

Trenger hjelp med ett nyhetsscript.

 

Her er SQL en:

 

CREATE TABLE news ( 

id INT (11) not null AUTO_INCREMENT, 

title VARCHAR (50), 

news TEXT , 

author VARCHAR (50) , 

date DATE , 

PRIMARY KEY (id) 

); 

 

Her er Feilen :

Warning: Supplied argument is not a valid MySQL result resource in /mnt/home3/d/da/danlinux/public_html/edit_process_include.php on line 11

 

Her er PHPen:

 

include "config.php"; 



$db = mysql_connect($db_host,$db_user,$db_pass); 

mysql_select_db ($db_name) or die ("Cannot connect to database"); 

/* 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 title, news FROM news WHERE id = $_GET[id]"; 

$result = mysql_query($query); 

while($r=mysql_fetch_array($result)); <--------- Dette er line 11

{    

/* This bit sets our data from each row as variables, to make it easier to display */ 

$title=$r["title"]; 

$news=$r["news"]; 

/* Now lets display the titles */ 

   echo "<form name="edit_process.php" method="post" action="index.php?Section=edit_save?id=$_GET[id]"> 

 <p>Title : 

   <input type="text" name="title" value="$title"> 

 </p> 

 <p>News :</p> 

 <p> 

   <textarea name="news" cols="40" rows="6">$news</textarea> 

 </p> 

 <p> 

   <input type="submit" name="Submit" value="Save"> 

 </p> 

</form>"; 

} 

mysql_close($db); 

?>

 

Takker for all hjelp

 

DanielP

[Gjest Slettet-rXRozPkg]

Bytt ut linje 10 med dette, og se om du får en feilmelding:

 

$result = mysql_query($query) or die("Feil: ".mysql_error()); 

[[kami]]

WHERE id = $_GET[id]";

 

$_GET[id] ikke er satt.. dermed blir sql'n din ikke korrekt og det er dette som feiler.