Search data using Array

[[deleted]]

Hi, Is this possible?

Assume that I have connection with MySQL

Question:

I have a dbase (ex. I called it storage) stored in MySQL and have duplicate data.

• After I retrieve "storage", I don't want to have a duplicate data when a user click on the drop down menu.

How can I do this? I've create a search function and stored my Data on an Array, then return 1 if found duplicate else return 0 if none.

Can anyone shares they're knowledge on how to script this? You can have your own code.

Please help, I need this badly...

Thanks...more power PHPBuilder...!

[Anon]

array_unique()
http://www.php.net/manual/en/function.array-unique.php

[[deleted]]

Thanks Devin,

but I do have one question, I finally eliminate those duplicate data but when I tried to view them it display this:
(blank)--indicate blank space!

array("red","blue","red","blue","black")

$my_array = array_unique($array);

$counter = count($my_array);

I used for loop to display my output...

output:

red
blue
(blank)
(blank)
black

How can I eliminate those blank?

Again thanks for any help...and more power to PHPBuilder!

--brendon

[Anon]

I'm not getting any blanks.

<?
$array = array ('red','blue','red','blue','black');
$array = array_unique ($array);
foreach ($array as $key => $value) {
echo "$key : $value<br>";
}
?>

This will output:
2 : red
3 : blue
4 : black

I'm running PHP 4.1.1 on Win32 PWS

[[deleted]]

foreach ($array as $key => $value) {
echo "$key : $value<br>";
}

Why am I not thinking of using foreach, how silly of me,---🙂. I used for loop thats why I end up with blanks display on my screen.

Anyway thanks Devin. It did help me a lot...