fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
You can't use a subquery to examine a table created in another subquery.
-
Huh?
-
Wait -- you just want to show the first 5 awards a given member has? Simple JOIN with LIMIT.
-
Please, please stop posting all of your code.
-
But you shouldn't.
-
You have two things called "invoiceTable"?
-
6 seconds? Memory limit?Something else is wrong.
-
5.1 has a event scheduler... but cron really is the way to go.
-
Sorry, what's the problem?
-
That's nice -- how?
-
I'm just saying that you're getting no server-side benefit from the UNION.
-
Inserting a blank line in a repeating table fed by a database
fenway replied to s6xbucks's topic in MySQL Help
That's a PHP issue -- you can decide how to format your output as you see fit. -
I'm happy to answer any specific questions that you have -- but forgive me, I'm not going to do your assignment for you.
-
This is a basic php question -- you're not using variables.
-
I answer this all the time the same way -- http://explainextended.com/2009/03/06/advanced-row-sampling/.
-
Inserting a blank line in a repeating table fed by a database
fenway replied to s6xbucks's topic in MySQL Help
What's a repeating table? Blank row where? MySQL has no "blank" rows. -
You must have something.
-
See here -- don't double-post next time.
-
Sounds like homework -- it's due tomorrow and you're just starting today? What do you have thus far?
-
You want a random 2 from each list/
-
You mean only members that are part of 2 lists?
-
I think you're confusing sematic AND with boolean AND.
-
Solved how?
-
Then you'll need to a add a whole bunch of NULLs. Or handle this in script, since you're getting little benefit from combining them server-side.
-
I don't follow.