Alright I was wondering if I could actually use SELECT and UPDATE in the same db query... so I wouldn't have to query the database 2 times... be more productive if i could... Any ideas?
...MySQL's newest development release, Version 4.1, with sub-queries and other new features.
Like the quote states, queries now have the ability to perform and use the result of a query inside the query.
I'm glad you informed me that IT CAN be done, but you gave no further information... where can I get information (don't just say mysql.com) on it, or just show me a couple of examples?
Here are a few links I found:Sub-query Tutorial 1 Sub-query Tutorial 2
