[nitro4file]

Hi everyone,

i have two little issues,

1. hv got a table with
ID| USER | COUNTRY | DATE | TIME |ect

I querry sql to get list of country to display in a drop down(to be selected later on), so far it's okay but the problem is that i have 6,15, or 20 times same country if there is 20,15,6 users from that country, what i want to do is get only 1 and this regarless of the number of entry for that country, can't figure out what the SQL querry should be. i try group id by hash but no success.

2. Need to display result just before the last result.

i fetch result from sql ORDER BY id DESC, so far it's okay, but what i need is just before the last result, e.g if there is 30 i need 29, 100 i need 99, etc

can you give me an idea how to handle that?

Thanks for your help

Nitro

[mab]

For your first problem, try something like this -
SELECT DISTINCT country FROM table

[nitro4file]

Hi Mab,

I try SELECT DISTINCT but it shows some double or trible entries from some countries particularly those in between other countries e.g

USA>
USA>> Those are shows only 1 USA (thats good)
USA>
CANADA
USA> Those are listed
USA> Those are listed
FRANCE

any idea?

[mab]

...Part 2. I think the 1st version finds the distinct rows in groups in the order they are in the database. Try this with the ORDER BY -

SELECT DISTINCT(country) FROM table ORDER BY country

[nitro4file]

That's work perfectly,

Thanks Buddy, Two thumb up!

Any idea about displaying the entry just before the last entry? Part 1??

Cheers
Nitro

[mab]

Since your results are in an array, I think you can use the end(); statement to set the array pointer to the last element, then prev(); to point to the previous and return the array value to get the record you want.

http://www.php.net/manual/en/function.end.php
http://www.php.net/manual/en/function.prev.php

[Nebulous]

the way i would have build the sql structure is by having a seperate table for each country.

which would look like:

| Country | id |

then in the existing table instead of just using the country, use the ID...

Yes, its a few more lines of codes, but allows you to have more flexibility.

Nebulous.