The below code produces a 2 column web page that shows in the first column a picture and the 2nd column shows the person's name and address ad a few other things.
What I would like is to change this into a 4 column report with no duplication.
Could somebody help me with this, I'm sure it's simple enough but when your new to programming it all looks difficult.
Thanks for your assistance
Expand|Select|Wrap|Line Numbers
- ..
- <?php require_once('Connections/buddies.php'); ?>
- <?php
- mysql_select_db($database_buddies, $buddies);
- $query_testrecordset = "SELECT id, first_name, last_name, address_1, address_2, city, `state`, zipcode, homeemail,workemail, photo_large FROM contact ORDER BY last_name";
- $testrecordset = mysql_query($query_testrecordset, $buddies) or die(mysql_error());
- $row_testrecordset = mysql_fetch_assoc($testrecordset);
- $totalRows_testrecordset = mysql_num_rows($testrecordset);
- ?>
- <style type="text/css">
- <!--
- .style2 {color: #000000}
- .style3 {font-weight: bold; font-size: 14px; font-family: Arial, Helvetica, sans-serif;}
- .style4 {font-weight: bold; font-size: 10px; font-family: Verdana, Arial, Helvetica, sans-serif color: #CC0000};
- .style5 { font-size: 10px; font-family: Verdana, Arial, Helvetica, sans-serif; color: #0000FF;}
- body {
- background-image: url(images/buddy/gradient23550953.png);
- background-repeat: repeat-x;
- background-attachment: fixed;
- }
- -->
- </style>
- </head>
- <body>
- <p align="left" class="style3">Dive Buddies </p>
- <a href="http://localhost/scuba/index.html">Home</a>
- <a href="http://localhost/scuba/contactinput.php">Add a Dive Buddy,</a>
- <table width="450" height="110" border="2" cellpadding="5" bgcolor="#000000">
- <?php do { ?>
- <tr>
- <td width="79" height="107" bordercolor="#FFFFFF" bgcolor="#000000"><img src="/scuba/images/buddy/<?php echo $row_testrecordset['photo_large']; ?>" alt="<?php echo $row_testrecordset['first_name']; ?>"></td>
- <td width="300" bgcolor="#FFFFFF"><p align="right" class="style3"><span class="style3"><?php echo $row_testrecordset['first_name']; ?> <?php echo $row_testrecordset['last_name']; ?><br>
- <?php echo $row_testrecordset['address_1']; ?> <br>
- <?php echo $row_testrecordset['address_2']; ?> <br>
- <?php echo $row_testrecordset['city']; ?> <?php echo $row_testrecordset['state']; ?><br>
- <?php echo $row_testrecordset['zipcode']; ?></span><br>
- <?php echo $row_testrecordset['homeemail']; ?></span><br>
- <?php echo $row_testrecordset['workemail']; ?></span><br>
- <p align="left" class="style5">Total Dives w/ this buddy: </p>
- <p> </p>
- <p> </p></td>
- </tr>
- <?php } while ($row_testrecordset = mysql_fetch_assoc($testrecordset)); ?>
- </table>
- <a href="http://localhost/scuba/index.html">Home</a>
- <a href="http://localhost/scuba/contactinput.php">Add a Dive Buddy,</a>
- <p><br>
- </p>
- </body></html>
- <?php
- mysql_free_result($testrecordset);
- ?>
- ..