[SOLVED] Function displaying incorrectly

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
facets
Forum Contributor
Posts: 273
Joined: Wed Apr 13, 2005 1:53 am
Location: Detroit

[SOLVED] Function displaying incorrectly

Post by facets »

Hi All,

I have a function that displays a table with dropdown menus and testarea.
Then when the search functions is called the results are displayed at the top of page rather than below.
Any ideas on how to fix this problem?

Sory for the CHUNK of code.. I wasn't sure what to include..

Code: Select all

<?

include "../includes/functions.inc";
include "../includes/common_db.inc";
include("template.inc");

$link_id = db_connect($db_materials);

$tmpl = new Template(".", "keep");
$tmpl->set_file('page', "page.html");
$tmpl->set_var('TITLE', "Australian Self Adhesive Paper Search");
$tmpl->set_block('page', 'header');
$tmpl->pparse('out', 'header');

// Set action Variable

$action = isset($_GET['action']) ? $_GET['action'] : '';
if (isset($_POST['viewRecord'])) {viewPaperSummary($_POST['summaryId']);}
if (isset($_POST['viewFaceStock'])) {view($_POST['stockId']);}
if (isset($_POST['viewAdhesive'])) {viewAdhesives($_POST['adhesiveId']);}
if (isset($_POST['viewLiner'])) {viewLiners($_POST['linerId']);}
if (isset($_POST['searchNow'])) {fnSearchResults();}

function viewSearch() {

echo "\n\n<!-- START EXACT FORM -->\n";
echo "<form method=\"post\" action=\"".$_SERVER['PHP_SELF']."\">\n";
echo "<table class=\"sortable\"><tr class=row1><td width=\"550\" colspan=\"4\"><h3>Search for exact paper</td></tr></table>";
echo "<table class=\"sortable\">\n";

$colloPaperNameTitle = array('Collo Paper Name');
$colloPaperNameFunc = array(searchSAPaperName());
$colloPaperViewRecordType = array('submit');
$colloPaperViewRecordTitle = array('viewRecord');
$colloPaperViewRecordValue = array('View Record');

for($x = 0; $x<count($colloPaperNameTitle); $x++) {
	echo "<tr><td width=\"200px\" colspan=\"2\" valign=\"top\">".$colloPaperNameTitle[$x]."</td>\n";
	echo "<td width=\"200px\" colspan=\"4\">$colloPaperNameFunc[$x]</td>\n\n";
	echo "<td width=50px>\n\n<input class=\"btn\" type=\"".$colloPaperViewRecordType[$x]."\" name=\"".$colloPaperViewRecordTitle[$x]."\" value=\"".$colloPaperViewRecordValue[$x]."\"></td></tr>\n\n";
	}

echo "</table></form><hr>";
echo "<table class=\"sortable\"><tr class=row1><td width=\"550\" colspan=\"4\"><h3>Search criteria</td></tr></table>";
echo "<form method=\"post\" action=\"".$_SERVER['PHP_SELF']."\">\n";
echo "<input type=\"hidden\" name=\"commented\" value=\"set\">\n";
echo "\n\n<!-- START MULRIVALUE FORM -->\n";
echo "<table class=\"sortable\">\n";

$searchColloPaperNameTitle = array('Paper Category','Manufactured Name','Computer Lookup Prefix','Face Stock','Adhesive','Liner','Supplier','Sutability','','','','','','');
$searchColloPaperNameTitle2 = array('','','','','','','','Foil','Bronze','Screen','Yellow Light','Opacity','Ice Bucket','Neck Labels');
$searchColloPaperCheckBox = array('checkbox','checkbox','checkbox','checkbox','checkbox','checkbox','checkbox','checkbox','checkbox','checkbox','checkbox','checkbox','checkbox','checkbox');
$searchColloPaperCheckBoxName = array('paperCategory','manufacturedName','clp','faceStock','','','','','','','','','','');
$searchColloPaperNameFunc = array(listCat(),'textarea','textarea',listFaceStock(),listAdhesive(),listLiner(),listSupplier(),foil(),bronze(),screen(),yellowLight(),opacity(),iceBucket(),neckLabel());

for($x = 0; $x<count($searchColloPaperNameTitle); $x++) {
	echo "<tr><td width=\"150px\" valign=\"top\">".$searchColloPaperNameTitle[$x]."</td>\n";
	echo "<td width=\"150px\" valign=\"top\" align=\"right\">".$searchColloPaperNameTitle2[$x]."</td>\n";
	echo "<td width=\"50px\" align=\"center\"><input type=\"".$searchColloPaperCheckBox[$x]."\" name=\"".$searchColloPaperCheckBoxName[$x]."\" id=\"".$searchColloPaperCheckBoxName[$x]."\" value=\"on\"></td>\n\n";
	echo "<td width=\"50px\">$searchColloPaperNameFunc[$x]</td></tr>\n\n";
	}
	
echo "<tr><td align=\"right\" colspan=\"4\"><br><input type=\"submit\" name=\"searchNow\" class=\"btn\" value=\"Search Now\"></tr></td>";
echo "</table></form>";      

}

function fnSearchResults() {
	
	$paperCategoryId = isset($_POST['paperCategoryId']);

$query = "SELECT ausapapersummary.summaryId, ausapapersummary.paperCategoryId, aupapercategory.paperCategory, ausapapersummary.colloPaperName, ausapapersummary.stockId, austock.stockDescription, ausapapersummary.adhesiveId, auadhesive.adhesiveDescription, auliner.linerDescription, ausapapersummary.linerId FROM ausapapersummary ";

$query .="LEFT JOIN aupapercategory ON ausapapersummary.paperCategoryId = aupapercategory.papercategoryId
LEFT JOIN austock ON ausapapersummary.stockId = austock.StockId
LEFT JOIN auadhesive ON ausapapersummary.adhesiveId = auadhesive.adhesiveId
LEFT JOIN auliner ON ausapapersummary.linerId = auliner.linerId            
WHERE ausapapersummary.paperCategoryId = '$paperCategoryId'";
    
   $result = mysql_query($query);   
   if(!$result) error_message(sql_error());

   $num_rows = mysql_num_rows($result);
      
echo "<!-- Set up Table Headers -->";
echo "<table class=\"sortable\">";
echo "<input type=\"hidden\" name=\"commented\" value=\"set\">\n";
echo "<H4>$num_rows Records Found.</H4>";
echo "<table class=\"sortable\" id=\"search\">";
echo "<tr class=row1>";

echo "<th width=150px valign=top align=left nowrap>Summary ID</th>";
echo "<th width=150px valign=top align=left nowrap>Paper Category</th>";
echo "<th width=150px valign=top align=left nowrap>Collo Paper Name</th>";
echo "<th width=150px valign=top align=left nowrap>Face Stock</th>";
echo "<th width=150px valign=top align=left nowrap>Adhesive</TH>";
echo "<th width=150px valign=top align=left nowrap>Liner</th>";

echo "</tr>";

   while($query_data = mysql_fetch_array($result)) {
   	  $summaryId = $query_data["summaryId"]; 	
      $paperCategory = $query_data["paperCategory"];
      $colloPaperName = $query_data["colloPaperName"];
      $stockId = $query_data["stockId"];
      $stockDescription = $query_data["stockDescription"];
      $adhesiveDescription = $query_data["adhesiveDescription"];
      $linerDescription = $query_data["linerDescription"];
             
      echo "<tr class=row2>\n";
      echo "<td width=\"150px\" valign=\"top\">$summaryId</TD>\n";
      echo "<td width=\"150px\" valign=\"top\">$paperCategory</TD>\n";
      echo "<td width=\"150px\" valign=\"top\">$colloPaperName</TD>\n";
      echo "<td width=\"150px\" valign=\"top\">$stockDescription</TD>\n";
      echo "<td width=\"150px\" valign=\"top\">$adhesiveDescription</TD>\n";
      echo "<td width=\"150px\" valign=\"top\">$linerDescription</TD>\n";
      echo "</TR>\n";
   }
   
  echo "</table>";
	}
   
   switch($action) {
    case "viewFaceStock": fnViewFaceStockSpec(); break;
    case "viewAddFaceStock": fnAddFaceStock(); break; 
    case "viewAdhesive": fnViewAdhesive(); break;
    case "addAdhesive": fnAddAdhesive(); break;
    case "viewLiner": fnViewLiner(); break;
    case "addLiner": fnAddLiner(); break;
    case "addFs": fnCreateFs(); break;   
    case "addFaceStock": viewAddFaceStock(); break;
    case "viewPaperSummary": fnViewColloPaper(); break;
    default: viewSearch(); break;
   }
   
$tmpl->set_block('page', 'footer');
$tmpl->pparse('out', 'footer');
   
?>
Last edited by facets on Fri Jul 08, 2005 12:06 am, edited 1 time in total.
User avatar
harrisonad
Forum Contributor
Posts: 288
Joined: Fri Oct 15, 2004 4:58 am
Location: Philippines
Contact:

Post by harrisonad »

how do you call this function?
Post Reply