新的MySQL问题。分组 [英] New MySQL Question. Grouping

问题描述

好的，所以你已经帮了我很多了，现在我有一个适合我的数据库的代码，因为我进一步移动我想问你如何将我的发现分组...我在这里看到

展开 | 选择 | Wrap | 行号

解决方案

好的，这是对我的问题的更新......我想出了它为什么会出现0 ...我不知道在我的数据库中有0，但它显示为0，因为我在MySQL中设置了（INT）ROW ...它说0，因为在ROW中它有（ALL）我试图将设置更改为VARCHAR NULL = YES和现在我t只是BLANK，显示了YEARS和一个ALL ......所以我的新问题是如何才能让它显示所有年份.... ????



这里是我的DATABASE for ROW中的一个例子[年]

展开 | 选择 | 换行 | 行号

< blockquote>好的，我试着添加DROPDOWN＃3 ......我发誓我觉得我做对了？/ ???但它不会显示我的下一个下拉列表....请帮助...这是我的INDEX.php的代码

展开 | 选择 | 换行 | 行号

好​​的，所以你已经帮了我很多了，现在我有一个适合我的数据库的代码，因为我继续前进我想问你怎么样我可以对我的发现进行分组......我在这里看到

展开 | 选择 | Wrap | 行号

Okay so you have helped me out alot already and now I have a code that fits my Database now befor I move any further I would like to ask you how I can group my findings... I see here

Expand|Select|Wrap|Line Numbers

解决方案

Okay here is an update to my question... I figured out why it is displying 0... I do not have 0 in my Database but it was showing 0 because I had the ROW set on (INT) in MySQL ... It was saying 0 because in the ROW it had (ALL) I tryed to change the setting to VARCHAR NULL = YES and now it is just BLANK insted of showing YEARS and one ALL.... So my new question is how can I get it to show the ALL with the YEARS....????


here is an example of what is in my DATABASE for ROW [year]

Expand|Select|Wrap|Line Numbers

Okay I tryed to add a DROPDOWN # 3... I swear I think I got it right?/??? but It will not show my next dropdown.... please help... here is my code for INDEX.php

Expand|Select|Wrap|Line Numbers

Okay so you have helped me out alot already and now I have a code that fits my Database now befor I move any further I would like to ask you how I can group my findings... I see here

Expand|Select|Wrap|Line Numbers

这篇关于新的MySQL问题。分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！