mysql list to two-column list
| From: | Tom Sparks | Date: | Mon, 19 Mar 2012 22:43:11 +0000 |
| Subject: | mysql list to two-column list | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-317132@lists.php.net to get a copy of this message | ||
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)