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 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

Table laz.news: Selected data.
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

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.