[PHP-DB] Help With Another UPDATE Query Please!
Hi, I am making some alterations to my Database. I have a table called projects and a table called Work_Types. Projects currently contains the name of the 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Help With Another UPDATE Query Please!
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 projects and a table called Work_Types. Projects currently contains the name of the 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
Re: [PHP-DB] Help With Another UPDATE Query Please!
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 news:[EMAIL PROTECTED] 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 projects and a table called Work_Types. Projects currently contains the name of the 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