Jump to content

Where to apply If statement


adman4054

Recommended Posts

I'm trying to build an RSS feed, I have all the tables and rows identified, but I need to only pull listings with a type designated as "f"

 

Where and how would I use:  
       
" if($listType == 'F') "
              
In the code below,

Thanks in advance!



<?

class RSS
{
    public function RSS()
    {
        require_once ('pathto.../mysql_connect.php');
    }
    
    public function GetFeed()
    {
        return $this->getDetails() . $this->getItems();
    }
    
    private function dbConnect()
    {
        DEFINE ('LINK', mysql_connect (DB_HOST, DB_USER, DB_PASSWORD));
    }
    
    private function getDetails()
    {
        $detailsTable = "webref_rss_details";
        $this->dbConnect($detailsTable);
        $query = "SELECT * FROM ". $detailsTable;
        $result = mysql_db_query (DB_NAME, $query, LINK);
        
        while($row = mysql_fetch_array($result))
        {
            $details = '<?xml version="1.0" encoding="ISO-8859-1" ?>
                    <rss version="2.0">
                        <channel>
                            <title>'. $row['title'] .'</title>
                            <link>'. $row['link'] .'</link>
                            <description>'. $row['description'] .'</description>
                            <language>'. $row['language'] .'</language>
                            <image>
                                <title>'. $row['image_title'] .'</title>
                                <url>'. $row['image_url'] .'</url>
                                <link>'. $row['image_link'] .'</link>
                                <width>'. $row['image_width'] .'</width>
                                <height>'. $row['image_height'] .'</height>
                            </image>';
        }
        return $details;
    }
    
    private function getItems()
    {
        $itemsTable = "webref_rss_items";
        $this->dbConnect($itemsTable);
        $query = "SELECT * FROM ". $itemsTable;
        $result = mysql_db_query (DB_NAME, $query, LINK);
        $items = '';
        while($row = mysql_fetch_array($result))
        {
            $items .= '<item>
                         <title>'. $row["title"] .'</title>
                         <link>'. $row["link"] .'</link>
                         <description><![CDATA['. $row["description"] .']]></description>
                     </item>';
        }
        $items .= '</channel>
                 </rss>';
        return $items;
    }

}

?>

Link to comment
Share on other sites

Since your using mySQL there is not "IF" needed.. this would be more of a mySQL related question.. what you need to do is structure your queries example from existing code posted:

$query = "SELECT * FROM ". $detailsTable;

 

Would be changed to something like..

$query = "SELECT * FROM ". $detailsTable WHERE listType = 'F'";

 

Link to comment
Share on other sites

Thank you Monkeytooth  :D

 

Since your using mySQL there is not "IF" needed.. this would be more of a mySQL related question.. what you need to do is structure your queries example from existing code posted:

$query = "SELECT * FROM ". $detailsTable;

 

Would be changed to something like..

$query = "SELECT * FROM ". $detailsTable WHERE listType = 'F'";

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.