Re: mysql list to two-column list

--- 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? --