Search form

[monasa]

I want to have a form that permet to search by location or by name in a database. how can I do this with a simple form.

M.N

 

[MJB3K]

can you give us some more information about your database table structure? then we can help you more!

Regards,

Martin

Gaming Help And Info:

http://gaming.webrevolt.biz

 

[DRJ478]

Roadmap:
1. have an input box for the search term
2. have 2 radio buttons, one for location, the other for name
3. Receiving script checks what to search

<form action="search.php" method="post">
Search for <input type="text" name="searchfor"><br />
<input type="radio" name="column" value="location">In location<br />
<input type="radio" name="column" value="name">In name<br />
<input type="submit" value="GO">
</form>

In the PHP just make your SQL statements according to what's posted.

 

[MJB3K]

for example a gamesearch:

<?php
$k = $_POST['keywords']; //textbox name

$q = mysql_query("SELECT gid, title FROM search WHERE keywords LIKE '%$k%'") or die(mysql_error());
    while(list($gid,$t) = mysql_fetch_row($q)){
        echo "<a href=game.php?gid=$gid>$t</a>"."<br>";
    }
?>

does this help?


Regards,

Martin

Gaming Help And Info:

http://gaming.webrevolt.biz

 

[monasa]

yes it helps a lot thanks