what's wrong here?

[raffael3d]

I have one script page, I use isset. first the admin can watch the data stored iin it: everything ok so far:

$result = @mysql_query("SELECT ID,titel,text,url,datum FROM ph24_news");

 echo'<table border="0"><tr>';
 echo '<td colspan="2" height="20" valign="top" class="text3"><font face="verdana" size="2">
<b>Die Einträge der Datenbank:</b></td></tr>';



  while ( $row = mysql_fetch_array($result) ) {
  $id = $row["ID"];
  $titel = $row["titel"];
  $text = $row["text"];
  $url = $row["url"];
  $datum = $row["datum"];
  

then if he hits "edit" the edit page appears where the stored data can be edited.

if (isset($edit)) {
$result = mysql_query("select * from ph24_news where id=$edit");

$id = mysql_result($result, $i, "id");
$titel = mysql_result($result, $i, "titel");
$text = mysql_result($result, $i, "text");
$url = mysql_result($result, $i, "url");
$datum = mysql_result($result, $i, "datum");

but below that the follwing error is shown, why? what can I do?
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource.

[piersk]

Sounds like you're not getting data as a result of your query.

Instead of having

$result = @mysql_query("SELECT ID,titel,text,url,datum FROM ph24_news");

try using

$result = mysql_query("SELECT ID,titel,text,url,datum FROM ph24_news") or die("The query failed");

This will tell you if your query is failing.

[hand]

To get more information, please add the or-statement:

if (isset($edit)) { 
	$result = mysql_query("select * from ph24_news where id=$edit")
		or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";  

$id = mysql_result($result, $i, "id"); 
$titel = mysql_result($result, $i, "titel"); 
$text = mysql_result($result, $i, "text"); 
$url = mysql_result($result, $i, "url"); 
$datum = mysql_result($result, $i, "datum");

[raffael3d]

thanks for the help, altough they all caused other errors.
what is strange that the error I wrote you about is shown, altough it shouldn't be shown: I mean that I have an if and an else statement.
now the error is shown when the if statement is running, altough the code of the error is in the else statement....

[Julian_Pedley]

Sorry, I may be stating obvious;

1. A connect is needed on every page (I think)!

2. Perhaps the first select statement was failing - but you can see because of the error trap - remove the '@'.

Regards

J