problem in recorset that seems temporary

Ruprecht Helms <rhelms@xxxxxxxxxxxx> · Fri, 25 Jan 2008 17:35:59 +0100

Hi,

I have a problem that confuse me a little bit. When I want to delete a
picture by giving the id-value in the URL I get the following error:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL
result resource in
/opt/lampp/htdocs/pferdeservice_karle/galerie_delete.php on line 81

On clicking the relodebutton on the browser I get no error and the
deletion of the recordset seems to be not executed. When I don't reload
the page and change to view the pictureresults the recordset have been
deleted. But I don't know why I get the warning-message.

Attached the code.

Regards,
Ruprecht
http://www.rheyn.de

----------------------------------------------------

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd";>
<html>

<head>
  <title></title>
  <meta name="GENERATOR" content="Quanta Plus">
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<style type="text/css">
a:link { color:#FF0000;
font-family:Arial,Helvetica,Verdana,Sans-serif;font-size:9pt;
font-weight:bold;text-decoration:none;}
a:visited { color:#CC340A;
font-family:Arial,Helvetica,Verdana,Sans-serif;font-size:9pt;
font-weight:bold;text-decoration:none;}
a:active { color:#FFCC00;
font-family:Arial,Helvetica,Verdana,Sans-serif;font-size:9pt;
font-style:italic; font-weight:bold;text-decoration:none;}
a:hover { color:#FF9900;
font-family:Arial,Helvetica,Verdana,Sans-serif;font-size:9pt;
font-weight:bold;text-decoration:none;}
td { color:#000000; font-family:Arial,Helvetica,Verdana,Sans-serif;
font-size:9pt;font-weight:plain;}
h2 { color:#000000; font-family:,Helvetica,Verdana,Sans-serif;
font-size:12pt; font-weight:bold;}
h4 { color:#FFFFFF; font-family:Arial,Helvetica,Verdana,Sans-serif;
font-size:10pt; line-height:12pt; font-weight:bold;}
h1 {
	color:#444444;
	margin-top:1em;
	font-size: 1.4em;
	font-weight: bold;
}
body{
	text-align:center;
	background-color:#F0F0F0;
	font-family:Verdana, Geneva, Arial, Helvetica, sans-serif;
	font-size:0.78em;
}
</style>
<body>
<table>
  <tbody>
    <TR>
      <TD bgcolor="#dddddd">

<table height="780" width="200" align="center"><TR><TD>
<table width="80%" align="center" style="border-bottom-color : #ffffff;
border-left-color : #ffffff; border-right-color : #ffffff;
border-spacing : 10px; border-top-color : #ffffff;">
  <tbody>
    <TR>
      <TD width="200" bgcolor="#f0f0f0"><h2>Bildergalerie</h2>
	<A href="galerie_zeigen.php">Galeriebilder zeigen</A>
	<A href="galerie_add_neu.php">Galeriebild hinzuf&uuml;gen</A><br>
	<A href="galerie_update.php">Galeriebild aktualisieren</A><br>
	</TD>
    </TR>
    <tr>
      <td bgcolor="#f0f0f0"><h2>Quicklinks</h2>
<A href="springpferde_zeigen.php">Springpferde</A>
<A href="dressurpferde_zeigen.php">Dressurpferde</A><br>
FAQ

</td>
    </tr>
    <tr>
      <td bgcolor="#f0f0f0"><h2>News</h2>
	<A href="news_zeigen.php">News zeigen</A></A><br>
	<A href="news_add0.php">News hinzuf&uuml;gen</A><br>
	News bearbeiten<br>
	News l&ouml;schen
</td>
    </tr>
  </tbody>
</table>

</TD></TR></table>

</TD>
      <td valign="top">
<h1 align="left">Galerie l&ouml;schen</h1>
<?
mysql_connect("localhost","root");

$result=mysql_db_query("pferdeservice-karle","SELECT * FROM Galerie
WHERE ID=$id");

$zahl = mysql_num_rows($result);
echo "Zahl vorhandener Bilder ".$zahl;
echo mysql_error();

while($row = mysql_fetch_object($result))
{
	$galerie_id=$row->ID;
	$result=mysql_db_query("pferdeservice-karle","DELETE FROM
Galerie_kultur WHERE GalerieID=$id");
}
$result=mysql_db_query("pferdeservice-karle","DELETE FROM Galerie WHERE
ID=$id");
echo mysql_error();
?>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php