searching sql table (same column) for multiple values

[Lucas13]

Hi out there,
Hard to word exactly what I'm having trouble with here, but I'll have a go- any help is much appreciated!
Basically I want the user to click a link and the database be searched for around 25 values from one column, and then return all the details from each of those rows (and alphabetize them).
Pretty much i have a table full of address details, phone numbers, post codes, etc
and I want to use the post codes as the basis of defined areas.
Therefore, I have lists of the post codes for each area.
I have used url parameters in the past ie searchresult.php?post_code=7655 so i tried putting commas in between values ue searchresult.php?post_code=7655,7654,7652 but obviously this doesn't work... I'm thinking it's going to be a bit more complicated than this..
I'm open to suggestions because I'm totally stuck on this - looking for the easiest way out!
Regards and many thanks, Lucas.

[laserlight]

You could use your current method (though I find it rather messy at times).
$_GET['post_code'] would contain "7655,7654,7652".

This comma separated list of values can then be used in a query, e.g.
SELECT * FROM tablename WHERE colname IN ($GET['post_code']);
though of course you should validate $GET['post_code'] before you use it, in order to prevent SQL injection. If the data needs to be quoted, you also have to quote each item in the list before using it in the query.