I am the VP of Sales at screen-scraper in Provo, Utah.

Jun
22
awarded Commentator
Jun
22
comment MySQL multiple join, multiple sort maintain group
I'm sorry, I messed up in the sample data of the transaction which I had posted originally. I have now replaced the transaction with this: link. So, yes, Kimberly Krook and Officer Law are the same person, however, they are entered in more than once because they are both party to two separate suits. I corrected the sample data now to reflect the proper case numbers.
Jun
22
revised MySQL multiple join, multiple sort maintain group
deleted 8325 characters in body
Jun
22
comment MySQL multiple join, multiple sort maintain group
I think you're referring to my GROUP BY (I edited your post). I tried what you suggested and it does group by the secondary and tertiary clause. I'm looking to sort the output, say, alphabetically or numerically by given fields. So, although, they are being grouped properly, the output is not sequential. Thank you for your point regarding sp.party_id being unnecessary.
Jun
22
awarded Student
Jun
22
awarded Editor
Jun
22
revised MySQL multiple join, multiple sort maintain group
Added SQL Transaction for use in creating tables and sample data.
Jun
22
comment MySQL multiple join, multiple sort maintain group
If I add p.name, c.charge_code after the existing sp.party_id, sp.suit_id then nothing changes. If I add p.name, c.charge_code in place of the existing sp.party_id, sp.suit_id then the suit_id's no longer group properly.
Jun
21
comment MySQL multiple join, multiple sort maintain group
I would like to be able to adjust the sorting at will. Including sorting on fields not represented in the sample output (i.e. p.last_name, p.state, etc.).
Jun
21
comment MySQL multiple join, multiple sort maintain group
Changing the ORDER BY clause in the sub-query doesn't affect the order, either.
Jun
21
comment MySQL multiple join, multiple sort maintain group
Tried that just now and it didn't affect the sorting. The order stayed the same.
Jun
21
asked MySQL multiple join, multiple sort maintain group
May
15
awarded Supporter
Oct
20
awarded Teacher
Jun
15
answered ethical/legal consideration when redirecting
Jun
1
comment How can I keep the print version of my Drupal pages showing up in Google's search results?
Oh, and thanks for pointing out the remove URL's feature of WT. I did that, as well.
Jun
1
comment How can I keep the print version of my Drupal pages showing up in Google's search results?
Yes, my robots.txt file does return 200 and is being read by Google. I'll wait to see what happens. Thanks, again.
Jun
1
answered How to create dynamic video/slideshow from pictures in PHP
May
31
comment How can I keep the print version of my Drupal pages showing up in Google's search results?
Thanks, @SteveH. I added /book/export/ as a disallow to my robots.txt. Now I'm just waiting for Google's indexing to update. Do you happen to know of any tricks to expedite this? I used Google's Webmaster Tools six days ago to "Fetch as Google" but the print pages are still showing up in search results. Perhaps I'm being impatient.
May
31
comment How can I keep the print version of my Drupal pages showing up in Google's search results?
I couldn't figure out how to set up conical URLs for this situation. If you have any examples I would appreciate it.
1 2 3