«
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 feed sources for the dnews application. Each source has a primary key nid, a site name label, and an image basename that forms both the navigation list icons and the news feed banner image and link. Feed instances are stored in a table named feed. Go figure! The two tables are linked via the nid foreign key.
To better understand the schema for dnews, step back a node to view the feed table structure.
By popular demand, I have authored a howto document which describes the dnews implementation details, including PHP and CSS source code.
Give it a read if this interests you.
Node/View
| mysql> select * | ||
|---|---|---|
| mysql> from laz.news; | ||
| nid | site | img |
| 36 rows in set (0.0005 seconds) | ||
| 1 | PHP.net | php |
| 2 | ONLamp.com | onlamp |
| 3 | XML.com | xmlcom |
| 4 | Moreover | moreover |
| 5 | NewsForge | newsforge |
| 6 | loadaverageZero | laz |
| 7 | Technorati | technorati |
| 8 | Waxy.org | waxy |
| 9 | digg | digg |
| 10 | mozillaZine | mozillazine |
| 11 | Slashdot | slashdot |
| 13 | Artima | artima |
| 15 | delicious | delicious |
| 16 | Furl | furl |
| 17 | Firefox | firefox |
| 18 | Planet PHP | planet |
| 19 | Linux Journal | linuxjournal |
| 20 | MacDevCenter | macdevcenter |
| 21 | OSNews.com | osnews |
| 22 | 43Folders | fortythree |
| 23 | Search Engine Journal | sejournal |
| 24 | Ars Technica | ars |
| 25 | kottke.org | kottke |
| 26 | MagpieRSS | magpie |
| 27 | OSDir.com | osdir |
| 28 | Netcraft | netcraft |
| 29 | Sitepoint | sitepoint |
| 30 | PHP Magazine | php-mag |
| 31 | ONLamp.com | oreillydb |
| 32 | loadaverageZero | drx |
| 33 | loadaverageZero | blogzero |
| 34 | Builder UK | builder |
| 35 | TechCrunch | techcrunch |
| 36 | tucows | tucows |
| 37 | Ajaxian | ajaxian |
| 38 | Mozilla Developer Center | mozilla |























































































