fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
You needed "IS NULL", not a NOT IN.
-
Then you looked up something else.
-
<h2> is an html attribute -- not mysql.
-
Altering WHERE clause to avoid duplicate entries
fenway replied to horseturtle's topic in MySQL Help
That doesn't make sense -- you can't random mix cities from one country with another country??? -
LEFT JOIN.
-
SHOW GRANTS.
-
Why 100-?
-
There should be no need for the command line with a MySQL database.
-
Yeah, you need joins. And mysql_result() is crazy slow.
-
That's your entire script -- narrow it down.
-
You can't fix the query without the index.
-
MySQL can handled thousands of statements per second.
-
Then you _are_ repeating things.
-
Yikes -- how come you don't have any indexes?
-
It will "work", but it's preferable to keep the password in scipt.
-
Without a subquery, that's not possible -- because you'll only be able to use that value from the policies table.
-
See here.
-
That's not a robust solution.
-
You're new -- so I've added the code tags for you -- but this is required as per the ToS. In terms of your actual question, you need a join
-
I think the child board has a sticky on this.
-
Are you telling me that you don't use the DB for anything else on the page? If you don't care about accuracy, use INSERT DELAYED.
-
Well, you could just iterate through them backwards, or reverse() the recordset. But if you use a subquery, you can re-order them in mysql, too.
-
FIND_IN_SET(), perhaps.
-
TLDR... can you be much more specific?
-
Well, that's up to you -- you use an "eq" in your php code, and you're not even inspecting the password value via mysql.