Databases
StackOverflow2013
Postsdbo
POMySQL, PHP filtering results within displayed table?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMySQL, PHP filtering results within displayed table?
    primarykey
    data
    text
    <p>I've searched through what "I think I should be searching for" - but not really understanding or getting anywhere, please could someone point me in the right direction? </p> <p>I'd like to be able to filter a result set using the <code>th</code> of one column (region) and although I tried the w3cs tutorial I ended up confusing myself as to "what bit of code goes where" etc and the dropdown form thingie looked very clunky.<br> All advice and help most welcome. </p> <p>This is my example website, <a href="http://www.palegallery.com/Reassessment" rel="nofollow noreferrer">myTrader</a> clicking the All Trade Regions link on the left displays as far as I've got &amp; that took me days of cobbling tutorials and guddling about in the dark.</p> <p>query.php code so far:</p> <pre><code> &lt;table id="mainTable"&gt; &lt;tr&gt;&lt;td width="300" valign="top"&gt;&lt;H1&gt;Welcome to myTrader!&lt;/H1&gt; &lt;span class="mainText"&gt;Glass &amp; Paper Recycled Commodities Trading Site&lt;/span&gt;&lt;/td&gt; &lt;td valign="top" align="right"&gt;&lt;img src="images/largeLogo.jpg" width="406" height="113" border="0"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt; &lt;P&gt;&lt;span class="paraHeadingOne"&gt;All Region Paper Sales&lt;/span&gt; &lt;/P&gt; &lt;P&gt; &lt;table class="dbTable"&gt; &lt;tr&gt; &lt;tr&gt;&lt;th&gt;Commodity&lt;/th&gt; &lt;th&gt;Region&lt;/th&gt; &lt;th&gt;Member&lt;/th&gt; &lt;th&gt;Size&lt;/th&gt; &lt;th&gt;Price&lt;/th&gt; &lt;th&gt;Date Posted&lt;/th&gt; &lt;/tr&gt; &lt;?php $link = mysql_connect('localhost', 'palegall', '******'); if (!$link) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db('palegall_newTrader', $link); if (!$db_selected) { die ('cant find newTrader' . mysql_error()); } $query = mysql_query ("SELECT * FROM `sell` WHERE `commodity`='Paper' ORDER BY `price`") or die( mysql_error() ); $row=mysql_fetch_assoc($query); do { echo'&lt;table class="dbTable"&gt;'; echo '&lt;tr&gt;&lt;td&gt;'.$row['commodity'].'&lt;/td&gt; &lt;td&gt;'.$row['region'].'&lt;/td&gt; &lt;td&gt;'.$row['member'].'&lt;/td&gt; &lt;td&gt;'.$row['size'].'&lt;/td&gt; &lt;td&gt;'.$row['price'].'&lt;/td&gt; &lt;td&gt;'.$row['posted'].'&lt;/td&gt; &lt;/tr&gt;'; }while($row=mysql_fetch_assoc($query)); echo "&lt;/table&gt;"; ?&gt; &lt;/td&gt;&lt;/tr&gt;&lt;/table&gt; &lt;/td&gt;&lt;/tr&gt;&lt;/table&gt; &lt;/body&gt;&lt;/html&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USscotia
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMySQL, PHP filtering results within displayed table?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POMySQL, PHP filtering results within displayed table?
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COWe need more information : what tables have you created ? what results do you want ? provide a short example (an entire website is not an example)...
      singulars
      1. POMySQL, PHP filtering results within displayed table?
      1. USCyril Gandon
    2. COSorry Scorpi0 - only want to use the two tables displayed - (sell & buy) - all the data needs to appear first, then have the user click the header for Region & some method of filtering be available, I dont have any code for the filter part yet but can post my query.php code here - erm, how do I do that?
      singulars
      1. POMySQL, PHP filtering results within displayed table?
      1. USscotia
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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