select in MySQL database

[Anon]

this might sound stupid but what the hell..
ok i'm new with programming with php so i gotta a question.

how do i display in a web aplication all the content of a data base field..
example i gotta a data base that have ID and have NAME..

what i want to do is to display all the ID's the are stored at the database..

is it something like:

$identificacion = mysql_query("SELECT id FROM $table");

but how do i display all the entries in a website??

[nostradamus]

Yuo have to fetch the result (rows) from the resultset. You can do that by using mysq_fetch_row.
To fetch all rows of the resultset you can use while-loop. That shoul look somethin like the following :

while ($row = mysql_fetch_row ($identificacion))
{
echo $row[columnname0].$row[columnname1].$row[columnname2].$row[columnname3];
}

"$row" is an array, every row of the array is one dataset of the result.
With every "mysql_fetch_row" you fetch the next dataset.