How to submit a form to the same page?

Posted on 16th Feb 2014 07:03 pm by admin

I have a table containing information about books in my library and this table has the following columns: id, title, category. What I want to do is to make a form that will allow me to sort these books according to one of these fields, its just like in you tube when you want to sort videos by date added, relevance, view count etc..

Both the form and the php code are in "view_books.php"

Here is my form:

Code: <form method="POST" action="view_books.php">

Sort by:

<select size="1" name="sort">

<option> id </option>

<option> category </option>

<option> Date Added </option>

</select>

<input type="submit" value="Go!">

</form>

Here is my php code to sort the books in a table:

Code: $query = mysql_query ("SELECT * FROM books ORDER BY id asc ") or die (mysql_error());

?>

<table width="76%" border="0" align="center" >

<?

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

?>

<tr>

<td> <font color="#696969" size=2> <?php echo $rows['id']; ?> </font></td>
<td> <font color="#696969" size=2> <?php echo $rows['title']; ?> </font></td>
<td> <font color="#696969" size=2> <?php echo $rows['category']; ?> </font></td>

</tr>

<?

}

?>

</table>

Please apply the changes in my code so that it can perform the required function.

Thanks, any help would be appreciated.

Your Answer:

Login to answer

Other forums

Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any do

this code is not working????
it says this error.. Warning: Division by zero in ..

the variables are correct, so why is th

How do I send data using an html link
Hi

If I have
<a href="main_file.php">

How do I send data t

script is pulling more then they have....
I have this script for my game where they can change there race. This will cost them 2,500 points. H

how do i make new line after *
First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to m

Validation
Hello

I know this is a really vag question.

I need to have a input field on a form th

is this the proper use of mysql_real_escape_string() to prevent sql injections?
i was wondering is this the proper use of mysql_real_escape_string() to prevent sql injections? any

reading xml faster than DB call?
I am trying to optimize a high traffic website, and I enabled a feature where there are three photos

default SAP userid
hi,, I just like to know if it is ok to use the default SAP user id (SAP*)?

delete comma
HI,

How to delete "," at the end of the string.
Code: $match = 2009/02/03/a2corr