search page and stuff

[dri]

hi all this is my first post hope i learn good stuff from the forum 

 

so my problem is i am making a search page that well search in my mysql database i have 3 problems now

 

1

$sql = mysql_query("select * from remote where topic like '%$term%'");

 

this is used as for a search page

this well search in table remote i want to add more than that table i wanna add

 

4 more so total 5

and all searching in the same column (topic) how can i do that

 

 

2

if i entered ' in the search box i get an error that means its hackable

how can i fix that if u need the full source code just till me

this is the error

 

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in E:\wamp\www\website\searcher.php on line 61

this is line 61 while ($row = mysql_fetch_array($sql)){

 

3

so now i have 2 files for the search page 1 is .html and 2 is .php

if i entered .php without going to .html and type any thing in the search bar i well get an error Notice: Undefined index: term in E:\wamp\www\website\searcher.php on line 58

 

and in line 58 $term = $_POST['term'];

how can i add a command that if there is nothing in term it well show nothing in result

 

 

 

 

 

 

thats all hope u guys help me making a bid site need a search page 

 

 

i am really beginner at this so i may ask allot even when the answer is in front of me