Is it possible to use MySQL query statements in PHP?
$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'].'
'; }
Reply content:
Is it possible to use MySQL query statements in PHP?
$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'
I think you may need to .... JOIN
select task.high from task left join bank on task.link like concat('%', bank.http. '%') where bank.area like 'aaa'
You're supposed to be looking for a $task_query = "SELECT * FROM task WHERE link='%$http%'";
fuzzy matching effect here, how can you use =
it?