fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
blockUser.blockID will never be NULL, if the user isn't blocked they won't be on the list. Then you don't understand what a LEFT JOIN does.
-
Is it possible to have one cell in mysql to be listed?
fenway replied to dowsun18's topic in MySQL Help
Your "cell" shouldn't have a number of features. -
Is "skip-networking" on?
-
I mean that "McMahon" is supposed to be sorted before "Mackenzie".
-
If someone other than you selected the credentials, then that someone is the only one who can help you.
-
So why not test it on a live site?
-
Assuming you've stored them separately, of course. Also, alphabetical sorting isn't technically correct when it comes to last names.
-
So, b.*?
-
It's happening because of the space between COUNT and (*).
-
And what did your "website provider" say?
-
Then you're updating the wrong database, or you're not telling us the whole story.
-
See here.
-
I'll second that substring_index() is the way to go.
-
Multi-byte characters vs single-code.
-
Also, we're now down to a pure php logic issue, not MySQL.
-
What's a Criterium? You mean criterion?
-
Why does it matter? Either you have unicode characters or you don't.
-
get AUTO INCREMENT and store into a separate table
fenway replied to SeanHarding's topic in MySQL Help
There's no such thing as a multi-table insert. -
Then you'll need a join -- and if it's many-to-many, you'll need a subquery.
-
You're missing WHERE blockUser.blockID IS NULL.
-
That sounds like a plan doomed to fail.
-
LEFT JOIN blockUser ON ( user.userID = blockUser.blockUserID AND blockUser.blockID != $clientID )
-
Basically, you self-join the table, and find the rows that don't have any greater matching value for CID,
-
You can order by as many expressions as you'd like.
-
Why do you care?