Very cool - thanks =)
Question for you... the next issue I'm addressing is that this
system will work very easily for storage of straight html. Do
you have any recommendations on how to integrate graphics into
these documents?
-Ed
> Simple.. Two tables something like this (MySQL specific):
>
> create table docs (
> docid int(4) unsigned default '0' not null auto_increment,
> doctitle varchar(255) not null,
> synopsis blob not null
> primary key (docid)
> );
>
> create table pages (
> pageid int(4) unsigned default '0' not null auto_increment,
> docid int(4) unsigned not null,
> pagetitle varchar(255) not null,
> seq int(4) unsigned not null,
> pagetext blob not null,
> primary key (pageid)
> );
>
> The one-many relationship between docs.docid and pages.docid should be
> evident, and tell you all you need..
>
> Make sure you addslashes() before inserting into the blob fields, and
> stripslashes() when pulling back out of blobs.
>
> Here's a sample SQL statement that will grab page 3 of document number 17.
>
> SELECT
> d.doctitle, p.pagetitle, p.pagetext
> FROM
> pages p, docs d
> WHERE
> d.docid = 17 AND d.docid = p.docid AND p.pageid = 3;
>
> --
> Jason Costomiris <><
> Technologist, cryptogeek, human.
> jcostom {at} jasons {dot} org | http://www.jasons.org/
>
>
> --
> To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe"
> as the Subject.
>
>
--
To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe"
as the Subject.