filter search

[mdvignesh]

I have some text boxes for searching the students in database

 

also i have a drop down box for selecting student with balance amount to be paid

 

tell me how to filter or search the list of stuents

<select>
            <option value="">All </option>
            <option value="">Unpaid </option>
            <option value="">Paid </option>
        </select>

[JKG]

can you give us some idea of your table structure?

'tell me how to' isn't very polite...

[fugix]

$sql = "select * from table_name where column_name=paid";
$result = mysql_query($sql);

[fugix]

this will filter what students you want information for

 

[JKG]

..and implemented..

<select name="status">
            <option value="">All </option>
            <option value="">Unpaid </option>
            <option value="">Paid </option>
        </select>
<?php
$sql = "select appropriate_columns from table_name where column_name='".$_POST['status']."'";
$result = mysql_query($sql);
?>