From two MySQL tables, I need to fetch a list of customers who DOES NOT have an invoice issued to them within the past 2 months. More details about the table structures inside. [more inside]
posted by arrowhead
on Sep 3, 2007 -
10 answers

Rather than updating the entire table every time a user updates a form (their profile page, for instance), I'd like the quickest way to detect ONLY the edited fields, and update those accordingly.
[more inside]
posted by arrowhead
on May 10, 2007 -
13 answers

I'm writing a small app to store my contacts. There's a little tool to search for names. When I search for "Jo", the results should display all names starting with "jo", followed by those with "jo" in the middle:
1. Joanna
2. John
3. Jonathan
4. Marjorie
5. Mojo
How do I do this using a single SQL statement?
posted by arrowhead
on Mar 9, 2006 -
14 answers

I am tasked with writing a web-based accounting software in PHP-MySQL. My background in accounting is minimal. I understand enough of debits & credits & transactions and such, but I'd like to find some resources which could help me in working out the programming workflow, database relationships, etc, ie the technical parts of developing such a system.
posted by arrowhead
on Aug 6, 2005 -
14 answers

About Ask MetaFilter

Ask MetaFilter is a question and answer site that covers nearly any question on earth, where members help each other solve problems. Ask MetaFilter is where thousands of life's little questions are answered.