Column Value Blues

From: Heath (heathweaver_at_belgacom.net)
Date: 05/31/04 

Date: Mon, 31 May 2004 18:05:38 +0200

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?

Relevant Pages

  • Re: Column Value Blues
    ... > PHP/MySQL ... > I have a database with three columns: ... > I want to return all the unique items in Name. ... > Let's say there are 20 entries. ...
    (comp.lang.php)
  • RE: repeated conversion of data summarized into rows and columns
    ... the database name, table name and field names I used in the code. ... Dim currentUser As String ... ' Column Pointer to work through Hour entries ... Dates and to the HoursDates table and containing a usage entry. ...
    (microsoft.public.excel.misc)
  • Re: Multiple Record Inputs with one Form
    ... For intCount = 1 To Me! ... the entries from the form inputed. ... "Jeff Boyce" wrote: ... database will let you do. ...
    (microsoft.public.access.formscoding)
  • Re: Commas in URLs?
    ... > entries are also commonly used for this purpose, ... > used bibliographic database app EndNote has a "URL" field in each entry. ... > the multiple keywords in EndNote Keywords field, ... > delimiter for individual keywords in that field is the comma. ...
    (comp.infosystems.www.authoring.html)
  • New Shareware: MyIdeasJournal version 1.1
    ... MyIdeasJournal is a database program that you can use to capture ... Searching for entries by subject is also very easy and fast. ... listbox item. ... you are either in Search mode or in Browse mode. ...
    (comp.software.shareware.announce)