fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
Aliasing is all but free... though it does give the parser a bit more work to do.
-
Well, you can use OR or a UNION.
-
That's not a query, that's php code. And what does "not work" mean?
-
Sorry, I have no idea what you're talking about. Give an example of what you would call a "check number".
-
Error: MySQL exceeded 'max_user_connections' active connections?
fenway replied to Some Poster55's topic in MySQL Help
Are you using persistent connections? -
If you're not actually profiling these, it's meaningless.q
-
Why not link the review to the a UID in the many-to-many Business<=>Location.
-
Having trouble appending a page redirect to a php function
fenway replied to green917's topic in PHP Coding Help
I see lots of php code, a single mysql_query() call, and no actual query. -
Sorry, I thought your 2nd output block was the table structure -- my bad. This is called a "cross-tab" -- and you can easily pre-generate the query from the max # of laps.
-
And don't post your entire script.
-
No: ORDER BY Flagged DESC, Redeemed ASC, Field(AccountType ,'1 Month','2 Month','1 Year','2 Year')
-
So what?
-
Yes, storage is worse. Yes, comparing this value to another number is slower. Yes, MySQL will let you do it. But don't.
-
Actually, it's quite illogical to store a number as anything but a number.
-
This has nothing to do with FULLTEXT.
-
Yup... as long as there are no other values for AccountType, that will work -- a non-match will return 0, so it gets more complicated.
-
If you're still having trouble, this thread really should be in the PHP Coding Help forum... let's wait and see.
-
select id and check if no more of that id is found on the same table
fenway replied to nvso's topic in MySQL Help
I'm not sure I follow.. you don't want to select them, or you want to delete them? -
Yikes... stop posting all that code without code tags. And give people on the boards a chance to answer first. Don't alias any column that doesn't need to be different (i.e. don't collide). The table doesn't come through into the column name. INNER JOIN and "JOIN" are synonymous. And DISTINCT is not a function.
-
And that's precisely why you should normalize your tables.
-
You should just use ORDER BY FIELD() instead.
-
(a) column1 + column2 + column3 + column4 + column5 AS sum.... ORDER BY sum DESC (b) ORDER BY ( column1 + column2 + column3 + column4 + column5 ) DESC
-
Sounds like you want a simple 3-table join.
-
No reason why you can't (a) add them and order by the alias or (b) just order by the expression.
-
Post the table structure... should be as simple as a count90.