Re: mysql list to two-column list

[Ashley Sheridan <ash@xxxxxxxxxxxxxxxxxxxx>]

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.
-- 
Thanks,
Ash
http://www.ashleysheridan.co.uk