php,while中使用mysql查询语句问题

Question

php的mysql查询语句可不可以这样用呢？$query="SELECTnameFROMbankWHEREareaLIKE'aaa'";$result=mysql_query($query)ordie(mysql_error());while($row=mysql_fetch_array($result)){$http=$row['http'];$task_query="SELECT*FROMtaskWHERElinkLIKE'%$http%'";$task_result=mysql_query($task_query)ordie(mysql_error());while($task=mysql_fetch_array($task_result));echo$task['high'].'';}

Answer 1

SELECT*
FROMtask
JOIN(SELECThttpASzhttpFROMbankWHEREareaLIKE'aaa')ASZ
ONtask.linkLIKECONCAT('%',Z.zhttp,'%')
                            

Answer 2

SELECT*FROMbankLEFTJOINtaskONtask.linkLIKEconcat('%',bank.http,'%')WHEREbank.area='aaa'
我觉得你可能需要JOIN....