this may be very easy to do but I do not even know how to formulate my problem for search engines (google | stackoverflow).
I am trying to create a HTML form based on data from database.
my problem:
I have table with these columns:
- id
- file
- language
- etc...
filled with data (example):
//no < table > here
//only **file** column is really important for my select (that I am asking for)
id | file | lanugage | etc
====================================================================
1 |about.php | english | something
2 |conta.php | english | something
3 |mysql.php | hungar | something
4 |mysql.php | english | something
5 |mysql.php | french | something
6 |blog.php | french | something
after the select I am asking for array should look like this
0 => about.php, 1 => conta.php, 2 => mysql.php, 3 => blog.php
SOLUTION
I was looking for distinct option of SELECT
or
SELECT t1.file as Files
from table as t1 group by Files
well this was fast :) thanks