«
dbrowse
Selected Data
This node is informative, descriptive, functional and terminating.
[definitions]
Query Path
Interactive Path
Description of Results
This MySQL table contains a list of the news feeds for the dnews application. Each feed is a child of one parent in the container table news, and this relationship is established via the foreign key nid. I have omitted the RSS URIs from the output for reasons of brevity, but it is a simple matter of finding a good quality source, and then inserting it into the correct table row for that feed.
To better understand the schema for dnews, step back a node to view the feed table structure.
By popular demand, I have authored a tutorial which documents the dnews implementation details, including PHP and CSS source code.
Give it a read if this interests you.
Node/View
| mysql> select fid,nid,title | ||
|---|---|---|
| mysql> from laz.feed; | ||
| fid | nid | title |
| 44 rows in set (0.0007 seconds) | ||
| 1 | 1 | PHP.net News |
| 2 | 2 | Developer News |
| 3 | 3 | XML News |
| 4 | 4 | RSS News |
| 5 | 4 | Web Developer |
| 7 | 4 | Webmaster Tips |
| 8 | 4 | XML and Metadata |
| 9 | 5 | Linux and Open Source |
| 10 | 6 | drx:Recent Additions |
| 12 | 7 | tag:PHP |
| 13 | 8 | Links |
| 14 | 9 | programming |
| 15 | 10 | Mozilla News |
| 16 | 11 | Developers |
| 17 | 11 | Apache |
| 18 | 11 | Apple |
| 19 | 11 | BSD |
| 20 | 11 | Linux |
| 21 | 13 | Developer Buzz |
| 22 | 15 | tag:programming |
| 23 | 16 | Latest PHP Entries |
| 24 | 17 | Newest Extensions |
| 25 | 18 | Daily News |
| 26 | 19 | Linux News |
| 27 | 20 | Mac Developer News |
| 28 | 21 | OS News |
| 29 | 32 | News and Announcements |
| 30 | 22 | Cool Stuff |
| 31 | 23 | Search Engine News |
| 32 | 24 | News Desk |
| 33 | 25 | fine hypertext feed |
| 34 | 26 | Blog News |
| 35 | 27 | Open Source and Linux News |
| 36 | 28 | Internet News |
| 37 | 29 | Developer Blogs |
| 38 | 30 | PHP News |
| 39 | 31 | Database News |
| 40 | 33 | blogZero |
| 41 | 34 | Recent Developer News |
| 42 | 35 | Web 2.0 This Week |
| 43 | 36 | The Farm |
| 44 | 37 | Ajaxian |
| 45 | 38 | Devmo News |
| 46 | 17 | Updated Extensions |


























































































