[elina]

im very new to php. can anyone please help. im trying to create a search feature for my application which im using php and mysql. can you please give me the code for a simple search feature.

thank you

[ManzZup]

can you descripbe the search features
if you clearly know the app, you can base your search on the DB itself, and dynamically generate the required links
ex: you search for "best article"
you have a page named best artcle in your DB
you make link with the article ID
hope you got it

[transparent]

You need first to create a HTML form for the search

<form action="search.php">
  <input type="text" name="s" />
  <input type="submit" value="Search" />
</form>

Now inside your search.php:

PHP Code:

<?php
// connect to the database
$con = mysql_connect('localhost','username','password');
mysql_select_db('database_name',$con);


//create a search query
$find = $_REQUEST['s'];
$q = "SELECT * FROM `table_to_do_search` WHERE `field1` LIKE '%$find%' or `field2` LIKE '%$find%'";

$result = mysql_query($q);

if(mysql_num_rows($result) > 0)
{
  echo '<h1>Results:</h1>';
  echo '<ol>';
  while($row = mysql_fetch_assoc($result))
  {
     echo '<li>'.$row['fieldname'].'</li>';
  }
  echo '</ol>';

}
else
  echo 'No results found';

?>

This is just a concept on how it should work.