[SOLVED] Syntax Help

[graham23s]

Hi Guys,

 

on my forum there is an ability to search previous posts, but the way it is now it only searches 1 table in mysql "forum_posts" but i really need to search "forum_topics_ at the same time, im not sure the correct syntacy in the query to search both at once anyone help me

 

$search_query = "SELECT * FROM `forum_posts` WHERE (`post_body` LIKE '%$keywords%')";

 

thanks guys

 

Graham

[chigley]

Try UNION ALL?

[lewis987]

try this:

 

SELECT *

FROM `forum_posts`

WHERE `post_body` LIKE CONVERT( _utf8 '%keywords%'

USING latin1 )

[graham23s]

sorted thanks guys:)

 

Graham