Help With Table?

kbrick

Hi! I'm trying to get a page where a picture shows on the left side of the page, and the results of my query in the right column in separate rows. I'm getting the first result to display correctly, the the subsequent results are trying to go the right of that. Can you help? The page (where you can see what's happening) is at: http://simpleplan4ever.com/DBClass/index2.php

My code at this point is:

$display_block = "
<TABLE WIDTH=\"100%\">

<TR>
<TD width=60% align=left>
<img src=\"store_images/frontpage.jpg\"
</TD>";

if (mysql_num_rows($get_cats_res) < 1) {
$display_block .= "<P><em>Sorry, there are no categories
to browse.</em></p>";

}
else {

while ($cats = mysql_fetch_array($get_cats_res)) {
$cat_id = $cats[id];
$cat_title = strtoupper(stripslashes($cats[cat_title]));
$cat_desc = stripslashes($cats[cat_desc]);

$display_block .=
"<TD width=40% valign=top align=left>
<p><strong><ahref=\"show_in_cat.php?c=$cat_id\">$cat_title</a></strong>
<br>$cat_desc</p><br>";
"</TD>";
}
"</TR>";
//close up the table
$display_block .= "</TABLE>";

}

Huuggee

seems your not really closing the <td> and <tr> tags

display_block .=
"<TD width=40% valign=top align=left>
<p><strong><ahref=\"show_in_cat.php?c=$cat_id\">$cat_title</a></strong>
<br>$cat_desc</p><br>";

after that final <br> tag, i think you want to incude </td></tr>

so the <td width=40%> is closed

you may even need to start the loopp with a <tr> too

kbrick

Thanks! I gave that a try, but it's now displaying below the picture instead of next to it. How do I get that over to the side of the picture? My new code is below.

I really appreciate your helping me!

$display_block = "
<TABLE WIDTH=\"100%\">

	<TR>
	<TD width=60% align=left>
    <img src=\"store_images/frontpage.jpg\"
	</TD>";

if (mysql_num_rows($get_cats_res) < 1) {
$display_block .= "<P><em>Sorry, there are no categories
to browse.</em></p>";

}
else {

 while ($cats = mysql_fetch_array($get_cats_res)) {
    $cat_id = $cats[id];
    $cat_title = strtoupper(stripslashes($cats[cat_title]));
    $cat_desc = stripslashes($cats[cat_desc]);

     $display_block .=
    "<TR>
    <TD width=40% valign=top align=left>
	<p><strong><ahref=\"show_in_cat.php?c=$cat_id\">$cat_title</a></strong>
    <br>$cat_desc</p><br>
    </TD>
	</TR>";
	}
 	//close up the table
$display_block .= "</TABLE>";

Huuggee

you should put your code in [php ] tags to make it asier to read!

i take it what you want is pic on left then all the test on the right?

i think i see what you were trying to do now.

 $display_block .="
<TD width=40% valign=top align=left>
<p><strong><a href=\"show_in_cat.php?c=$cat_id\">$cat_title</a></strong>
<br>$cat_desc</p><br>
</TD>";
}
//close up the table
$display_block .= "</tr></TABLE>";

try that. just put the$cat_? info into a <td> on the side of the image.

also, a point to note is your link code is bad and should have a spce between a and href ie '<a href' otherwise the links will not work

kbrick

Thanks! We're almost there, except now it's displaying all the text in a row rather than in a column. I tried switching the tags around (the TDs and the TRs), but then it placed all the text below the picture again. Here's your code with a minor adjustment & the result:

 $display_block .=
 "<td valign=top align=left><p><strong><a
 href=\"show_in_cat.php?c=$cat_id\">$cat_title</a></strong>
 <br>$cat_desc</p></td>";
 }
 //close up the table
 $display_block .= "</tr></table>";

http://simpleplan4ever.com/DBClass/index5.php

....and here's the other where I tried to switch the td/tr tags followed by the result. If I could just combine the two somehow. 🙂

    $display_block .=
    "<td valign=top>
    <tr align=left><p><strong>
    <a href=\"show_in_cat.php?   
     c=$cat_id\">$cat_title</a></strong>
    <br>$cat_desc</p></tr>";
 }

 $display_block .="</td></table>";

http://simpleplan4ever.com/DBClass/index4.php

Huuggee

the easiest wat to do that then, is to hold the lot in one table(main) with 1 row, 2 columns.

left column has a either a new table(left) with the image, or just the image in the <td>

right column has another table(right) in the <td> that has as many rows as you have $cat_? descriptions for.

kbrick

GOT IT! It's at http://simpleplan4ever.com/DBClass/

Here's what I ended up doing:

    $display_block =
    "<table align=left>
    <tr>
    <td rowspan=100><img src=\"store_images/frontpage.jpg\"</td>
    <td valign=top align=left>";


 while ($cats = mysql_fetch_array($get_cats_res)) {
    $cat_id = $cats[id];
    $cat_title = strtoupper(stripslashes($cats[cat_title]));
    $cat_desc = stripslashes($cats[cat_desc]);

    $display_block .="
      <table>
        <tr>
          <td valign=top align=left><strong>
          <a href=\"show_in_cat.php?c=$cat_id\">$cat_title</a></strong>
          <br>$cat_desc</td><br>
          </tr>";
 }
 //close up the table
 $display_block .=
 "

</table>
</td>
</tr>
</table>";

Thanks so much for your help with this!!!

Huuggee

nie one

you only have one thing left....
to clean you code 🙂

you haven;t closed any of the $cat tables properly

it would be best to add it in your section...

 $display_block .="
<table>
<tr>
<td valign=top align=left><strong>
<a href=\"show_in_cat.php?c=$cat_id\">$cat_title</a></strong>
<br>$cat_desc</td>
</tr></table>";
}

that will close them properly

kbrick

Gotcha!! Thanks so much again!