fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
Sorry, I don't follow.
-
No, I don't.
-
I have no idea what you'er trying to do, but CASE, as you've used it, is the wrong idea.
-
* and GROUP BY don't mix.
-
You cannot use * and GROUP BY.
-
What's wrong with a JOIN?
-
A single column can only contain a single value.
-
What is the correct JOIN to use for 3 tables for output
fenway replied to geekisthenewsexy's topic in MySQL Help
Don't mix LEFT and RIGHT. -
LOAD DATA from the server requires different perms.
-
if $pm_count works, then it's not a mysql issue.
-
Then you need to use GROUP BY.
-
If you're talking about mysql user variables, you need to assign with :=, not =.
-
The latter.
-
I don't understand -- what do you men "not allowing".
-
Of course you need to worry -- and there's no where clause.
-
Dump the resultset and see.
-
Yes.
-
SPs are useful for a lot of things -- but if you're the only one accessing this DB, then don't bother.
-
Use IN, not -.
-
Sorry, I don't follow.
-
How to retrieve correct number of records from 3 tables
fenway replied to geekisthenewsexy's topic in MySQL Help
This is getter rather lengthy, and now it's regressing into the realm of syntactical php errors.... -
That's formatting for output -- leave the raw numbers alone.
-
Sorry, I don't follow.
-
Database table to be incorporated into HTML form value=""
fenway replied to genzedu777's topic in MySQL Help
What does this have to do with user? -
Then you're not getting your die() properly -- drop all that OO stuff until you can get an error to be thrown.