Urgent Help For Looping 2 Columns

please can someone help with this

[amwd07]

I must be missing something simple

here is my page of code the important one here is $directory .= ""; I have tried placing the Dreamweaver Toolbox looper here but this did not work it seems I can't have php coding here this is why I have had to have varibles ie. $company

<?php require('include/connection.php');
require('include/functions.php');

$site_title = "Made In Shropshire Demo Site";
$page_title = "Directory";

$query="SELECT * FROM members";
$makers=mysql_query($query);
$num=mysql_numrows($makers);
mysql_close();

/////////////////////////////////////////////////////////

$i=0;
while ($i < $num) {
$user_id=mysql_result($makers,$i,"user_id");
$company=mysql_result($makers,$i,"company");
$town=mysql_result($makers,$i,"town");
$telephone=mysql_result($makers,$i,"telephone");
$profile_image=mysql_result($makers,$i,"profile_image");

$directory .= "<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center>$company</div></td>
</tr>
<tr>
<td height=21><div align=center>$town ¦ $telephone</div></td>
</tr>
<tr>
<td height=100><div align=center>$profile_image</div></td>
</tr>
</table></td>
</tr>
</table>";

$i++; }

require('include/template_includes.php');?>

///////////////////////////////////////////////////////////

Also I have tried the following using includes
I can get the looping to work but not the varibles $company etc.

$directory = get_include_contents('contents.php');

[SixTimesEight]

I don't know anything about Dreamweaver, but you definitely need to declare $directory as blank before you start appending to it with the .= operator.

Add the blank declaration before your while loop like so:

$i=0;
$directory = '';
while ($i < $num) { 

[Habtom]

First try comment out the mysql_close(), you still haven't finished using the connection.

//mysql_close();

If that doesn't solve it, please post the error it displays (if any).

[amwd07]

Sorry I think your not understanding what I'm trying to do here, here is what is already happening I just need them in to columns the directory should not be blank as it contains the layout and varibles for the directory all I need is an extra column I have seen several tutorials to do this but none of which works inside this varible $directory .="layout & vars go here"; it seems to work the one colunn but I need to columns anyone any idea's please
I should of had a demo done for today.

12
34
56
78

[amwd07]

here is th elink to the directory
just need a quick sollution here for 2 columns inside the varible or inside file_get_contents includes

<snip>

[edited by: dreamcatcher at 10:49 am (utc) on Aug. 14, 2007]
[edit reason] no urls as per T.O.S [webmasterworld.com].Thanks [/edit]

[Habtom]

I am completely lost on what you want to achieve, or what the specific problem is. Can you describe it a bit better, what you want to achieve, how you have tried it already and what your problem is.

And the TOS states no URLs are allowed on the threads.

[amwd07]

sorry I thought that ment the code for urls

all I am trying to do is have 2 column layout

1 column works with this loop code
I just need the code for 2 columns

$i=0;
while ($i < $num) {

$directory .="
// layout & code here
";

$i++;
}

[Habtom]

$i=0;
$switch = 0;
$directory .= "<table>
while ($i < $num) {
if ($switch == 0) {
$directory .= "<tr><td>$data</td>";
} else {
$directory .= "<td>$data</td></tr>";
}
$switch == 0?$switch = 1:$switch = 0;
$i++;
}
$directory .= "</table>

Though I know this approach is ok, I want to know how this can be done differently.

[amwd07]

I have tried using your code inserting my layout but there seems to be a problem somewhere as I get a blank screen

$user_id=mysql_result($makers,$i,"user_id");
$company=mysql_result($makers,$i,"company");
$town=mysql_result($makers,$i,"town");
$telephone=mysql_result($makers,$i,"telephone");
$profile_image=mysql_result($makers,$i,"profile_image");

$i=0;
$switch = 0;
$directory .= "<table>"
while ($i < $num) {
if ($switch == 0) {
$directory .= "<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center>$company</div></td>
</tr>
<tr>
<td height=21><div align=center>$town ¦ $telephone</div></td>
</tr>
<tr>
<td height=100><div align=center>$profile_image</div></td>
</tr>
</table></td>
</tr>
</table>";
} else {
$directory .= "<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center>$company</div></td>
</tr>
<tr>
<td height=21><div align=center>$town ¦ $telephone</div></td>
</tr>
<tr>
<td height=100><div align=center>$profile_image</div></td>
</tr>
</table></td>
</tr>
</table>";
}
$switch == 0?$switch = 1:$switch = 0;
$i++;
}
$directory .= "</table>"

include('include/template_includes.php');?>

[amwd07]

ahhhh I missed out the ; on the end of tables works but only shows up 1 column?

[Habtom]

I know I have altered your code to the output may be you didn't want to have, but take a backup of what your code, test the following, and improve it to achieve what is required.

$i=0;
$switch = 0;

$directory = "<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif>
<table width=100% border=0 cellspacing=0 cellpadding=0> "
while ($i < $num) {
if ($switch == 0) {
$directory .= "
<tr><td height=35><div align=center>$company</div><div align=center>$town ¦ $telephone</div><div align=center>$profile_image</div></td>";
} else {
$directory .= "
<td height=35>
<div align=center>$company</div><div align=center>$town ¦ $telephone</div><div align=center>$profile_image</div></td>
</tr>";
}
$switch == 0?$switch = 1:$switch = 0;
$i++;
}
$directory .= "</table>
</td>
</tr> </table>" ;
echo $directory;

[edited by: Habtom at 11:15 am (utc) on Aug. 14, 2007]

[amwd07]

hard to expalin without showing you on this one
but now I have 2 columns which is only using the first entry out of the DB and repeating on every entry
also the background for the layout image is straight across the 2 columns I need the layout image for each entry in 2 columns for example if there our 12 entires
that would be 6 in each column each entry must have the same layout

$i=0;
$switch = 0;

$user_id=mysql_result($makers,$i,"user_id");
$company=mysql_result($makers,$i,"company");
$town=mysql_result($makers,$i,"town");
$telephone=mysql_result($makers,$i,"telephone");
$profile_image=mysql_result($makers,$i,"profile_image");

$directory .= "<table width=260 height=178 valign=top background=images/layout_r2_c1.gif>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>
<table width=100% border=0 cellspacing=0 cellpadding=0>";
while ($i < $num) {
if ($switch == 0) {
$directory .= "
<tr><td height=35><div align=center>$company</div><div align=center>$town ¦ $telephone</div><div align=center>$profile_image</div></td>";
} else {
$directory .= "
<td height=35>
<div align=center>$company</div><div align=center>$town ¦ $telephone</div><div align=center>$profile_image</div></td>
</tr>";
}
$switch == 0?$switch = 1:$switch = 0;
$i++;
}
$directory .= "</table>
</td>
</tr> </table>";
echo $directory;

[Habtom]

I missed a very important point there. I concentrated much on showing you how the table rows can be looped.

On the following code, you need to make sure the right $makers database resource is passed. With this code, you don't need the variable assigning you have in the first few lines of the previous code.

Here it is:

$i=0;
$switch = 0;

$directory .= "<table width=260 height=178 valign=top background=images/layout_r2_c1.gif>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>
<table width=100% border=0 cellspacing=0 cellpadding=0>";
while ($row = mysql_fetch_array($makers)) {
if ($switch == 0) {
$directory .= "
<tr><td height=35><div align=center>$row['company']</div><div align=center>$row['town'] ¦ $row['telephone']</div><div align=center>$row['profile_image']</div></td>";
} else {
$directory .= "
<td height=35>
<div align=center>$row['company']</div><div align=center>$row['town'] ¦ $row['telephone']</div><div align=center>$row['profile_image']</div></td>
</tr>";
}
$switch == 0?$switch = 1:$switch = 0;
$i++;
}
$directory .= "</table>
</td>
</tr> </table>";
echo $directory;

Habtom

[amwd07]

this now returns a blank page

$query="SELECT * FROM members";
$makers=mysql_query($query);
$num=mysql_numrows($makers);

/////////////////////////////////////////////////////////

$i=0;
$switch = 0;

$directory .= "<table width=260 height=178 valign=top background=images/layout_r2_c1.gif>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>
<table width=100% border=0 cellspacing=0 cellpadding=0>";
while ($row = mysql_fetch_array($makers)) {
if ($switch == 0) {
$directory .= "
<tr><td height=35><div align=center>$row['company']</div><div align=center>$row['town'] $row['telephone']</div><div align=center>$row['profile_image']</div></td>";
} else {
$directory .= "
<td height=35>
<div align=center>$row['company']</div><div align=center>$row['town'] $row['telephone']</div><div align=center>$row['profile_image']</div></td>
</tr>";
}
$switch == 0?$switch = 1:$switch = 0;
$i++;
}
$directory .= "</table>
</td>
</tr> </table>";
echo $directory;
mysql_close();

include('include/template_includes.php');?>

[amwd07]

I have been looking for semi colon speech marks for the past hour now can't find anything wrong but still show a blank could there be an error in your code somewhere?

[Habtom]

$query = "SELECT company, town, telephone, profile_image FROM members";
$makers=mysql_query($query);
$switch = 0;
$directory = "<table width=260 height=178 valign=top background=images/layout_r2_c1.gif>
<tr> <td>&nbsp;</td> </tr> <tr> <td> <table width=100% border=0 cellspacing=0 cellpadding=0>";
while ($row = mysql_fetch_array($makers)) {
if ($switch == 0) {
$directory .= "<tr><td height=35><div align=center>". $row['company'] ."</div><div align=center>". $row['town'] ." ". $row['telephone'] ."</div><div align=center>". $row['profile_image'] ."</div></td>";
} else {
$directory .= " <td height=35><div align=center>". $row['company'] ."/div><div align=center>". $row['town'] ." ". $row['telephone'] ."</div><div align=center>". $row['profile_image'] ."</div></td> </tr>";
}
$switch == 0?$switch = 1:$switch = 0;
}
$directory .= "</table></td> </tr> </table>";
echo $directory;

[amwd07]

this seems to show 2 columns but the layout image is behind them all I need this to make it work

<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1"><?php echo $row_makers['company'];?></div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4"><?php echo $row_makers['town'];?></span> ¦ <span class="style4"><?php echo $row_makers['telephone'];?></span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=<?php echo $row_makers['mis_id'];?>"><img src="images/makers/tn/<?php echo $row_makers['profile_image'];?>" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table>

but how do I get the above to work inbetween the $directory .=" {CODE HERE ...} "'

[amwd07]

although I am not allowed to send you a link to my page
here is html output via view source of what I need to achieve for the page layout

<table border="0" align="center" cellpadding="12">
<tr>
<td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">Stevie Walker</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4">Church Stretton</span> ¦ <span class="style4">01743 860012</span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=8"><img src="images/makers/tn/steave_walker.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
<td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">Niki Guy</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4">Shrewsbury</span> ¦ <span class="style4">01743 280961</span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=15"><img src="images/makers/tn/niki_guy.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr><tr> <td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">Sarah Hill Contemporary Glass</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4">Wem</span> ¦ <span class="style4"></span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=14"><img src="images/makers/tn/sarah_hill_contemporary_glass.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
<td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">Dragon Alchemy</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4">Montgomery</span> ¦ <span class="style4">01743 860012</span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=10"><img src="images/makers/tn/dragon_alchemy.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr><tr> <td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">Rose Knits</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4">Telford</span> ¦ <span class="style4">01952 590120</span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=13"><img src="images/makers/tn/rose_knits.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
<td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">Clanbrook Crafts</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4">Shrewsbury</span> ¦ <span class="style4">01743 860012</span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=6"><img src="images/makers/tn/clanbrook_crafts.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr><tr> <td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">Maple Glass</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4">Shrewsbury</span> ¦ <span class="style4">01743 860012</span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=9"><img src="images/makers/tn/maple_glass.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
<td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">I Love Knitting</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4">Shrewsbury</span> ¦ <span class="style4">0781 703 6359</span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=3"><img src="images/makers/tn/iloveknitting.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr><tr> <td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">The Gingham Chicken</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4"></span> ¦ <span class="style4"></span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=17"><img src="images/makers/tn/the_gingham_chicken.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
<td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">Carol Angela Design</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4">Shrewsbury</span> ¦ <span class="style4">0781 703 6359</span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=5"><img src="images/makers/tn/carol_angela_design.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr><tr> <td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">Anthologia</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4">Telford</span> ¦ <span class="style4">01952 541988</span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=16"><img src="images/makers/tn/anthologia.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
<td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">Shrewsbury Makers</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4">Shrewsbury</span> ¦ <span class="style4">01743 289946</span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=12"><img src="images/makers/tn/shrewsbury_makers.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr><tr> <td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">The Whistling Cowgirl</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4">Shrewsbury</span> ¦ <span class="style4">01743 860012</span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=7"><img src="images/makers/tn/the_whistling_cowgirl.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
<td><table border=0 cellspacing=0 cellpadding=0>
<tr>
<td><div align="center" class="style5"><span class="style6">Website: <strong><u>here ...</u></strong></span></div></td>
</tr>
<tr>
<td width=260 height=178 valign=top background=images/layout_r2_c1.gif><table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>
<td height=35><div align=center class="style1">Kilnwood Studio</div></td>
</tr>
<tr>
<td height=21><div align=center><span class="style4">Shifnal</span> ¦ <span class="style4">01952 606265</span></div></td>
</tr>
<tr>
<td height=100><div align=center><a href="directory-details.php?mis_id=11"><img src="images/makers/tn/kilnwood_studio.jpg" border="0"></a></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>

[amwd07]

please I still having problems with this one