fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
What?
-
How to keep the data of a user's 5 recently viewed pages?
fenway replied to hotdog1983's topic in MySQL Help
Actually, it's much better to use INSERT ON DUPLICATE KEY UPDATE, or REPLACE with a UNIQUE KEY, if you're actually going to maintain a stack. -
This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=347165.0
-
Sorry, I don't know what that means
-
You can store the sum into a user variable that you keep incrementing -- just remember to set it in the same statement.
-
What you show and what you submit shouldn't be the same.
-
JOIN & Query Problem - unique indexes & PKs, converting FoxPro to MySQL
fenway replied to grindstone's topic in MySQL Help
Huh? -
Differences between rows requires a join.
-
What are all of my options when ordering results in a database?
fenway replied to jdock1's topic in MySQL Help
It orders "by" whatever your column type is. -
It's often quite beneficial to have a unique id for each record in each table.
-
I mean you don't care why it was found?
-
You want to order the results by date, regardless of the table of origin?
-
mysql_fetch_assoc() will give you the hash you seek.
-
That's becuase you have GROUP BY.
-
You can't do that -- you can't select non-GROUP BY fields that aren't aggregates. Column2 is likely garbage.
-
Well, you need to tell me how $you, $friend and $username are related first.
-
If you're looking for code for your entire problem, you're in the wrong forum.
-
MySQL has a number of GUI Tools.
-
Well, you'll need to run that count(*) from each username -- which I assume is $you in the first query?
-
Yes, but mysql_result() is very slow.
-
I don't understand what that means.
-
You have part1...part9 -- those are duplicates.
-
Selecting date range using only year and week number
fenway replied to Novocaine88's topic in MySQL Help
You can use STR_TO_DATE() and %V and %X. -
You normalize your database.
-
I'm sorry, you want to group by what?