I need suggestion..

From: Date: Sat, 29 Sep 2001 18:29:27 +0000
Subject: I need suggestion..
Groups: php.db 
Request: Send a blank email to php-db+get-12842@lists.php.net to get a copy of this message
Hello All, I need your suggestion, becouse I am starting with PHP and DB. I have website, and on main menu button "Culture" . There is such sub menu: 1. Exhibitions 2. Galleries Information about exhibitions and galleries, must be outputed from DB. There two ways to do this: 1. Create table culture, there field "type" (gallery or exhibition) 2. Create two different tables - galleries and exhibitions. 1 method is OK for me at the mean time, becouse events in (galleries and exhibitions) as I see know, needs the same fields, no difference. But maybe in future I need to add some field only to galleries or to exhibitions but not to both, so I'll face problems, yes? On the method 2 , maybe I'll have difficulties making search system - I'll need to make search, what are culture events, for example from date1 to date2, and no metter if it is gallery or exhibitions, I'll need them put out in to the same window.. How expierienced programmers do this? Thanks..

« previous php.db (#12842) next »