PHP - Combined Filter In Php

This feels like it's a complicated one, I'll try to explain it as best I can.   I have a table of players - tplss_players - fields PlayerID, PlayerName I have a table of players who have made an appearance for their team = fields AppearanceID, AppearancePlayerID, AppearanceMatchID I have a table of matches that have been played - MatchID, MatchDate   On the page I am working with, $matchdate is a variable already declared using a $_GET.   To clarify, PlayerID and AppearancePlayerID are related, as are MatchID and AppearanceMatchID.   I want to present one result which tells me the TOTAL amount of appearances made in the past by everyone who appears on that matchdate.   In other words, a team of 11 players played on 13th September 2013, I want to show the total of amount of games all eleven players have played prior to that date.  As a combined figure.   If anyone can offer some help, I'd be extremely grateful.

I have the following PHP code...
$query1 = $this->db->query("SELECT `categories`.`cat_id`, `categories`.`cat_name`, `forums`.`forum_name`
                                        FROM `".$this->dbname."`.`categories`
                                        LEFT JOIN `".$this->dbname."`.`forums`
                                        USING (`cat_id`)
                                        ORDER BY `categories`.`cat_order` ASC");

              $i = 0;
                while($row = $this->db->fetch_assoc($query1))
                {
                    $content .= ($i % 2 == 0 ? '<tr class="odd">' : '<tr>');
                    $content .= '<td><p><a href="index.php?cg=cgs&page=forum&do=forums:'.$row['cat_id'].'">'.$row['cat_name'].'</a></p>';
                    $content .= ' - '.$row['forum_name'].'</td>';
                    $content .= '</tr>';
                    $i++;
                }

I'm getting duplicate rows of the first table (categories) being outputted. So I'm currently getting...
Quote

Crikey Games
- Suggestions and Ideas
Crikey Games
- General Discussion
Crikey Games
- Announcements
Realm Battles
- Bugs, Glitches and Exploits
Realm Battles
- Recruiting
Realm Battles
- General Discussion
Realm Battles
- Suggestions and Ideas
Realm Battles
- Battle Grounds
Realm Battles
- Announcements


When I want to be getting...
Quote

Crikey Games
- Suggestions and Ideas
- General Discussion
- Announcements

Realm Battles
- Bugs, Glitches and Exploits
- Recruiting
- General Discussion
- Suggestions and Ideas
- Battle Grounds
- Announcements


Code: [Select]
--
-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `cat_id` int(10) NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(50) NOT NULL,
  `cat_order` int(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`cat_id`, `cat_name`, `cat_order`) VALUES
(1, 'Crikey Games', 1),
(2, 'Realm Battles', 2);

-- --------------------------------------------------------

--
-- Table structure for table `forums`
--

CREATE TABLE IF NOT EXISTS `forums` (
  `forum_id` int(10) NOT NULL AUTO_INCREMENT,
  `cat_id` int(10) NOT NULL,
  `forum_name` varchar(50) NOT NULL,
  `forum_description` varchar(225) NOT NULL,
  `forum_order` int(5) NOT NULL DEFAULT '0',
  `forum_locked` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`forum_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `forums`
--

INSERT INTO `forums` (`forum_id`, `cat_id`, `forum_name`, `forum_description`, `forum_order`, `forum_locked`) VALUES
(1, 1, 'General Discussion', 'talk about anything you like', 2, 0),
(2, 1, 'Announcements', '', 1, 0),
(3, 1, 'Suggestions and Ideas', 'if you have a suggestion or idea, share it here', 3, 0),
(4, 2, 'Announcements', '', 4, 0),
(5, 2, 'General Discussion', 'talk about anything Realm Battles related here', 5, 0),
(6, 2, 'Battle Grounds', '', 6, 0),
(7, 2, 'Recruiting', '', 7, 0),
(8, 2, 'Suggestions and Ideas', 'if you have a suggestion or idea for Realm Battles, share it here', 8, 0),
(9, 2, 'Bugs, Glitches and Exploits', 'if you have discovered something that needs to be fixed, share it here', 9, 0);

Not sure whether I'm doing something wrong with the PHP side of things, or the MySQL query.

Also I can't figure out how to ORDER BY `forums`.`forum_order` ASC , when trying to add it to this query.

Thanks in advance,
Ace

Hey guys i am using a global filter on my $_POST

function filter($str){return htmlentities($str, ENT_QUOTES);}
$_POST = array_map('filter', $_POST);

It helps me encode the stuff into the database.
It works great on all my fields exept my arrays ...

Ex: fields like this <input type="text" name="name[]" size="20"> breaks

Any sugestions on gething this global filter working?

Hi, I want to use an external rss in my site but the problem is that i only want to grab feeds that contain certain keywords in the title,   This is what i got so far to display the feed:

<?php

$html = "";
$url = "http://www.feedsite.com/conv-rss.asp";
$xml = simplexml_load_file($url);

for($i = 0; $i < 5; $i++){

	$title = $xml->channel->item[$i]->title;
	$link = $xml->channel->item[$i]->link;
	$description = $xml->channel->item[$i]->description;
	$pubDate = $xml->channel->item[$i]->pubDate;

	$html .= "<a href='$link'><h3>$title</h3></a>";
	$html .= "$description";
	$html .= "<br />$pubDate<hr />";

}
echo $html;
?>

The feed is a classified jobs but i only need the jobs listed for musicians, keywords could be: bassist, singer, drummer, musician, etc..    Thanks

Hey,

I have a word filter which is dectecting strings that are only embedded in words. Which i don't want it to do.

For example:

If i want to filter "FR" and some one puts france - it flags it because france contains FR.

How do i make it only look for "FR" on its own seperated from a word instead of it flagging nearly all words with the two letters together?

Heres my filter:


$text = 'testing';  //this should not return 1
  // fill this array with the bad words you want to filter and their replacements
     $bads = array ("test");

                
foreach($bads as $key => $search_needle) {

   if(stristr($text, $search_needle) == TRUE) {
       return(1);
       break;
        }
    }