Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 表关联获取7最新的7条数据变成了1条

表关联获取7最新的7条数据变成了1条

WBOY
Release： 2016-06-23 13:49:46
Original
921 people have browsed it

我在phpmyadmin中用这条语句可以调出7条结果，但是到了程序中就变成了1条 

SELECT fcj.fang_time, fcj.area, fcj.taoshu FROM f_chengjiao AS fcj LEFT JOIN f_city AS fc USING (city_id) WHERE fcj.city_id=1 ORDER BY fcj.fang_time LIMIT 0, 7
Copy after login


回复讨论(解决方案)

你确认执行的是同样的语句？
你确认是同个数据库？
你确认是只有一条？

你确认执行的是同样的语句？
你确认是同个数据库？
你确认是只有一条？


我已经知道那里错了，分送你了
Related labels：
association data up to date
source：php.cn
Previous article：Sql中如何同时更新多个表的数据 Next article：php读取mysql速度问题
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1361
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
How to display only the lowest value from a result set (MYSQL) I have the following statement: selectDATE(recieved_on)asDay,round(count(*)/24)AS'average'...
From 2024-04-06 21:44:19
0
1
603
Regular expression to match words I have a script where I am trying to match new job names with existing job names in a data...
From 2024-04-06 21:24:04
0
1
606
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template