Does anyone know the syntax for updating a MySQL database when you are trying 
to pull the information from another temporary holding table in the same 
database?

My updates are normally accomplished like this,

$query = "UPDATE maindbase SET category1='$cat1', category2='$cat2' WHERE 
somevariable=$z";

I know that to pull the data from the temporary database and insert it as a 
new field in the main database, I would do this,

$query = "INSERT INTO maindbase (category1, category2) SELECT category1, 
category2 FROM tempdbase WHERE somevariable=$x";

I don't want to add a new entry in the database, however. I want to update an 
existing entry. How would I go about blending those two queries to mix pulling 
information from the temporary database and updating a field in the main 
database?

Any thoughts? Thanks!

-- 
Jason Hayes

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss