fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
I don't understand what you're tryign to do with the second part.
-
You'll notice that the error doesn't match the posted statement.
-
You can't mix * with GROUP BY.
-
FYI, DISTINCT is not generally useful with *.
-
This is a DB wrapper class error with PDO, not with MySQL.
-
What is set to the current day?
-
How else would it know what values to use?
-
I don't really understand the question.
-
Select all but exclude those that match data in a 2nd table from the result
fenway replied to lancia's topic in MySQL Help
Not certain that LEFT JOIN .. IS NULL wouldn't have work here, but if you have it working, and it's efficient, then ok. -
SELECT from table1, table2, where table1.field1 = table2.field2. POSSIBLE?
fenway replied to JChilds's topic in MySQL Help
This is basically a join. -
I don't follow.
-
You sort of have no choice at at low level -- you need to map user X to user Y.
-
Are they always groups of three?
-
Echo the update statement alone.
-
What are you trying to do again?
-
That's not helpful... we need table definitions for the tables being queried, EXPLAIN output, etc.. see my sig.
-
You're missing the "IS NULL" condition in your where clause.
-
Actually, specify a column list without mentioning the auto-inc field, and you won't need NULL at all.
-
I don't understand that logic whatsoever -- why not just issue a query with LIMIT 15?
-
Echo the actual query, not the php code... but it looks like a version issue.
-
Let's see some EXPLAIN output.
-
You're close... I assume you're using innodb?
-
We'll need to see the actual mysql query, and the relevant table structures.
-
Query to what? You've given us very little information. What selected date?
-
Well, I'd like to see $query echo'ed.