neo115162

Maybe my question is unclear. I am calling two queries, namely; $resNews = $connect->get_query("SELECT id,".strtolower($_GET['lang'])."_heading,".strtolower($_GET['lang'])."_story,DATE_FORMAT(date_ins, '%b %d %Y, %h:%i %p') FROM news WHERE ($partsNews) AND ".strtolower($_GET['lang'])."_heading IS NOT NULL AND publish = 'yes'"); $resEvents = $connect->get_query("SELECT id,".strtolower($_GET['lang'])."_title,".strtolower($_GET['lang'])."_description,DATE_FORMAT(date_ins, '%b %d %Y, %h:%i %p') FROM events WHERE ($partsEvents) AND ".strtolower($_GET['lang'])."_title IS NOT NULL AND event_datum >= NOW() AND publish = 'yes'"); I want to display them seperately, like this; <table width="100%" border="0" cellspacing="0" cellpadding="0"> <?php while (($arrNews=mysql_fetch_array($resNews, MYSQL_NUM))!==FALSE) { ?> <tr> <td><a href="news_details.php?lang=<?php print $_GET['lang'];?>&newsid=<?php print $arrNews[0];?>"><?php print html_entity_decode($arrNews[1]);?></a> [<i><?php print $arrNews[3]; ?></i>]</td> </tr> <tr> <td><?php print limit_characters(html_entity_decode($arrNews[2]),150);?></td> </tr> <?php } mysql_free_result($resNews); ?> <?php while (($arrEvents=mysql_fetch_array($resEvents, MYSQL_NUM))!==FALSE) { ?> <tr> <td><a href="eventdetails.php?lang=<?php print $_GET['lang'];?>&eid=<?php print $arrEvents[0];?>"><?php print html_entity_decode($arrEvents[1]);?></a> [<i><?php print $arrEvents[3]; ?></i>]</td> </tr> <tr> <td><?php print limit_characters(html_entity_decode($arrEvents[2]),150);?></td> </tr> <?php } mysql_free_result($resEvents); ?> </table> I am not getting any results for events, only for news. Can anyone help me?

Hello, I am having problems retrieving results for a particular query which is for events. Every time I type a particular word to search for in the news table I get results and when I do for events it doesn't show. I tried troubleshooting the problem and realized that if I do print mysql_num_rows($resEvents); I will get a result which is more than 0. Can anybody help me with this issue? Thanks in advance.searchresults.php

Hello Psycho, thank you very much for your prompt response. The duplicates are actually the combination of the addressid and personalnumber together that I want to extract. It's actually xml files that has data and the addressid is from a household that has people, each assigned to a personal number. So in the end you may have more than one addressid and personal number but should never have the combination of both. Not from the same file and most definitely not from another file.

Currently I have a PHP code that displays my result as shown here http://www.terranceweb.com/Capture.JPG What I would like to have is for my function to compare the combination of the addressid and personalnumber so that they are unique. If there's any duplicates found then tell me what files are affected with the addressid and personalnumber combination. For example: Files: LabourForceSurvey2013_2012-10-17_11-09-26.xml, LabourForceSurvey2013_2012-10-17_14-33-47.xml, LabourForceSurvey2013_2012-10-17_15-56-10.xml, LabourForceSurvey2013_2012-10-17_16-33-22.xml and LabourForceSurvey2013_2012-10-18_08-14-12.xml has duplicate values with an Address id 1234 and Personal number 1 Files: LabourForceSurvey2013_2012-10-17_11-25-36.xml and LabourForceSurvey2013_2012-10-17_14-53-10.xml has duplicate values with an Address id 4567 and Personal number 1 etc $this->bestandAddrPers[] = array( "bestand" => $file, "addressid" => $addressid, "personalnumber" =>$Q2); private function displayDuplicate($_ARRAY) { foreach ( $_ARRAY as $key => $val ) { foreach ( $_ARRAY as $key2 => $val2 ) { if ( $key == $key2 ) continue; if ( $val['addressid'] == $val2['addressid'] && $val['personalnumber'] == $val2['personalnumber'] ) { // Duplicates are shown here } } } } Much thanks in advance.

Thank you very much guys, I really really appreciate it!

I have a multidimensional array as follows below: $_ARRAY=array( array("a"=>"File1.xml","b"=>1111,"c"=>"1"), array("a"=>"File1.xml","b"=>1111,"c"=>"2"), array("a"=>"File2.xml","b"=>2222,"c"=>"1"), array("a"=>"File2.xml","b"=>2222,"c"=>"1"), array("a"=>"File3.xml","b"=>3333,"c"=>"1"), array("a"=>"File3.xml","b"=>1111,"c"=>"2") ); As you can tell from above there are 2 duplicates (File1.xml B and C combination is the same as File3.xml B and C combination) and I would like to have a check that shows duplicates with the file name that is associated with those duplicates. Any help is greatly appreciated. Much thanks in advance.