I am using mySQL 3.23
Each project has a work type associated with it, currently the Work Type
column of the Project table holds the work type name, however i have now
added a Work_Type_ID column to the Work_Type table and i would like Projects
to hold the Work_Type_ID as opposed to the Work Type Name.
Thanks for your help
"Jeff Shapiro" <[EMAIL PROTECTED]> wrote in message
> It all depends on what database server (and version) you are using. I'm
> not really sure what you are asking, and could use a little more detail
> about the tables and what are needing to do.
> On Sat, 4 Oct 2003 13:45:56 +0100, Shaun spoke thusly about [PHP-DB]
> Help With Another UPDATE Query Please!:
> > Hi,
> > I am making some alterations to my Database. I have a table called
> > and a table called Work_Types. Projects currently contains the name of
> > work type (Work_Type) but now I want to change this so it contains the
> > Work_Type_ID, is it possible to update Projects with one query?
> > Thanks for your help
> Listserv only address.
> Jeff Shapiro
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php