sort table by dropbox entry

Ads

 
 

Share on Google+Share on Google+

balgrath
sort table by dropbox entry
0 Answer(s)      6 years and 4 months ago
Posted in : PHP

Hi All, I current have the following code, apologies for the length. I am able to retrieve all the information i require but am looking to include some filter boxes. I have managed to add the filter drop down to the table BUT and am unable to get this to do anything. The dropdown pulls its data from another dedicated table(works) but I need an OnCHANGE event to filter the data where the Country equals the selected record in the dropdown?? (#95 are underscores in the code below) I can manually add the following into the $sql= ... AND Country='BE' and it will find all records for that country.. can this be done dynamically or with a page reload??? Any help gratefully received:

<?php
require './connections/db_connect.php';

$db_name="Projects_Main"; // Database name 
$tbl_name="Main"; // Table name

// Connect to server and select database.
mysql_connect($host, $usrname, $pssword)or die("Connection failed"); 
mysql_select_db($db_name)or die("Connection failed");
$sql=("SELECT * FROM $tbl_name WHERE Status not like 'CLOSED'");
$result=mysql_query($sql);

$num_rows = mysql_num_rows($result);
$fields_num = mysql_num_fields($result);

?>
<table>

<!-- create the table headers and using the next section build the table. sections not shown as page space not sufficent -->
<tr>
    <th>Project ID</th>
    <th>Financial Year</th>
    <th>Country</th>
    <th>More Details</th>
    <th>UPDATE</th>
</tr>
<!--START:filter    NOT WORKING-->
<tr>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th>
        <?php
            $db_name = 'Projects_Main';
            $ctrytable = 'Country';
                if (!mysql_connect($host, $usrname, $pssword))
                       die("Can't connect to database 'cos somethin' is wrong");
                if (!mysql_select_db($db_name))
                     die("Can't select database");
            $result1 = mysql_query("SELECT country_abbrev, country_name FROM {$ctrytable} order by country_name");
            $options="";
        while ($row=mysql_fetch_array($result1)) 
                {
                    $id=$row["country_abbrev"];
                    $thing=$row["country_name"];
                    $options.="<OPTION VALUE=\"$id\">".$id."</option>\n";
                }
        ?>
            <SELECT NAME="Country" type="text" onchange="filterTable(this.options[this.selectedIndex].value);">
                <OPTION VALUE=\"\">ALL
                                        <? echo $options?>
            </SELECT>
    </th>

    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
    <th></th>
</tr>
<!--END:  filter -->

    <?php

    while($rows=mysql_fetch_array($result))
    {


    ?>
<!-- echo the contents of database table -->
<tr>
    <td align="center"><?php echo $rows['Project_id']; ?></td>
    <td><?php echo $rows['FinancialYear']; ?></td>
    <td><?php echo $rows['Country']; ?></td> 
    <!-- link to show more info on the record or update record.. -->
    <td><a href="./projects_more.php?Project_id=<?php echo $rows['Project_id']; ?>">more...</a></td>
    <td><a href="./projects_update.php?Project_id=<?php echo $rows['Project_id']; ?>">update</a></td>
</tr>
    <?php
    }
    ?>
</table>

<?php
mysql_close();
?>
Ads
View Answers
Ads









Related Tutorials/Questions & Answers:
sort table by dropbox entry
sort table by dropbox entry  Hi All, I current have the following... drop down to the table BUT and am unable to get this to do anything. The dropdown pulls its data from another dedicated table(works) but I need an OnCHANGE
JavaScript sort table
JavaScript sort table..., we are going to sort the table using the JavaScript. To sort the table, we... created a for loop which iterates through the rows of the table in the function
Advertisements
How to add dropdown list in a row of a sort table applet?
How to add dropdown list in a row of a sort table applet?  How to add dropdown list in a row of a sort table applet
How to Sort Column values of a jsp table - JSP-Servlet
How to Sort Column values of a jsp table  Hi Friend Please help me. I am displaying reultset values on multiple jsp page. I want to sort selected column values on every page onclick of an event its very urgent pleasehelp
Sort
Sort  program to sort a list of numbers in decendimg order   Hi Friend, Try the following code: import java.util.*; class SortListInDescendingOrder{ public static void main(String[] args
Sort
all the votes have been counted, the program should output a table showing how
Mysql Date Sort
; Mysql Date Sort is used to return the sort  records or rows value in table... Sort. To understand this example, we create a table 'employee1' with field name...) Query to sort data from the table according to Empname created
Version of com.fathzer>jclop-dropbox dependency
List of Version of com.fathzer>jclop-dropbox dependency
Version of com.syncthemall>dropbox-java-sdk dependency
List of Version of com.syncthemall>dropbox-java-sdk dependency
database entry using jdbc
database entry using jdbc  Give me a program to enter records in table using jdbc in java.   Hi Friend, Please visit the following link: Insert data into database Thanks
Maven Dependency jclop-dropbox >> 0.0.1
You should include the dependency code given in this page to add Maven Dependency of com.fathzer >> jclop-dropbox version0.0.1 in your project
Maven Dependency jclop-dropbox >> 0.0.2
You should include the dependency code given in this page to add Maven Dependency of com.fathzer >> jclop-dropbox version0.0.2 in your project
Maven Dependency jclop-dropbox >> 0.0.4
You should include the dependency code given in this page to add Maven Dependency of com.fathzer >> jclop-dropbox version0.0.4 in your project
delete an entry using JavaScript
delete an entry using JavaScript  How to delete an entry using JavaScript
Order Entry System
Order Entry System  Create a new order entry system using netbeans and microsoft access.can anyone help me
Maven Dependency dropbox-java-sdk >> 1.5.3.1
You should include the dependency code given in this page to add Maven Dependency of com.syncthemall >> dropbox-java-sdk version1.5.3.1 in your project
Maven Dependency dropbox-java-sdk >> 1.5.3.2
You should include the dependency code given in this page to add Maven Dependency of com.syncthemall >> dropbox-java-sdk version1.5.3.2 in your project
Edit cron entry
Edit cron entry   Hi, What is the command to Edit cron entry in linux? Regards Deepak Kumar   Hi, You can use the following command to open cron configuration in vi editor: crontab -e After editing just save
Array sort
Array sort  Program that uses a function to sort an array of integers
bubble sort
bubble sort  write a program in java using bubble sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  write a program in java using insertion sort
insertion sort
insertion sort  how many arrays needed for insertion sort and why
bubble sort
bubble sort  how to calculate the number of passes in bubble sort
Help With Costructing Selection sort?
Help With Costructing Selection sort?  Using a selection sort, for each entry in the array, display the original index of the first dimension... in advance!   Please visit the following link: Java Selection Sort
table
table  multiplicatyion table
Java entry prog.
Java entry prog.  Dear sir I will enter the dept code, dept name and insert into dept_mast and save. Pl. Dept_mast Dept_code Char(2...) **Entry screen** **Department entry** Dept Code
buble sort
buble sort  ascending order by using Bubble sort programm   Java BubbleSort Example
TABLE
TABLE   Why doesn't <TABLE WIDTH="100%"> use the full browser width

Ads

 
Advertisement null

Ads