tammic

From working with MS Access, I knew the setup I had would repeat the same info in column 1 and 2 of my table. All I really wanted to do was setup the table and make sure it worked and then try to figure out how to get the data to flow correctly. With your help, I was able to get it to output the look I wanted. Thank you. I really appreciated the fact that you said it in English and then wrote it out in PHP. It makes it much easier to interpret what you wrote. Next question, how do I get two records per row? I am having a problem finding the correct help because I don't know the correct terminology.

I really appreciate the help. This is all very new to me and your assistance in writing the correct code was very helpful. I will test this today and hopefully it all works. Thanks again.

I am an absolute newby at PHP. This is my first project. Read the PHP/MySQL for Dummies book over and over. Can you tell me what I am missing? This is really driving me nuts. Code is as follows: <?php include("PenInfo.php"); $connection=mysql_connect($host,$user,$password) or die ("Couldn't Connect To Server"); $db=mysql_select_db($database,$connection) or die ("Couldn't Select Database"); $query="SELECT * FROM tblMaterials WHERE(((tblMaterials.StillAvail)='Yes')) ORDER BY tblMaterials.MatSortOrder"; $result=mysql_query($query) or die ("Couldn't Execute Query"); /* Display Results in a Table */ echo "<div id='samptable' align='center' style='width: 794'>"; echo "<table id='matsamp' summary='Examples of natural and dyed woods along with man-made materials used to create your custom hand made pen or pencil' style='border-collapse: collapse; font-family: Tahoma; font-size: 10pt; color: #800000' cellspacing='1'>"; echo "<tr> <td width='295' align='center'> <img alt='{$row['MatName']} Material Sample' src='images/MaterialSamples/{$row['MatPic']}' width='237' height='75'><br> {$row['MatName']}</td> <td width='295' align='center'> <img alt='{$row['MatName']} Material Sample' src='images/MaterialSamples/{$row['MatPic']}' width='237' height='75'><br> {$row['MatName']}</td> </tr>"; echo "</table>"; echo "</div>"; echo "<div id='footer'> <hr style='text-align:center; width:500px; height:1px; color:#800000;'> <p> </p> <p><a href='index.htm'>Home</a> | <a href='gallery.htm'>Gallery</a> | <a href='styles.htm'>Styles</a> | <a href='matsamp1.htm'>Samples</a> | <a href='order.htm'>Order</a> | <a href='contact.htm'>Contact</a> | <a href='about.htm'>About</a> | <a href='faq.htm'>FAQ</a></p> <p><br/>© 2005 Beauty Beneath The Bark All Rights Reserved | <a href='privacy.htm'>Privacy Statement</a> </p> <p> <img src='images/valid-html401.gif' alt='Valid HTML 4.01 Transitional' width='88' height='31'/> </p> </div>"; ?> What I get when I run this is the results at http://www.beautybeneaththebark.com/MaterialSamps.php What it should look very similar to is http://www.beautybeneaththebark.com/matsamp1.htm All assistance is greatly appreciated.