[Resolvido] Comparar campos de tabelas diferentes

[My name is Jan Lucas 0]

Ae galera preciso fazer a seguinte query:

 

$query      = mysql_query("SELECT `complete_name` FROM `user_admin` WHERE `id` = enter_box_admin.user_fk ");
$remetentes = mysql_fetch_array($query);
$remetente  = $remetentes['complete_name'];

 

só que essa query da um erro:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\helpdesk\adm\enter_box_admin.php on line 64

[giesta 29]

eh pq a query tah errada, alem disso , isso eh parada de PHP

 

$query      = mysql_query("SELECT ua.complete_name FROM `user_admin` ua ,enter_box_admin eba WHERE ua.id = eba.user_fk ") or die(mysql_error());
$remetentes = mysql_fetch_array($query);
$remetente  = $remetentes['complete_name'];

 

repassando...

[My name is Jan Lucas 0]

REsolvido aqui! Brigado galera!