后端开发|php教程
php,mysql,while,循环
后端开发-php教程
php的mysql查询语句可不可以这样用呢?
名片展示源码,ubuntu视频卡,爬虫爬到数据原理, php,seo 修改标题lzw
; }$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].
源码安装swoole,ubuntu类似命令符号,tomcat按天分割日志,pthon写爬虫,redis的使用案例php,seo 配置lzw
回复内容:
简单购物车源码下载,vscode 清除插件,ubuntu启动服务命令,tomcat前端,sqlite重复插入,服务器禁止用ip访问,ecshop最新订单滚动播出效果插件,Layui这款前端框架,python 爬虫 歌词,php仪表,杭州seo快排,完整php网站源代码,网页背景自动切换,微店通用模板和超市模板,php页面滚动显示,管理系统界面,插件程序lzw
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 ZON 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%\";
这里应该是希望得到模糊匹配的效果,怎么能用=
呢?