[PHP] Hulp bij RSS Feed

Hee One2xs,

Ik ben bezig met het opzetten van een RSS Feed van mijn database. Alleen krijg ik de error: Could not execute query. Terwijl ik zeker weet dat ik de goede query heb ingevuld (Muziek).

[COLOR= #0000BB]<?php[/COLOR]
    [URL="http://www.php.net/header"]header[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Content-Type: application/rss+xml; charset=ISO-8859-1"[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/DEFINE"]DEFINE[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]DB_USER[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]***********[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/DEFINE"]DEFINE[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]DB_PASSWORD[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]*********[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/DEFINE"]DEFINE[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]DB_HOST[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]localhost[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/DEFINE"]DEFINE[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]DB_NAME[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]***********[/COLOR][COLOR= #007700]);[/COLOR] 

    [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<?xml version="1.0" encoding="ISO-8859-1"?>[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<rss version="2.0">[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<channel>[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<title>My RSS feed</title>[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<link>http://www.mywebsite.com</link>[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<description>This is an example RSS feed</description>[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<language>en-us</language>[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<copyright>Copyright (C) 2009 mywebsite.com</copyright>[/COLOR][COLOR= #007700];[/COLOR]

    [COLOR= #0000BB]$connection[/COLOR] [COLOR= #007700]= @[/COLOR][URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR]DB_HOST[COLOR= #007700],[/COLOR] DB_USER[COLOR= #007700],[/COLOR] DB_PASSWORD[COLOR= #007700])[/COLOR]
        or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]Could not connect to database[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR]DB_NAME[COLOR= #007700])[/COLOR]
        or [URL="http://www.php.net/die"]die[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]Could not select database[/COLOR][COLOR= #007700]);[/COLOR]

    [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT * FROM Muziek ORDER BY date DESC"[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]"Could not execute query"[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700])) {[/COLOR]
        [URL="http://www.php.net/extract"]extract[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700]);[/COLOR]

        [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<item>[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<title>[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$title[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]</title>[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<description>[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$description[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]</description>[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<link>[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$link[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]</link>[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<pubDate>[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/date"]date[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"D, d M Y H:i:s O"[/COLOR][COLOR= #007700],[/COLOR] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$date[/COLOR][COLOR= #007700])) .[/COLOR] [COLOR= #DD0000]</pubDate>[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]</item>[/COLOR][COLOR= #007700];
    }[/COLOR]

    [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]</channel>[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$rssfeed[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]</rss>[/COLOR][COLOR= #007700];[/COLOR]

    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$rssfeed[/COLOR][COLOR= #007700];[/COLOR]
?>

Als beloning 0,1 voor de goede oplossing.

Alvast bedankt,
Steven

Backticks om muziek al geprobeerd? ( ` ` )

Jep, zelfde error.

Waarom bij een var; or die?

Bij het weghalen van de "or die" kreeg ik de error:

mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <URL>

.

Iemand raad?

Dan kan hij geen waardes vinden in de table Muziek, heb je de table naam in de database gecheckt op hoofdletters?
Verder kan ik er niks van maken..

Jep table Muziek staat vol, en het begint idd met een hoofdletter.

verander de table naam zonder hoofdletter? dit kan wel eens het probleem zijn..

$result = mysql_query($query) or die (mysql_error());

doe s dat

Zet in de die() eens mysql_error()

Jepperdepep! Het is gelukt, danke danke danke.

bedankt voor de punten, maar had niet gehoeven