[SOLVED] Please Help : Error Message

[JamesXL1967]

Hi Guys

 

I am new to PHP and mysql and I wondered if anyone could explain this error :

 

Call to undefined function: resource id #88() in mydomain/home/myfile.php on line 63

 

The code it relates to is as follows (line 63 highlighted) :

 

$user_data = $db->query("SELECT user_hi, user_lo FROM

" . DB_PREFIX . "users WHERE user_id='" . $session->value('user_id') . "'");

 

$sql_select_data = $db->query("SELECT a.item_id, a.name, a.price,  a.currency, a.owner_id, a.item_hi, a.item_lo,

LINE 63 >>> sqrt (((". $user_data($user_hi) ." - a.item_hi)*( ". $user_data($user_hi) . " -a.item_hi)) + ((".$user_data($user_lo)." - a.item_lo)*(".$user_data($user_lo)." - a.item_lo))) AS TDifference

FROM

" . DB_PREFIX . "items a " . $force_index . "

" . $where_query . "

GROUP BY a.item_id

ORDER BY TDifference ASC LIMIT " . $start . ", " . $limit);

 

}

 

Any help with the above or if you can spot any other errors in the code would be appreciated.

 

Many thanks in advance

[wildteen88]

Judging by your code I think

 

$user_data($user_hi) should of been $user_data['user_hi']

 

and

 

$user_data($user_lo) should of been $user_data['user_lo']

[JamesXL1967]

Many thanks for the prompt reply Wildteen

 

I will give that a try.