Anyywhere I can get ready-populated tables?

Petraverse

Hi there,

Is there anywhere I can get ready-populated tables for
- Day of the month (1 through 31)
- Month of the year (Januar through December)
- Years (1904 to 2004 say)
- Countries (all countries)

It would only take a few minutes to do it for days and months, but is there anywhere I can download a table which alread has years 1904 through 2004 and a table which has all countries in? I ask because I need to make arrays of all this data for my <select> menus in my registration form.

Thanks
Max

tsinka

Hi,

one question:

Do the users select their birthday and the country they live in with these selects ?

At least in case of the birthday (if birthday at all):

Did you already think about using standard text inputs for the values of year, month and day. In the script that receives the data you could then use one of the php functions to check if the submitted birthdate is valid at all. This might be easier than doing it with selects.

Thomas

drawmack

<?php
for($i=1904;$i<2004;$i++) {
    $sql = "INSERT INTO years (year) VALUE ($i)";
    mysql_query($sql);
}?>

What in god's name is so hard about that?

Petraverse

Originally posted by drawmack

What in god's name is so hard about that?

Nothing hard about that. As I said the months/years/days isn't so much of a problem, the countries is another matter.

drawmack

http://www.nationsonline.org/oneworld/countries_of_the_world.htm

then just use curl in conjunction with strpos to trim the html down to nothing but a list of countries and insert that into the database. It shouldn't be more then 10 or 15 lines of code.

Petraverse

Got it, thanks!

Sxooter

If you want some very cool, and fairly large data sets look at the US geological services website. You can find some huge GIS type data there. The FCC has a large set of data on transmitter sites as well.