Querying 2 tables error

[closer2u2]

I hope someone can point me to the error in this query as I have spent hours already with no result finding it.

What I would like to achieve is querying table1 (content) and table2 (content-ratings) and sort them by rating

I have this query made:

$sql="SELECT A.*,B.* FROM table1 A, table2 B where A.type='approved' and (A.id like B.id) and (A.title like '%$search_id%' or A.keyword like '%$search_id%' or A.description like '%$search_id%') order by B.total_value desc limit $startfrom, $config[items_per_page]";

Any help is appreciated!

[duckduckgoose]

Maybe like this?

$sql="SELECT A.*,B.total_value FROM table1 A 
LEFT JOIN table2 B ON A.id = B.id 
WHERE A.type='approved' 
AND (A.title like '%$search_id%' 
OR A.keyword like '%$search_id%' 
OR A.description like '%$search_id%') 
ORDER BY B.total_value DESC
LIMIT $startfrom, $config[items_per_page]"; 

[closer2u2]

nope, did not do the trick....

error:

PHP Fatal error: Call to a member function recordcount() on a non-object in