Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MySqlRuben
  • Order by date
  1. MySqlRuben

    SELECT and UPDATE?

    What I want is to be able to select all columns from the article table and autors table, based on the article name, and, at the same time, update a field in the article table. I really dont know if its even possible to do that in one single query.
  2. MySqlRuben

    SELECT and UPDATE?

    Thanks for answering r937. But then how would I do the other part of the query?
  3. MySqlRuben

    SELECT and UPDATE?

    Hi! I'm a newbie in MySql, so please bear with me. What I want is to select all the informations concerning a specific article, and then to update a field of the resulting query. So, with some help I managed to do something like this $query = sprintf("SELECT CONCAT('UPDATE articles SET...
  4. MySqlRuben

    Multiple Selects - what's the best approach?

    Thanks ESquared for the reply. I must say that I dont understand much of what you just posted. From what I'm understanding, I think that the statement selects all the columns from the autors table and from the articles table and then joins them (?) If you could explain: what the T and A means...
  5. MySqlRuben

    Multiple Selects - what's the best approach?

    Hi! I'm really new to MySql and I was wondering if someone could help get a better understanding of the mechanics of this language. For example, I have two tables: one called 'articles' and other called 'autors'. What I want is to select all the columns from the 'articles' table, based on the...

Part and Inventory Search

Back
Top