getting rows by an ID field or by another field in a table
| From: | Eternity Records Webmaster | Date: | Tue, 06 Dec 2005 19:42:34 +0000 |
| Subject: | getting rows by an ID field or by another field in a table | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-40768@lists.php.net to get a copy of this message | ||
I have a table with the fields:
CREATE TABLE
journal (
Date date NOT NULL,
subject varchar(100) NOT NULL,
entry longtext NOT NULL
) TYPE=MyISAM COMMENT='Journal table';
I was wondering if I should get the rows out by an ID field of some kind or
maybe do a select on the subject? what would be the real best way? I am
trying to get the date/subject to list on a webpage in a table and then when
someone clicks on the subject (it will be a link), it will take them to a
popup window (target=_blank) and then display the whole entry
date/subject/entry. whats the best practice for that sort of thing?
thanks