php的mysql查询语句可不可以这样用呢？
$query = select name from bank where area like 'aaa';$result = mysql_query($query) or die(mysql_error());while($row = mysql_fetch_array($result)) { $http = $row['http']; $task_query = select * from task where link like'%$http%'; $task_result = mysql_query($task_query) or die(mysql_error()); while($task = mysql_fetch_array($task_result)); echo $task['high'].'
'; }

回复内容： php的mysql查询语句可不可以这样用呢？
$query = select name from bank where area like 'aaa';$result = mysql_query($query) or die(mysql_error());while($row = mysql_fetch_array($result)) { $http = $row['http']; $task_query = select * from task where link like'%$http%'; $task_result = mysql_query($task_query) or die(mysql_error()); while($task = mysql_fetch_array($task_result)); echo $task['high'].'
'; }

select *from task join (select http as zhttp from bank where area like 'aaa') as z on task.link like concat('%', z.zhttp, '%')
select * from bank left join task on task.link like concat('%', bank.http, '%') where bank.area = 'aaa'
我觉得你可能需要join....
select task.high from task left join bank on task.link like concat('%', bank.http. '%') where bank.area like 'aaa'
你在 $task_query = select * from task where link='%$http%'; 这里应该是希望得到模糊匹配的效果，怎么能用 = 呢？