Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa PHP sort table by dropbox entry
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


balgrath
sort table by dropbox entry
0 Answer(s)      3 years and 7 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();
?>

Advertisement
View Answers

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
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
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
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
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
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
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
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
How to search entry in ZipFile.
How to search entry in ZipFile. In this tutorial, We will discuss the use... will search given entry in a zip file. The getEntry method search specific  entry in a zip file, and returns specified entry or null if it not available
bubble sort
bubble sort  how to calculate the number of passes in bubble sort
insertion sort
insertion sort  how many arrays needed for insertion sort and why
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
Array sort
Array sort  Program that uses a function to sort an array of integers
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
buble sort
buble sort  ascending order by using Bubble sort programm   Java BubbleSort Example
Validating Duplicate Entry To Database - Java Beginners
Validating Duplicate Entry To Database  I have a servlet that adds data to the table called foodtype in (Ms Access). i already have Chinese, vegetarian entered in table. what am trying to do is to validate when entering foodtypes
SEARCH AND SORT
SEARCH AND SORT  Cam any one provide me the code in java that : Program to search for MAX,MIN and then SORT the set using any of the Divide and conquer method
Inserting a New Entry in a List
Inserting a New Entry in a List       This Example shows you how to Insert a new Entry... in code given below for Inserting a new Entry in List:- Element person
quick sort
; System.out.println(" Quick Sort\n\n"); System.out.println("Values Before the sort:\n"); for(i = 0; i < array.length; i++){ array[i...("Values after the sort:\n"); for(i = 0; i <array.length; i
quick sort
; System.out.println(" Quick Sort\n\n"); System.out.println("Values Before the sort:\n"); for(i = 0; i < array.length; i++){ array[i...("Values after the sort:\n"); for(i = 0; i <array.length; i
quick sort
; System.out.println(" Quick Sort\n\n"); System.out.println("Values Before the sort:\n"); for(i = 0; i < array.length; i++){ array[i...("Values after the sort:\n"); for(i = 0; i <array.length; i
java.sql.BatchUpdateException: Duplicate entry '135-16448' for key 1 - Hibernate
java.sql.BatchUpdateException: Duplicate entry '135-16448' for key 1  ... inside the mysql table. Error Code.... java.sql.BatchUpdateException: Duplicate entry '135-16448' for key 1
Advertisements
 

 

 

DMCA.com