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

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Check Date/Time in PHP
What I need the code to check is that $reQuest is 24 hours in the past then return a time based on h

How to display random record from table?
I have the following code:

Code: <?php
$display_block .= "<input type=

Image DPI
Hi.

I allow users to upload images, the user then is able to adjust several settings for the

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Greek characters in php 
Hi,

I'm making a script and I m using for first time greek characters.
I started to write 
Parse error: syntax error, unexpected $end in  
hello,
i receive the error :Parse error: syntax error, unexpected $end in C:xamppxampphtdocsh
Socket problem 
Hello,

Earlier I posted about my problem with my socket script. It took up to 100% CPU usage.
split values 
I have values that are returned to me in this format:

name=>test,age=>49
Staff Induction System - No idea where to go from here!!! 
Hi there, I'm pretty new to PHP and Mysql so could really do with being pointed in the right directi