Databases
StackOverflow2013
Postsdbo
PODisplay Two Tables with Separate SQL Query
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODisplay Two Tables with Separate SQL Query
    text
    copied!<p>I am trying to display two tables, which have different sets of data displayed. The first table is just a single row displaying information about an invoice. The second table displays all the items contained in the invoice. Currently the page is displaying the first table correctly. The second table is where I am having issues. This table is showing all the data that I want. But it displays each item as a separate table, instead of rows within a table. Could someone take a look at my code, and possibly help me figure out where the srew up is at? Thanks</p> <pre><code>&lt;?php $storeid = $_GET['store_id']; $invoiceid = $_GET['invoice_id']; $suppid = $_GET['supp_id']; $strSecReq = '1'; $strDptReq = 'ANY'; $strRequester = $_SERVER['PHP_SELF']; include ($_SERVER['DOCUMENT_ROOT'] . "/securelogin/logincheck.php"); include ($_SERVER['DOCUMENT_ROOT'] . "/database/database.php"); $pgtitle = "Invoice # " . $invoiceid . " Detail"; include('header.php'); $conn = odbc_connect("$storeid", $ODBC_STOREID[1], $ODBC_STOREID[2]) or die ('&lt;br&gt;&lt;b&gt;Error Connecting To STORE&lt;/b&gt;&lt;br&gt;\n'); </code></pre> <p><strong>REMOVED SELECT STATEMENT PER COMPANY POLICY</strong></p> <pre><code>$rsSQL = odbc_exec($conn, $sql) or die ('&lt;br&gt;Error Executing detail SQL'); if (odbc_num_rows($rsSQL)== 0) { echo "&lt;center&gt;"; echo "&lt;br&gt;&lt;b&gt;Your Primary Item ID does not match any entries.&lt;br&gt;Please page back and try again.&lt;/b&gt;"; echo "&lt;/center&gt;"; odbc_close($conn); } else { while ($row = odbc_fetch_array($rsSQL)) { echo "&lt;div align='center'&gt;"; echo "&lt;table class ='tablesmall' border='1' align='center' cellpadding='4'&gt;"; echo "&lt;thead&gt;"; echo "&lt;tr&gt;"; echo "&lt;th&gt;&lt;b&gt;Supplier&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Control&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Type&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Inv Date&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Rec Date&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;# Lines&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Dept&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;History&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Status&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Start TS&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;End TS&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;User&lt;/b&gt;&lt;/th&gt;"; echo "&lt;/tr&gt;"; echo "&lt;/thead&gt;"; $SuppNum = trim(odbc_result($rsSQL, "SuppNum")); $ContNum = trim(odbc_result($rsSQL, "ContNum")); $InvType = trim(odbc_result($rsSQL, "InvType")); $InvDate = trim(odbc_result($rsSQL, "InvDate")); $RecDate = trim(odbc_result($rsSQL, "RecDate")); $NumLines = trim(odbc_result($rsSQL, "NumLines")); $DeptNum = trim(odbc_result($rsSQL, "DeptNum")); $HistFlag = trim(odbc_result($rsSQL, "HistFlag")); $InvStat = trim(odbc_result($rsSQL, "InvStat")); $InvStart = trim(odbc_result($rsSQL, "InvStart")); $InvEnd = trim(odbc_result($rsSQL, "InvEnd")); $UserName = trim(odbc_result($rsSQL, "UserName")); echo "&lt;tbody&gt;"; echo "&lt;tr&gt;&lt;td&gt;"; echo $SuppNum; echo "&lt;/td&gt;&lt;td&gt;"; echo $ContNum; echo "&lt;/td&gt;&lt;td&gt;"; echo $InvType; echo "&lt;/td&gt;&lt;td&gt;"; echo $InvDate; echo "&lt;/td&gt;&lt;td&gt;"; echo $RecDate; echo "&lt;/td&gt;&lt;td&gt;"; echo $NumLines; echo "&lt;/td&gt;&lt;td&gt;"; echo $DeptNum; echo "&lt;/td&gt;&lt;td&gt;"; echo $HistFlag; echo "&lt;/td&gt;&lt;td&gt;"; echo $InvStat; echo "&lt;/td&gt;&lt;td&gt;"; echo $InvStart; echo "&lt;/td&gt;&lt;td&gt;"; echo $InvEnd; echo "&lt;/td&gt;&lt;td&gt;"; echo $UserName; echo "&lt;/td&gt;&lt;/tr&gt;"; echo "&lt;/tbody&gt;"; echo "&lt;/table&gt;"; echo "&lt;/div&gt;"; echo "&lt;br&gt;"; </code></pre> <p><strong>REMOVED SELECT STATEMENT PER COMPANY POLICY</strong></p> <pre><code> $rsSQL1 = odbc_exec($conn, $sql1) or die ('&lt;br&gt;Error Executing detail SQL'); while ($row = odbc_fetch_array($rsSQL1)) { echo "&lt;div align='center'&gt;"; echo "&lt;table class ='tablesmall' border='1' align='center' cellpadding='4'&gt;"; echo "&lt;thead&gt;"; echo "&lt;tr&gt;"; echo "&lt;th&gt;&lt;b&gt;Seq&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Type&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Ord Code&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;ItemID&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Sku Type&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Descr&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Pk Size&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;DeptNum&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Inv Units&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Qty&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;UM&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Price&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Multiple&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Pack&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Cost&lt;/b&gt;&lt;/th&gt;"; echo "&lt;th&gt;&lt;b&gt;Allow&lt;/b&gt;&lt;/th&gt;"; echo "&lt;/tr&gt;"; echo "&lt;/thead&gt;"; $InvSEQ = trim(odbc_result($rsSQL1, "InvSEQ")); $IDTyp = trim(odbc_result($rsSQL1, "IDTyp")); $OrdCode = trim(odbc_result($rsSQL1, "OrdCode")); $ItemID = trim(odbc_result($rsSQL1, "ItemID")); $SkuTyp = trim(odbc_result($rsSQL1, "SkuTyp")); $Descr = trim(odbc_result($rsSQL1, "Descr")); $PkSize = trim(odbc_result($rsSQL1, "PkSize")); $DeptNum = trim(odbc_result($rsSQL1, "DeptNum")); $InvUnits = trim(odbc_result($rsSQL1, "InvUnits")); $FinQty = trim(odbc_result($rsSQL1, "FinQty")); $FinUM = trim(odbc_result($rsSQL1, "FinUM")); $FinPrice = trim(odbc_result($rsSQL1, "FinPrice")); $FinMult = trim(odbc_result($rsSQL1, "FinMult")); $FinPack = trim(odbc_result($rsSQL1, "FinPack")); $FinCost = trim(odbc_result($rsSQL1, "FinCost")); $FinAllow = trim(odbc_result($rsSQL1, "FinAllow")); if ($bgcolor == '#ffffff') { $bgcolor = '#dddddd'; } else { $bgcolor = '#ffffff'; } echo "&lt;tbody&gt;"; echo "&lt;tr&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$InvSEQ&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$IDTyp&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$OrdCode&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$ItemID&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$SkuTyp&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$Descr&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$PkSize&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$DeptNum&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$InvUnits&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$FinQty&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$FinUM&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$FinPrice&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$FinMult&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$FinPack&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$FinCost&lt;/td&gt;"; echo "&lt;td bgcolor = '$bgcolor' align = 'center'&gt;$FinAllow&lt;/td&gt;"; echo "&lt;/tr&gt;"; echo "&lt;/tbody&gt;"; echo "&lt;/table&gt;"; echo "&lt;/div&gt;"; } } odbc_close($conn); include($_SERVER['DOCUMENT_ROOT'] . '/footer.php'); } ?&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload