Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002122

Re: [PHP-DB] here's my problem in PHP & relational tables From: Phanivas Vemuri (vas2u <email protected>)
Date: 12/17/02

hi,
I have two tables.

1.ProgramClips ( id, progSummary, category, videoFile)PRIMkey = id.
and each id may have 2 or three categories.

2.Category( number,category).
categories are :
Beef , diary, horticulture etc;

I am using PhpMyAdmin as the interface for the mySql Database.
The PhpMyAdmin uses a text filed to show the values of the category.

If there are two or more categories for example Beef and Diary then "Beef
| Diary" is shown in the text field.

Now I want to change that text field into a drop down list and enable
multiple selection of the values. And if I want to update the category field
in program clips I will select one or more values in the drop down list and
do some programming to put a pipe symbol in between the selected values ( in
order to make MySQL to understand and interpret).

But my Problem is ... how to say to PhpMyAdmin that u change this particular
field a drop down. How to do that in a general sense, so that it does that
always when I use the values which are unique in another table.

Any idea... if u donot understand my problem ... please mail me ... I will
try to be more clear.
Advance Thanks for the patient people,
Phani.

>From: Brad Bonkoski <bbonkosk <email protected>>
>To: Phanivas Vemuri <vas2u <email protected>>
>CC: php-db <email protected>
>Subject: Re: [PHP-DB] newbee in PHP-MySQL- help in relational tables
>Date: Sun, 15 Dec 2002 19:11:04 -0500
>
>I would say, that MYSQL is a relational database, thus implying that tables
>would eb relational and this is a DB forum, so just shot, what's the
>problem?
>
>Phanivas Vemuri wrote:
>
> > hi,
> > I need to knwo if anyone had worked on a php interface for relational
>tables
> > in MySql. I have a problem , would be explaning the problem after anyone
> > responds.
> > Thankyou,
> > Phani.
> >
> > _________________________________________________________________
> > The new MSN 8: advanced junk mail protection and 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php