Really stuck with mysql output and html tables

[webnewone]

Please help!

Hi

OK. Trying to set up a mysql/php backend to a gallery of images. Got everything set up fine. Just one problem. I know its probably real easy but cant find any help on it anywhere!

I want to display the thumbnails in a table with three rows (down) and three columns (across). So far all I've managed to do is show each thumbnail in a table one after the other so that they appear in one large row. How do I modify below so I can put each thumnail in a tidy table data cell in a table measuring 3 by 3?????

$result = mysql_query("SELECT * FROM gallery",$db);

if ($galleryrow = mysql_fetch_array($result)) {

do {
print("<tr><td align=\"center\"><a href=\"".view.".php?item=".$galleryrow["item"]."\">".$galleryrow["thumb"]."</a></td></tr>");

} while ($galleryrow = mysql_fetch_array($result));

} else {

echo "Sorry, no records were found!";

}

[stolzyboy]

try this, there may be parse errors or whatever, didn't test it, but you should catch my drift

<?
$conn = mysql_connect("localhost", "xxxxx", "xxxxxx") or die ("Could not connect to database!");
$db = mysql_select_db("xxxxxx") or die ("Could not select database");
$result = mysql_query("SELECT * FROM gallery",$db);
$i = 1;
?>
<table border="0" cellspacing="5" cellpadding="5" align="center"><tr>
<?
while ($row = mysql_fetch_array($result))
{
$j = $i % 3;
if ($j == 0){
?>
<td width="250" align="center" valign="top">
<a href="view.php?item=<? echo $galleryrow["item"]; ?>"><? echo $galleryrow["thumb"]; ?></a>
</td>
</tr>
<tr>
<?
}
else{
?>
<td width="250" align="center" valign="top">
<a href="view.php?item=<? echo $galleryrow["item"]; ?>"><? echo $galleryrow["thumb"]; ?></a>
</td>
<?
}
$i++;
}
?>
</table>

[webnewone]

WOO HOOOO ! ! !

Thanks!

I wonder, could you explain a little about how this works??

It works perfectly but I'd like to know how.

For instance I don't get how at the first part of the table you open up a td cell (right after the while loop) and close it with two </td> tags?

Also apart from the above there doesn't seem to be any difference between if and else (html).

Could you also point me to any 1st class resources to learn more about php??

Thanks again - I bow to your super skills!

[stolzyboy]

well i open the <table><tr> initially, then hop into the while loop,
after that it is just a matter of math, set $i to 1, then if $j = $i % 3; if that equals 0 do the if statement, since it doesn't it does the else part, making one <td></td>, then increments $i to 2, then does $j = $i % 3;, since that doesn't equal 0, it does the else again, making one <td></td>, but then it goes again after incrementing one to 3, and then $j = $i % 3, does equal 0, it does the if statement where we write the last <td></td>, close the opening <tr>, then start a new <tr> and start the whole process over and over again til there are no results left

[webnewone]

GENIUS!

EVER THOUGHT OF WRITING A BOOK???

What about this . . . .

Dynamic next/prev links are also a problem - I could easily (relatively anyway) set up dynamic text links for next and previous pages using say a variable such as

$limitvalue = $page * $limit - ($limit);

result . . . . query . . . with $limit defined as six rows for example and testing results with if statments to print the next/prev links but how can I add that kind of script into the one you so brilliantly demonstrated to give me dynamic next/prev links. I want to use that code but somehow build into it a next/prev script too!

Any suggestions?

PS ammended that code slightly - got 2x3 table now - still works perfectly!

[stolzyboy]

this would probably take too long to explain and would be hard to explain, i have done this before, but can't seem to find the code to cut and paste to you, but here is a link on how this can be done

http://www.evilwalrus.com/viewcode/467.php

[LiquidCD]

Stolzyboy: Okay, taking a look at your previous posting, I tried the following and here is the page:

http://www.lithuaniangenealogy.org/test/surnametest.php

Errors out on line 100 (last line of file):

Here is all the code:

<title>Surname Database</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<font size="5"><strong></strong></font> 
<table width="670" border="0" align="center">
  <tr> 
    <td>
<div align="center"> <font size="5"><strong></strong></font> 
        <table width="670" border="" align="center" cellpadding="5">
          <tr> 
            <td width="639" height="171" valign="top"> 
              <table width="100%" border="0">
                <tr>
                  <td width="75%" height="154"> 
                    <div align="left"><img src="../databases/images/tree.gif" width="80" height="83" align="left"><font size="5"><strong><em>Surnames</em></strong></font><br>
                      Website/Database design by: <a href="mailto:[e-mail]">Richard 
                      Gostautas</a><br>
                      <br>
                      <center>
                        All databases are copyrighted &copy; 1999-2003 by LGGS. 
                        <br>
                      Commercial use or reproduction in any form is <strong>strictly 
                      prohibited.</strong></center> </div></td>
                  <td width="25%"><div align="center"><img src="../databases/images/hanna.jpg" width="99" height="151"></div></td>
                </tr>
              </table>

        </td>
      </tr>
    </table>
  </div></td>
  </tr>
  <tr> 
    <td height="159"> 
      <center>
        <hr>
        <br>
        <hr width="75%">
        <br>
 <?php 
include("../../includes/lithparishes.inc");
$dbh=@mysql_connect ("$dbhost", "$dbuser", "$dbpass") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("$dbname"); 

$qrySurname__letter = "%";
// Output letters as links: (Ascii range from 65 to 90 are letters A to Z!) 
// Trying to do this automatically without having to resort to hand coding // of every single link
for($x=65;$x<=90;$x++)
{
if ($x==ord($subsel)) echo "<b>".chr($x)."</b>";
else
echo "<a href=\"surnametest.php?letter=".chr($x)."\">".chr($x)."</a> "; 
} 

$letter = $_GET["letter"];
if (isset($letter)) 
{
$qrySurname = "SELECT * FROM surnames WHERE surname LIKE '$letter%'";
} else { 
$qrySurname = "SELECT * FROM surnames ORDER BY surname";
}
$result = mysql_query($qrySurname);
$i = 1;
?>
<TABLE BORDER=1 cellpadding=5 align="center"><tr>
<?
while ($row = mysql_fetch_array($result)) 
{
$j = $i % 30;
if ($j == 0){
?>
<td width="25%" align="center" valign="top">
<A HREF="mailto:<? echo $row["email"]; ?>"><? echo $row["surname"]; ?></a>
</td>
</tr>
<tr>
<?
}
else {
?>
<td width="25%" align="center" valign="top">
<A HREF="mailto:<? echo $row["email"]; ?>"><? echo $row["surname"]; ?></a>
</td></tr>
<?
}
$i++;
{
?>
</table>
      </p>
      <table width="75%" border="0" align="center">
        <tr> 
          <td><div align="center"><a href="#">Top</a> | <a href="../databases/index.html">Back 
              </a>to Database Main Page</div></td>
        </tr>
      </table>
      <p align="center">If you have a database or information that you would like 
        to put into our database, that pertains to Lithuanian genealogy, please 
        contact us at <a href="mailto:[e-mail]">[e-mail]</a></p>

I tried looking to make sure everything is closed out - which it looks to be, but I am thinking there might be something wrong when calling the $row surname and email.

What do you think?

Thanks!

P.S. Want to get the pulling of the information out into 4 columns with a max of 30 rows per column before I begin to pull out valid/nonvalid images.