[RESOLVED] array_unique();

[stonefish]

I am trying to detect if a URL contained in an array (containing many other URL's) is located in a MySQL table (named 'list'). If a URL is already located in the table then i want the element of the array to be set as "". This is the code I am using however some URL's seem to be slipping through. Any suggestions??. The array is also unique so that I dont have the same URL in the array twice.

$link = array_unique($link); ## -- Remove duplicates in array

$sql = ("SELECT url FROM list"); # -- Select all links in the list table
$rs = mysql_query($sql);

$row = mysql_fetch_array($rs);
while($row = mysql_fetch_array($rs)) {
foreach($row as $b){ # - Loop through all records in the list
$x = 0;
foreach ($link as $a) { # - Loop through all links in array
$link[$x] = trim($link[$x]);
if($b == $link[$x]){ # - A match!
$link[$x] = ""; # - If match, make $link blank
}
$x++;
}
}
}

[Stasonis]

Try something more like this.

<?php
$link = array_unique($link); ## -- Remove duplicates in array

$sql = ("SELECT `url` FROM `list`"); # -- Select all links in the list table
$rs = mysql_query($sql);


while($row = mysql_fetch_array($rs)) {
    $url = $row["url"];

foreach ($link as $key => $curr_link) { # - Loop through all links in array
    $curr_link = trim($curr_link);

    if($url == $curr_link){ # - A match!
        $link[$key] = ""; # - If match, make $link blank
    }

    $x++;
}
}
?>

First thing I noticed is that you're calling mysql_fetch_array twice, so you're always gonna skip over the first result returned by the DB. I didn't actually test this code, just kind of eyeballed it so it may be off

[stonefish]

Love your work!

it was always the first URL that slipped through, forgot to mention that

many thanks.

[stonefish]

how do I set this as resolved?

[Stasonis]

On the top of the page there is a Thread Tools menu. Click mark as resolved on this menu