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.