Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > mysql输出不全

mysql输出不全

WBOY
Release： 2016-06-23 13:38:55
Original
1016 people have browsed it

下图是我要做的大致效果，显示每年的活动：


自己写的代码：


代码显示效果：


数据库中还有14和13年的数据，但是不显示为什么，去掉红色框可以显示年份：


回复讨论(解决方案)

两个查询的变量$row重复，前面的被覆盖了。

你内外循环的查询结果都存放在 $result 变量中，难道不产生冲突吗？

变量被覆盖啦

Related labels：
mysql输出不全
source：php.cn
Previous article：PHP涉及数据库内容的多语言设计如何实现？ Next article：关于网上支付paypal/alipay
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
Even after clearing, the value of my file input remains As you can see in the screenshot. I select a file, keep the popup without refreshing the p...
From 2024-04-06 15:44:52
0
1
384
Solving Vue3 webcomponents production build issues I'm trying to migrate my vue2web components to vue3, although the problem arises when I cr...
From 2024-04-06 12:43:37
0
1
473
vue vee-validate captures the problem of date picker selection The v-model binding on my datepicker field is not working properly. When you make a select...
From 2024-04-06 11:38:56
0
1
510
How to insert multiple rows in MySQL table and return new IDs? Normally I can insert a row in a MySQL table and get the last_insert_id. But now, I want t...
From 2024-04-06 10:03:44
0
2
294
How to sort SQL results if one column is empty? I have a question about the ordering of query results. I have 3 columns that need to be so...
From 2024-04-05 00:39:32
0
1
317
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