Skip Site Navigation «

dbrowse

app«dbrowse
MySQL

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

Table laz.feed: Selected data.
mysql> select fid,nid,title
mysql> from laz.feed;
fid nid title
44 rows in set (0.0006 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

Last updated: Friday, October 31st, 2008 @ 3:15 AM EDT [2008-10-31T07:15:33Z]   home

(c) 2008-2010, Douglas W. Clifton, loadaveragezero.com, all rights reserved.