Re: mysql list to two-column list

please delete me --- tom_a_sparks "It's a nerdy thing I like to do" Please use ISO approved file formats excluding Office Open XML - http://www.gnu.org/philosophy/no-word-attachments.html Ubuntu wiki page https://wiki..ubuntu.com/tomsparks 3 x (x)Ubuntu 10.04, Amiga A1200 WB 3.1, UAE AF 2006 Premium Edition, AF 2012 Plus Edition, Sam440 AOS 4.1.2, Roland DXY-1300 pen plotter, Cutok DC330 cutter/pen plotter Wanted: RiscOS system, GEOS system (C64/C128), Atari ST, Apple Macintosh (6502/68k/PPC only) --- On Tue, 20/3/12, Tom Sparks <tom_a_sparks@yahoo.com.au> wrote: > From: Tom Sparks <tom_a_sparks@yahoo.com.au> > Subject: Re: [PHP] mysql list to two-column list > To: ash@ashleysheridan.co.uk > Cc: "php-general" <php-general@lists.php.net> > Received: Tuesday, 20 March, 2012, 10:41 AM > --- On Tue, 20/3/12, Ashley Sheridan > <ash@ashleysheridan.co.uk> > wrote: > > From: Ashley Sheridan <ash@ashleysheridan.co.uk> > Subject: Re: [PHP] mysql list to two-column list > To: "Tom Sparks" <tom_a_sparks@yahoo.com.au> > Cc: "php-general" <php-general@lists.php.net> > Received: Tuesday, 20 March, 2012, 10:15 AM > > > > >   >   > > > On Mon, 2012-03-19 at 16:09 -0700, Tom Sparks wrote: > > --- On Tue, 20/3/12, Ashley Sheridan <ash@ashleysheridan.co.uk> > wrote: > > On Mon, 2012-03-19 at 15:43 -0700, Tom Sparks wrote: > > >>I have a members list witch I print out once a > week, > >>I would like to make the list into two-column list, > but I dont know >>where to start looking to change the > code? > > >>here is the code > >>" > >>$result = mysql_query("SELECT * FROM customers ORDER > BY LastName"); > > >>while($row = mysql_fetch_array($result)) > >>  { > >>  echo $row['LastName']; > >>  echo " " . $row['FirstName']; > >>  echo " " . $row['CustomNo']; > >>  echo "<br />"; > >>  } > >>" > > >>example output: > > >>Bond James 007 > >>Quagmire Glenn 101 > >>Griffin Peter 102 > >>etc > > >>--- > >>tom_a_sparks "It's a nerdy thing I like to do" > >>Please use ISO approved file formats excluding > Office Open XML - > >>http://www.gnu.org/philosophy/no-word-attachments.html > >>Ubuntu wiki page https://wiki.ubuntu.com/tomsparks > > > >How do you mean? > my goal is to do something phonebook like > > In your example, it's a 3-column list (surname, > >forename, customer number) although you've added a > 'cute' field to the >first entry for giggles. It's a > simple thing to join the first two >fields, but what do > you determine to be a single column? > > > > Your reply of 9 words adds no extra information. Rather than > have us all guess what you want, try and tell us > specifically what it is that you want. > > > > >     Cleveland Brown      | Griffin > family >     Cleveland Brown, Jr.  |  Brian > Griffin >     > >