济南网站排名公司,好网站建设网站,网站建设合作范本,网站搭建服务器配置我正在设计一个类似于4个表格的字典数据库wordswordid | lemmasenseswordid | synsetidsynsetssynsetid | definitionsamplessynsetid | sample所以我使用下面的查询来获取所有意义定义和样本if(isset($searchterm)){echo .$searchterm.;// QUERY TO F…我正在设计一个类似于4个表格的字典数据库wordswordid | lemmasenseswordid | synsetidsynsetssynsetid | definitionsamplessynsetid | sample所以我使用下面的查询来获取所有意义定义和样本if(isset($searchterm)){echo .$searchterm.;// QUERY TO FIND SENSES$senses_querySELECTwords.lemma,words.wordid,senses.wordid,senses.synsetid,synsets.synsetid, synsets.definition,samples.synsetid, samples.sampleFROMwordsLEFT JOINsenses ON words.wordidsenses.wordidLEFT JOINsynsets ON senses.synsetidsynsets.synsetidLEFT JOINsamples ON senses.synsetidsamples.synsetidWHEREwords.lemma REGEXP ^$searchterm$;$senses_query_result mysql_query($senses_query) OR die(sense alamadım..mysql_error());$nummysql_num_rows($senses_query_result);while($sensesFound mysql_fetch_array($senses_query_result )){echo . $sensesFound[lemma] . ;echo . $sensesFound[definition] . ;echo . $sensesFound[sample] . ;echo ;}}问题是如果有一个以上的定义样本它会像这样重复。definition 1 sample 1definition 1 sample 2definition 2 sample 1definition 2 sample 2definition 2 sample 3e.t.c我喜欢有类似的行definition 1 sample 1 sample 2definition 2 sample 1 sample 2 sample 2我在select上尝试了group_concat但它将所有定义的所有样本连接成单个样本。是否有可能与MySQL查询或我应该使用PHP来处理这种工作。提前致谢
