Re: mysql list to two-column list

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