Select Query + Inner Join

[obrienkev]

Hi all,

I have 2 tables
keywords{keyword_id, keyword}
url{url_id, url, keyword_id}

I have a search form where the user enters a keyword and if it is similar to the keyword(s) in database it should return the url.

Here's my code so far...It returns all url data in table url. Why is this?

$query = "SELECT u.url, k.keyword_id, k.keyword ".
			 	 "FROM url as u ".
				 "INNER JOIN ".
				 "keywords as k ".
				 "ON u.keyword_id = k.keyword_id ".
				 "WHERE k.keyword LIKE '%".$keyword."%' ";

[Roger_Ramjet]

Echo your query. I'll bet that it read

WHERE k.keyword LIKE '%%'

The problem will be where you set the var $keyword. Again I'll bet you are just relying on Register Globals being ON - got the code form some old book that is out of date. Try changing it to

WHERE k.keyword LIKE '%" . $_POST['keyword'] . "%'" - or whatever the html input is called.