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!
-
Congratulations Chris 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: marinelli82
- Order by date
-
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...- marinelli82
- Thread
- Replies: 0
- Forum: MySQL
-
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"...- marinelli82
- Post #5
- Forum: MySQL
-
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...- marinelli82
- Post #3
- Forum: MySQL
-
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...- marinelli82
- Thread
- Replies: 6
- Forum: MySQL
-
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...- marinelli82
- Thread
- Replies: 1
- Forum: MySQL
