Re: mysql list to two-column list

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxx> wrote:

> From: Tom Sparks <tom_a_sparks@xxxxxxxxxxxx>
> Subject: Re:  mysql list to two-column list
> To: ash@xxxxxxxxxxxxxxxxxxxx
> Cc: "php-general" <php-general@xxxxxxxxxxxxx>
> Received: Tuesday, 20 March, 2012, 10:41 AM
> --- On Tue, 20/3/12, Ashley Sheridan
> <ash@xxxxxxxxxxxxxxxxxxxx>
> wrote:
> 
> From: Ashley Sheridan <ash@xxxxxxxxxxxxxxxxxxxx>
> Subject: Re:  mysql list to two-column list
> To: "Tom Sparks" <tom_a_sparks@xxxxxxxxxxxx>
> Cc: "php-general" <php-general@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxxxxxxxxx>
> 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
>     
> 
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux