Re: mysql list to two-column list

--- On Tue, 20/3/12, Ashley Sheridan <ash@ashleysheridan.co.uk> wrote: From: Ashley Sheridan <ash@ashleysheridan.co.uk> Subject: Re: [PHP] mysql list to two-column list To: "Tom Sparks" <tom_a_sparks@yahoo.com.au> Cc: "php-general" <php-general@lists.php.net> 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@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. Cleveland Brown | Griffin family Cleveland Brown, Jr. | Brian Griffin