php mysql delete fout

[eeyk]

ik kirjg deze error


Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/id02117/domains/crime-ware.nl/public_html/i-photo/manage.php on line 10

dit is een Manage.php file

<?php
include("config.php");


if(isset($_POST['del'])){

$delcode = $_POST['delcode'];
$url = $_POST['url'];

 $delcodes = mysql_fetch_object($query);
 $query = mysql_query("SELECT `delcode` from `last` WHERE `url`='$url'");
				 
if($delcode == $delcodes){
mysql_query("DELETE FROM `last` WHERE `delcode`='$delcode' AND `url`='$url'") or die(mysql_error());
echo "<br><h1>File are Deleting!<br>";
}else{
echo "<br><h1>Error bad code<br></h1>";
}
}
?>
<?
$ip = $_SERVER['REMOTE_ADDR'];
?>
<link rel="stylesheet" type="text/css" href="css-v1.css">
<table border="0" width="100%">
<td>
<b>No Signup Needed You Can Manage u file's here</b></td>
<tr>
<td>
if you see nothing, Then you have no files.<br />
</td>
</tr>
</table>
<table border="1" width="100%">
<tr>
</td>
<tr>
<td><B>You Uploaded File's</b></td>
</tr>
<td><br /><br /><br /></td>
    <?
    $selects = mysql_query("SELECT `url` FROM `last` Where `ip`='$ip'");
    echo "<ol>"; 
    while($list = mysql_fetch_object($selects)) {
    echo "<tr><td><li><b><font color=\"#000000\"> <a href=\"http://crime-ware.nl/i-photo/upload/{$list->url}\" target=\"_blank\">$list->url</a><br></td></tr>"; 
    } 
    echo "</ol>"; 
    ?>
<tr>
<td><b>Delete files</b></td>
</tr>
<tr>
<td>
<form method="POST">
File Name: <input name="url" size="42"><br />
Delete Code: <input name="delcode" size="40"><br />
<input type="submit" name="del" value="Delete File">

</form>
</td>
</tr>
<table>

 

[SvU]

Je hebt wéér niets geleerd van de vorige topics hè? Foutafhandeling in MySQL, ooit van gehoord?

 

[eeyk]

oke jou reactie in

mijn vorige topic

$sQuery = "SELECT";
$rResult = mysql_query($sQuery);

if(!$rResult){

  echo 'Er is een fout opgetreden in de query: <br />' . 
          $sQuery 
          .' met de foutmelding: <br />'.
          mysql_error();

}else{

// Gelukt.

}

wat moet ik hier mee ik weet de fout en als ik dit plaats zeg die gewoon het zelfte


het gaat om dit

$delcodes = mysql_fetch_object($query);
$query = mysql_query("SELECT `delcode` from `last` WHERE `url`='$url'");

 

[Johantrax]

 $delcodes = mysql_fetch_object($query);
 $query = mysql_query("SELECT `delcode` from `last` WHERE `url`='$url'");

Al eens aan gedacht dat $query moet bestaan voordat je er een object kan uit opvragen?