How can I call PHP, search a column in a MySql table and get the result - found?

It is better to read the book which contain the php and mysql there are lot of books out there

You have to create a table in your database and replace the tablename with the name you call your table.And insert connection info.

$ms_sql="select * from `yourdbtable` where title like'%" . $_POST['keyword'] . "%' or summary like'%" . $_POST['keyword'] . "%' or body like'%" . $_POST['keyword'] . "%' order by rate desc"; $query_res=mysql_query($ms_sql); $count=mysql_num_rows($query_res); and the input tag in your form would be named "keyword"

its better if you use PHPmyadmin on handling you mySQL because it much easier

$sql_anunt='select * from `classifieds` WHERE classifieds_title LIKE "%'.$searchtext.'%" or classifieds LIKE "%'.$searchtext.'%" order by classifieds_data desc'; $res_anunt=mysql_query($sql_anunt) or die(mysql_error()); while($rr=mysql_fetch_array($res_anunt)) { #here you can display all the results thats match your criteria }