Re: Help on repeated data?

Isn't your issue more about your database schema? If you have "repeating values" such as Flordia project name and lets say is in your employee table Then what you need to do is create a table called Project - project_id, project_name (eg: Flordia project) and a joint entity called Assign - assign_id, employee_id, project_id Hope that helps looking forward to your feedback. dannyh dannyh@idx.com.au On Tue, 24 Oct 2000, Wee Chua wrote: > Hi all, > Is it possible to make the repeated data blank? For example, how could I > just show Florida project name once instead of showing on the first three > rows below? Can this problem be solved under Mysql or PHP? > Thanks a lot for any help > > Calvin > > > > > > > <<...OLE_Obj...>> > > -- > --------------------------------------------------------------------- > Please check > "http://www.mysql.com/documentation/manual.php" before > posting. To request this thread, e-mail mysql-thread54021@lists.mysql.com > > To unsubscribe, send a message to: > <mysql-unsubscribe-dannyh=idx.com.au@lists.mysql.com> > > If you have a broken mail client that cannot send a message to > the above address (Microsoft Outlook), you can use: > http://lists.mysql.com/php/unsubscribe.php