[SOLVED] Remove Entry

[cheechm]

Hi,

I have this code:

                        $item = split(', ', $row['items']);
                        foreach ($item as $value) {
                            $sqli = "SELECT name FROM hire WHERE id = " . $value . "";
                            $resulti = db_query($sqli) or die("MySQL ERROR: " . mysql_error());
                            while ($rowi = db_fetch_array($resulti)) {

                                echo $rowi['name'];
                            }

                        }

 

Lets say I get for $value: 2, 2, 3, 4

You can see there is two "2"s. How do I remove one of them?

So the MySQL query only checks, 2, 3, 4?

Thanks

[wildteen88]

array_unique

[DarkWater]

Or:

 

SELECT DISTINCT name FROM hire WHERE id = $value;

 

You shouldn't have repeating data in the first place though.

[cheechm]

Or:

 

SELECT DISTINCT name FROM hire WHERE id = $value;

 

You shouldn't have repeating data in the first place though.

 

Why not? I might need it.

 

Thanks guys.