Filtering

[Anon]

Another problem I seem to be having is when for example I run an SQL statement to find genre it brings back some of the same e.g the results will bring back:

Downtempo, Downtempo ,Rare Groove, Rare, Groove, Rare Groove, Hip Hop, Funk, Hip Hop HopHip, Rare Groove, Funk, Hip Hop

How can I filter these down so there is only 4 genres?

[Anon]

at the end of your SQL statement stick "LIMIT 4"

Regards, Stezz.

[Anon]

Use

SELECT DISTINCT genre FROM tbl

Diego

[Anon]

Ok, but how would I go about this if I want to call everything from the database including genre

For instance say I want to call:

product_id, type, title, genre, picture etc

How could I go about filtering the genre then?