Re: mysql list to two-column list

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 Bond 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 > 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) > How do you mean? 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? -- Thanks, Ash http://www.ashleysheridan.co.uk