Column Value Blues

[Heath]

Howdy,

I am really struggling with the basics here.

PHP/MySQL

I have a database with three columns:

ID, Name, Phone

I want to return all the unique items in Name.

My Query is

$result = mysql_query ( "SELECT Name FROM database")

Let's say there are 20 entries. I want to return all twenty entries with
a <br /> between them.

I have tried to use foreach and while with mysql_fetch_row & _array, but
I can't get it to work. Can anyone help?

[Garp]

"Heath" <he*********@belgacom.net> wrote in message
news:40**********************@news.skynet.be...

Howdy,

I am really struggling with the basics here.

PHP/MySQL

I have a database with three columns:

ID, Name, Phone

I want to return all the unique items in Name.

My Query is

$result = mysql_query ( "SELECT Name FROM database")

Let's say there are 20 entries. I want to return all twenty entries with
a <br /> between them.

I have tried to use foreach and while with mysql_fetch_row & _array, but
I can't get it to work. Can anyone help?

Unique items:
$result=mysql_query("SELECT DISTINCT Name FROM table");

Separate data retrieval from presentation - add your <br /> during the
output stage. With apologies to the help for mysql_fetch_array():

while ($row = mysql_fetch_array($result)) {
printf ("Name: %s<br />", $row[0]);
}

Garp