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 derfloh 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: *

  1. marinelli82

    Error by sending a SELECT query

    Hello Sometimes when I send the following SQL-Query to the MySQL server I get an error and the whole MySQL server needs to be restarted.. The odd thing is that I don´t get that error every time when I send that query... I hoped that maybe someone of you could help me The error (translated...
  2. marinelli82

    foreach loop, clever or not?

    Hello again Thanks a lot for your posting, I guess that is exactly the SQL-query I was looking for! =) I just still don´t get what the "GROUP BY" statement with all those fields as paramters is good for. Also I can´t quite figure out the difference between the "WHERE" and the "INNER JOIN"...
  3. marinelli82

    foreach loop, clever or not?

    Hi again First, thanks for your fast answer! I had no idea how incredible inefficient a query in a loop could be =) Your advice to use another join to solve my problem sounds good but then I partly receive double data records because the relation between sd.kkmID and kkms.kkmID is 1:n . So I...
  4. marinelli82

    foreach loop, clever or not?

    Hello again, I am working on a PHP 5 MySQL 4.1 projekt with several tables. The system later will run at a local server on an intranet. I am not really experienced in using MySQL. My problem is that I fetch data from different tables and then for each record I have to use a foreach-loop to...
  5. marinelli82

    SQL-Query too long?

    Hello, I am quite new at MySQL, and that forum =) My question is how long SQL-queries may be.. because I have several tables in my database and have to link some of them to get my wished data.. Now I could send my request by one SQL statement: SELECT ma.benutzername, at.abteilung, sd.datum...

Part and Inventory Search

Back
Top