Tables not aligning within .php

ladysniper · May 27, 2006

I'm having a HORRIBLE time getting my tables to align after a search. Can anyone look at this code and see just what is wrong with it? To get the search results...go to www.azsoma.info/directory.htm and type 86336 in the zip box and you will get the results.php page. It's got to be in the .php coding itself somewhere, but I cannot for the life of me find it. Any help would be GREATLY appreciated!

[code]
<html>
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
 <title>Directory Search Results</title>
 </head>

<body bgcolor="#000000">
<div align="center">

<table width="800" border="1" cellpadding="0" cellspacing="0" height="100%">
<table width ="800" border="1" cellpadding="0" cellspacing="0" height="15%>

 <tr>
 <td width="4"></td><td valign="top" align="center" height="19%">
 <img border="0" src="images/header3.gif" width="800" height="150"></td></tr></table>

 <table width ="800" border="1" cellpadding="0" cellspacing="0" height="10%">
<tr>
 <td width ="800" height="19" bgcolor="e1d7a4" valign="top" align="center">

 
 
<a href="/index.htm">Home</a>
 
<a href="application.htm">Member Application</a>

<a href="/membership.htm">Member Benefits/Products</a>

<a href="/directory.htm">Member Directory</a>

<a href="/news.htm">Announcements/News/Links</a></td></tr></table>

<table width="800" border="1" cellpadding="0" cellspacing="0" align="center">
<tr>
 <td border="0" valign="top" align="center" colspan="3"><img src="/images/qi-gong2_11.jpg" width="800" height="35" alt=""></td></tr>
 <tr>
 <td valign="top" align="right"> <img src="/images/qi-gong2_12.jpg" width="80" height="41" alt=""></td>
 <td valign="top" align="center"> <img src="/images/qi-gong2_13.jpg" width="599" height="41" alt=""></td>
 <td valign="top" align="center"> <img src="/images/qi-gong2_14.jpg" width="121" height="41" alt=""></td></tr></table>

<table width = "800" border ="1" cellpadding="0" cellspacing="0" align="center" background="images/qi-gong2_16.jpg">
 <form method="post" action="http://azsoma.info/results.php">

 










 <tr>

<?php
//print_r($_POST);
//echo " \n";

 $hostname = "db353.perfora.net"; // The Thinkhost DB server.
 $username = "dbo161766556"; // The username you created for this database.
 $password = "f5BAQ6HB"; // The password you created for the username.
 $usertable = "Members"; // The name of the table you made.
 $dbName = "db161766556"; // This is the name of the database you made.

 MYSQL_CONNECT($hostname, $username, $password) OR DIE("DB connection unavailable");
 @mysql_select_db( "$dbName") or die( "Unable to select database");

//error message (not found message)begins
// $XX = "No Record Found, to search again please close this window";

/*+-------------------------------------------------------------------------------------+
 | Query Details Begin: |
 +-------------------------------------------------------------------------------------+
 | Since I don't know if phpForms has a built in search function and I don't have time |
 | to try to decipher how they are storing/retrieving information from the tables, |
 | this is the long way around it but it should work. |
 +-------------------------------------------------------------------------------------+
 | May 2006 - AJM re-edited by RJP |
 +-------------------------------------------------------------------------------------+*/

/*+-------------------------------------------------------------------------------------+
 | First we get all distinct records that have the matching criteria from the search |
 | page (directory.htm) |
 +-------------------------------------------------------------------------------------+
 | Determine which fields they have used: Name, City, Zip - and build the WHERE clause |
 +-------------------------------------------------------------------------------------+*/
 $sql = "SELECT DISTINCT sub_rec_id "
 ." FROM pf_submissions "
 ." WHERE ";

 if($_POST['Name']>"")
 $sql .= " (sub_fld_name LIKE '%name%' AND sub_fld_value LIKE '%". $_POST['Name']. "%') AND ";

 if($_POST['City']>"")
 $sql .= " (sub_fld_name LIKE '%city%' AND sub_fld_value LIKE '%". $_POST['City']. "%') AND ";

 if($_POST['Zip']>"")
 $sql .= " (sub_fld_name LIKE '%zip%' AND sub_fld_value LIKE '%". $_POST['Zip']. "%') AND ";

 $sql .= " 1=1 "
 ." ORDER BY sub_rec_id ASC";

//echo "sql=".$sql." \n";
 $qry = mysql_query($sql);

/*+-------------------------------------------------------------------------------------+
 | Now, if there are any records, we'll step through getting the name first. |
 +-------------------------------------------------------------------------------------+*/
 while($row=@mysql_fetch_array($qry))
 {
 $sqlName = "SELECT sub_fld_value "
 ." FROM pf_submissions "
 ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
 ." AND sub_fld_name = 'Full Name'";
//echo "sqlName=".$sqlName." \n";

 $qryName = mysql_query($sqlName);
 $rowName = @mysql_fetch_row($qryName);
//print_r($rowName);
//print(" \n");

 print(" <tr height='20'><td valign='top'>".$rowName[0]."</td></tr> \n");

 /*+---------------------------------------------------------------------------------+
 | Now, if there are any records, we'll step through getting the office address. |
 +-----------------------------------------------------------------------------------+*/
 $sqlAddress = "SELECT sub_fld_value "
 ." FROM pf_submissions "
 ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
 ." AND sub_fld_name = 'Office Address'";
// echo "sqlAddress=".$sqlAddress." \n";

 $qryAddress = mysql_query($sqlAddress);
 $rowAddress = @mysql_fetch_row($qryAddress);
 print(" <tr height='20' valign='top'><td valign='top'>".$rowAddress[0]."</td></tr> \n");

 /*+-----------------------------------------------------------------------------------+
 | Now, if there are any records, For now we get the Office City. |
 +-------------------------------------------------------------------------------------+*/
 $sqlCity = "SELECT sub_fld_value "
 ." FROM pf_submissions "
 ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
 ." AND sub_fld_name = 'Office City'";
//echo "sqlCity=".$sqlCity." \n";

 $qryCity = mysql_query($sqlCity);
 $rowCity = @mysql_fetch_row($qryCity);
 print(" <tr height='20'><td valign='top'>".$rowCity[0]."</td></tr> \n");

/*+-------------------------------------------------------------------------------------+
 | Now, if there are any records, we'll step through getting the Office zip. |
 | RJP 05/17/06 |
 +-------------------------------------------------------------------------------------+*/
 $sqlZip = "SELECT sub_fld_value "
 ." FROM pf_submissions "
 ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
 ." AND sub_fld_name = 'Office Zip'";
//echo "sqlZip=".$sqlZip." \n";

 $qryZip = mysql_query($sqlZip);
 $rowZip = @mysql_fetch_row($qryZip);
 print(" <tr height='20'><td valign'top'>".$rowZip[0]."</td></tr> \n");

/*+------------------------------------------------------------------------------------+
 | Now, if there are any records, we'll step through getting the Office Phone Number. |
 | RJP 05/17/06 |
 +-------------------------------------------------------------------------------------+*/
 $sqlPhone = "SELECT sub_fld_value "
 ." FROM pf_submissions "
 ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
 ." AND sub_fld_name = 'Office Phone'";
//echo "sqlPhone=".$sqlPhone." \n";

 $qryPhone = mysql_query($sqlPhone);
 $rowPhone = @mysql_fetch_row($qryPhone);
 print(" <tr height='20'><td valign='top'>".$rowPhone[0]."</td></tr> \n");

/*+------------------------------------------------------------------------------------+
 | Now, if there are any records, we'll step through getting the Website. RJP 05/17/06 |
 +-------------------------------------------------------------------------------------+*/
 $sqlWeb = "SELECT sub_fld_value "
 ." FROM pf_submissions "
 ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
 ." AND sub_fld_name = 'Website Address'";
//echo "sqlWeb=".$sqlWeb." \n";

 $qryWeb = mysql_query($sqlWeb);
 $rowWeb = @mysql_fetch_row($qryWeb);
 print(" <tr height='20'><td valign='top'>".$rowWeb[0]."</td></tr> \n");

/*+-------------------------------------------------------------------------------------+
 | Now, if there are any records, we'll step through getting the Birthday? There is no |
 | Birthday record in the pf_submissions table. If it's somewhere else, need to find |
 | it and point this query to that table. For now we get the Office City. |
 +-------------------------------------------------------------------------------------+*/
// $sqlCity = "SELECT sub_fld_value "
// ." FROM pf_submissions "
// ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
// ." AND sub_fld_name = 'Office City'";
//echo "sqlCity=".$sqlCity." \n";

// $qryCity = mysql_query($sqlCity);
// $rowCity = @mysql_fetch_row($qryCity);
// echo " <td>".$rowCity[0]."</td>\n";

 print(" </tr>\n");
 }

//below this is the function for no record!!
 if (!$variable1)
 {
 print ("$XX");
 // echo " </tr>\n";
 }
//end
?> </table>

 </table>

 </div>
 </body>

</html>
[/code]

AndyB · May 27, 2006

This isn't a php problem. It's all caused by the frankly awful html coding you have. Here's a few things that are wrong:

There are immediately consecutive <tr> tags - that won't work.
There are immediately consecutive <table> tags - that won't work
There are orphan elements between <tr> tags - that won't work.
You have an orphan form opening statement (in the wrong place, and no closing element). Looks like a cut'n'paste error to me.

Here's a starter. Change this:
[code] print(" <tr height='20'><td valign'top'>".$rowZip[0]."</td></tr> \n");
[/code]
To this:
[code] print(" <tr'><td valign'top'>".$rowZip[0]."</td></tr>\n");
[/code]

Sign In

Tables not aligning within .php

Recommended Posts

ladysniper

Link to comment

Share on other sites

AndyB

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information