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

media recovery
Hi,
i startup the database i got the error

SQL> startup
ORACLE instance started.

php require help needed
Ok i tried to use the search funtion but the word require is everywhere.

i'm really new to cr

Better Method of a Member Cloud
I assume most people know how tag clouds work, where the tags most used are bigger and the least use

Echo-ing MySQL content and Keep Formatting?
I have data in my MySQL such as:

QuoteBlah blah

Blah blah

etc
but when i ech

Custom Container in module pool program
Hello everyone,

I have created a custom control in my module pool screen. Now I want to s

Need help urgant
why down my code ony return one item instead of all the items selected.

$arr = array($date,$

Timer control causing error
I recently decided to add a timer control to an existing page that uses AJAX on my site. As soon as

Add a sign-up feature to a flat file login script
I'm working on a flat file login script and I would like to add a sign-up feature to it with a email

How to sum these output values
Hi

I need sum the month totals
SELECT region_name, area_name ,SUM (CASE WHEN S

quotes changing
hi all

in my content

opening quotes " changes to “

close qu