Unable to unlink all images related to topic id

[lovephp]

hey all,

 

  my code here works alright but just that when it comes to deleting a posts its unable to delete all images off the uploads/images folder, it unlink just one image related to the topic whereas i want all images unlinked when i delete the topic

 

$cid =$_REQUEST['cid'];
$tid =$_REQUEST['tid'];
if(isset($_SESSION['signed_in']) && $_SESSION['signed_in'] == true)
{
    $sql="SELECT * FROM posts WHERE post_topic ='".$tid."'";    
    $result = mysql_query($sql);
    if(!$result){
            }else{         
       while($row = mysql_fetch_array($result)){
            if (mysql_num_rows($result)) {
            if(!unlink($row['post_img'])){
            }
            }
    // sending query
    mysql_query("DELETE FROM topics WHERE  topic_id = '".$tid."' AND topic_cat = '".$cid."'")or die(mysql_error());      
    mysql_query("DELETE FROM  posts WHERE  post_topic = '".$tid."'")or die(mysql_error());    
    $result= mysql_query($sql);
            }    
    header("Location: category.php?id=".$cid."");
    }
}else{
    header("Location: category.php?id=".$cid."");
    }

 

appreciate you help.

[lovephp]

Any help?

[ginerjm]

Perhaps because you re-use the $result var inside your loop, thus obviating your check for num rows inside that same loop?

[lovephp]

I dunno but do you think it has to be done with a for loop?

 

Been trying for a long time but unable to get the results it would delete only one image

[ginerjm]

Why not address what I suggested you do before asking more questions?

[lovephp]

i got it sorted code works fine issue was my sql query

 

thanks for your time appreciate it