Remove duplicate elements
Posted: Tue Mar 22, 2011 3:07 pm
Hay guys,
So please take a look at the whole script first:
Now what I want to do is to remove the duplicate strings from the long string
and the output of $query = array_unique($queries); is like this:
It seems it's not remove any duplicate strings...why is that
Thanks.
So please take a look at the whole script first:
Code: Select all
$select5 = "SELECT LS_CELL_TYPE FROM link_specificities
INNER JOIN links ON link_specificities.LS_LINK = links.L_ID
WHERE links.L_ID = $LinkID";
$get5 = mysqli_query($connect, $select5) or die(mysqli_error($connect));
while ($row5 = mysqli_fetch_array($get5)){
$cellType = $row5['LS_CELL_TYPE'];
$select6 = "SELECT DISTINCT CT_NAME FROM cell_type WHERE CT_ID = '$cellType'";
$get6 = mysqli_query($connect, $select6) or die(mysqli_error($connect));
while ($row6 = mysqli_fetch_array($get6)){
$queries = array($row6['CT_NAME']);
}
$query = array_unique($queries);
foreach ($queries as $query){
$check = "select first_name, last_name, email from mailing_list WHERE cell like '%$query%'";
echo nl2br($check.PHP_EOL);
update($check);
}
}
and the output of $query = array_unique($queries); is like this:
Code: Select all
select first_name, last_name, email from mailing_list WHERE cell like '%Not Specified%'
select first_name, last_name, email from mailing_list WHERE cell like '%Not Specified%'
select first_name, last_name, email from mailing_list WHERE cell like '%Neuron%'
select first_name, last_name, email from mailing_list WHERE cell like '%Glia Cell%'
select first_name, last_name, email from mailing_list WHERE cell like '%Neuron%'
select first_name, last_name, email from mailing_list WHERE cell like '%Neuron%'
select first_name, last_name, email from mailing_list WHERE cell like '%Neuron%'
select first_name, last_name, email from mailing_list WHERE cell like '%Neuron%'
It seems it's not remove any duplicate strings...why is that
Thanks.