3 replies to this topic

[Radhe]

<table>
<tr>
<td>
<table width="223" border="0" align="left" cellpadding="3" cellspacing="3">
<tr>
<td width="100" align="center"><input name="Search" type="text" width="100%" placeholder="Sort By"/></td>
<td width="80" align="center"><input name="Search" type="button" value="Search" /></td>
</tr>
</table>
</td>
</tr>

<tr>
<td><table align="left" cellpadding="3" cellspacing="3" border="1">
<tr>
<td align="left"><label>Sort By Skills</label></td>
<td align="center"><input name="Skills" type="checkbox" value="skills" /></td>
</tr>

<tr>
<td align="left"><label>Sort By Experience</label></td>
<td align="center"><input name="Experince" type="checkbox" value="experince" /></td>
</tr>

<tr>
<td align="left"><label>Sort by Duration of Hire</label></td>
<td align="center"><input name="Duration of Hire" type="checkbox" value="dur_hire" /></td>
</tr>

<tr>
<td align="left"><label>Sort by Location of Hire</label></td>
<td align="center"><input name="Location of Hire" type="checkbox" value="loc_hire" /></td>
</tr>

</table></td>
</tr>
</table>

i've done code like this now on the basis of the selected checkbox i want to sort the data... and from sorting of data i want o search particular data by given keywords in search text box...

[Radhe]

<?php

mysql_select_db("db_name") or die(mysql_error());

$data = mysql_query("SELECT * FROM table_name")
or die(mysql_error());

while($info = mysql_fetch_array( $data ))
{
echo "<tr>";
echo "<td>".$info['id'] . "</td>";
echo "<td>".$info['fname'] . "</td> ";
echo "<td>".$info['lname'] . "</td>";
echo "</tr>";
}
?>

[Radhe]

i want to select data from the table dat in data base and than sort on basis of input and than display on same page that i've sort...

[PFMaBiSmAd]

This post seems to be the question that you asked in your first thread. Merging the two threads together...