All

548 reputation

1517

bio	website	phpfreaks.com
	location	United States (but travelling)
	age	34
visits	member for	1 year, 8 months
	seen	Jun 13 at 10:19
stats	profile views	36

I am not a handy programmer but I play with php with a hope to develop creative ideas.

	548 reputation	bio	website	phpfreaks.com	visits	member for	1 year, 8 months
1517 badges		location	United States (but travelling)		seen	Jun 13 at 10:19

summary answers questions tags badges favorites bounties reputation activity

175 Actions

suggestions reviews revisions comments badges posts accepts all

Feb 18	awarded	Popular Question
Jan 9	comment	How to re-arrange rows to best fit within groups? This method will change the `order in cat`, which is the main requirement. It is needed to preserve the order in each category. The flexibility is where categories are mixed.
Jan 8	awarded	Promoter
Dec 22	revised	How to re-arrange rows to best fit within groups? added 107 characters in body
Dec 22	accepted	Multiple “GROUP_CONCAT”s with WHERE clause
Dec 22	comment	Multiple “GROUP_CONCAT”s with WHERE clause I think the first solution is simple and elegant and well fit with my need.
Dec 22	asked	Multiple “GROUP_CONCAT”s with WHERE clause
Dec 21	revised	How to mix pairs of rows without JOIN (in a temporary table)? added 2 characters in body; edited title
Dec 21	comment	How to mix pairs of rows without JOIN (in a temporary table)? @JeremySmyth `mysql` does not support `JOIN` to self on temporary tables. Temporary tables can be referenced only once in a query.
Dec 21	asked	How to mix pairs of rows without JOIN (in a temporary table)?
Dec 20	accepted	How to re-assign two variables in a conditional UPDATE
Dec 20	comment	How to re-assign two variables in a conditional UPDATE very subtle solution, and I enjoyed your useful presentation!
Dec 20	revised	How to re-assign two variables in a conditional UPDATE edited title
Dec 20	asked	How to re-assign two variables in a conditional UPDATE
Dec 20	accepted	How to UPDATE a column to SET previous row value to NULL cells?
Dec 19	revised	How to re-arrange rows to best fit within groups? added 249 characters in body
Dec 19	asked	How to re-arrange rows to best fit within groups?
Dec 19	accepted	How to categorize rows by SUM of a column in mysql?
Dec 17	revised	How to categorize rows by SUM of a column in mysql? edited body
Dec 17	comment	How to categorize rows by SUM of a column in mysql? @dezso why subquery is not slow? subquery needs to conduct the process row by row. Am I wrong?