Hi, I have script which download rssfeed from the internet. But unfortunately it keep downloading duplicate image to the database. Here is my script <?php require 'database.php'; $url = "http://www.albaldnews.com/rss.php?cat=24"; $rss = simplexml_load_file($url); if($rss) { echo '<h1>'.$rss->channel->title.'</h1>'; echo '<li>'.$rss->channel->pubDate.'</li>'; $items = $rss->channel->item; foreach($items as $item) { $title = $item->title; $link = $item->link; $published_on = $item->pubDate; $description = $item->description; $category = $item->category; $guid = $item->guid; $enclosure = $item->enclosure[0]['url']; $ch = curl_init ("$item->enclosure"); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_BINARYTRANSFER,1); $rawdata=curl_exec ($ch); curl_close ($ch); mysqli_real_escape_string($conn,$item->title); mysqli_real_escape_string($conn,$item->link); mysqli_real_escape_string($conn,$item->pubDate); mysqli_real_escape_string($conn,$item->description); mysqli_real_escape_string($conn,$item->category); $img=mysqli_real_escape_string($conn,$rawdata); $sql = "INSERT INTO feedtable (title,link,pubdate,description,category,image)VALUES ('$item->title','$item->link','$item->pubDate','$item->description','$item-> category','$img')"; $result = mysqli_query($conn, $sql); if ($conn->query($sql) === TRUE) { echo "New record created successfully\n"; } else { echo "Error:\n " . $sql . "<br>" . $conn->error; } } } ?> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php