Nested table layout for mysql results

[fearless1]

Can anyone please help me with a layout issue. I want to create one large table 3 rows by 3 columns, and in each cell I want to display another table which will hold the results from a mysql query using php. Any idea's?

[Gh0sT]

Hi,

you need to be a bit more specific in what you want exactly..

Something like this, perhaps?

<?
$username="database_username";
$password="database_password";
$database="your_database";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM contacts";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

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

$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");
$info=mysql_result($result,$i,"info");
$comment=mysql_result($result,$i,"comment");

$i++;
}
?>

<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1" align="right">
  <tr>
    <td width="33%" style="padding: 5">
    <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
      <tr>
        <td width="100%" align="center"><? echo $first; ?>&nbsp;</td>
      </tr>
    </table>
    </td>
    <td width="33%" style="padding: 5">
    <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber3">
      <tr>
        <td width="100%" align="center"><? echo $phone; ?>&nbsp;</td>
      </tr>
    </table>
    </td>
    <td width="34%" style="padding: 5">
    <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber4">
      <tr>
        <td width="100%" align="center"><? echo $web; ?>&nbsp;</td>
      </tr>
    </table>
    </td>
  </tr>
  <tr>
    <td width="33%" style="padding: 5">
    <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber5">
      <tr>
        <td width="100%" align="center"><? echo $last; ?>&nbsp;</td>
      </tr>
    </table>
    </td>
    <td width="33%" style="padding: 5">
    <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber6">
      <tr>
        <td width="100%" align="center"><? echo $mobile; ?>&nbsp;</td>
      </tr>
    </table>
    </td>
    <td width="34%" style="padding: 5">
    <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber7">
      <tr>
        <td width="100%" align="center"><? echo $info; ?>&nbsp;</td>
      </tr>
    </table>
    </td>
  </tr>
  <tr>
    <td width="33%" style="padding: 5">
    <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber8">
      <tr>
        <td width="100%" align="center"><? echo $email; ?>&nbsp;</td>
      </tr>
    </table>
    </td>
    <td width="33%" style="padding: 5">
    <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber9">
      <tr>
        <td width="100%" align="center"><? echo $fax; ?>&nbsp;</td>
      </tr>
    </table>
    </td>
    <td width="34%" style="padding: 5">
    <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber10">
      <tr>
        <td width="100%" align="center"><? echo $comment; ?>&nbsp;</td>
      </tr>
    </table>
    </td>
  </tr>
</table>

Greets,
Gh0sT

[fearless1]

More like this:

<?
$username="database_username";
$password="database_password";
$database="your_database";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM contacts";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

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

$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");
$info=mysql_result($result,$i,"info");
$comment=mysql_result($result,$i,"comment");

$i++;
}
?>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1" align="right">
<tr>
<td width="33%" style="padding: 5">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
<tr>
<td width="100%" align="center"><? echo $first,$last ?></td>
</tr>
<tr>
<td align="center"><? echo $phone; ?></td>
</tr>
<tr>
<td align="center"><? echo $web; ?></td>
</tr>
</table>
</td>
<td width="33%" style="padding: 5">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
<tr>
<td width="100%" align="center"><? echo $first,$last ?></td>
</tr>
<tr>
<td align="center"><? echo $phone; ?></td>
</tr>
<tr>
<td align="center"><? echo $web; ?></td>
</tr>
</table>
</td>
<td width="34%" style="padding: 5">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
<tr>
<td width="100%" align="center"><? echo $first,$last ?></td>
</tr>
<tr>
<td align="center"><? echo $phone; ?></td>
</tr>
<tr>
<td align="center"><? echo $web; ?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="33%" style="padding: 5">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
<tr>
<td width="100%" align="center"><? echo $first,$last ?></td>
</tr>
<tr>
<td align="center"><? echo $phone; ?></td>
</tr>
<tr>
<td align="center"><? echo $web; ?></td>
</tr>
</table>
</td>
<td width="33%" style="padding: 5">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
<tr>
<td width="100%" align="center"><? echo $first,$last ?></td>
</tr>
<tr>
<td align="center"><? echo $phone; ?></td>
</tr>
<tr>
<td align="center"><? echo $web; ?></td>
</tr>
</table>
</td>
<td width="34%" style="padding: 5">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
<tr>
<td width="100%" align="center"><? echo $first,$last ?></td>
</tr>
<tr>
<td align="center"><? echo $phone; ?></td>
</tr>
<tr>
<td align="center"><? echo $web; ?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="33%" style="padding: 5">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
<tr>
<td width="100%" align="center"><? echo $first,$last ?></td>
</tr>
<tr>
<td align="center"><? echo $phone; ?></td>
</tr>
<tr>
<td align="center"><? echo $web; ?></td>
</tr>
</table>
</td>
<td width="33%" style="padding: 5">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
<tr>
<td width="100%" align="center"><? echo $first,$last ?></td>
</tr>
<tr>
<td align="center"><? echo $phone; ?></td>
</tr>
<tr>
<td align="center"><? echo $web; ?></td>
</tr>
</table>
</td>
<td width="34%" style="padding: 5">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
<tr>
<td width="100%" align="center"><? echo $first,$last ?></td>
</tr>
<tr>
<td align="center"><? echo $phone; ?></td>
</tr>
<tr>
<td align="center"><? echo $web; ?></td>
</tr>
</table>
</td>
</tr>
</table>

so that each instance of $name etc appears as the next one in the database.
I am sorry about the crudness of this layout but i really have no idea how to do this, i have been playing around with many different methods that don't work, this way at least demonstrates what i am trying to achieve.

Many thanks - Jo