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
(text/plain)