SQLFilter: I'm struggling with a specific SQL query. I have 2 tables, 'questions' and 'answers', which are linked by a field in answers. I would like to select the questions which have the most answers in the last 24 hours. [more inside]
posted on Jul 19, 2008 - 2 answers

Which version of PHP should I start to learn, and how? I know HTML and CSS, and intend to build with Drupal (or similar) and its many extensions. [more inside]
posted on May 4, 2008 - 12 answers

MySQL sorting issue. When I have "first name" and "last name" columns, and I'm sorting primarily by "last name." Some entries have only a "first name," and rather than have those end up at either the start or end of the sort, I'd like it to pretend the "first name" IS the "last name" and sort accordingly. Is there a way to do this with the SQL SELECT statement or should I just edit the data? [more inside]
posted on May 2, 2008 - 8 answers

Sum of data for all months, including months with no rows, in MySQL? [more inside]
posted on Nov 15, 2007 - 7 answers

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 on Sep 3, 2007 - 10 answers

Recommendations for a book to teach myself php and MySQL? [more inside]
posted on Nov 20, 2006 - 8 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 on Mar 9, 2006 - 14 answers

On the Mac, if I need to munge text in extremis, I prefer to use BBEdit. Recently, on the PC, I am finding myself in need of a text editor which is similar to BBEdit. I will use it both for coding and for text-cleaning. I prefer freeware and shareware but that's by no means the deciding factor. Which programs should I check out? Which should I avoid? [more inside]
posted on Mar 16, 2005 - 21 answers

myPHPadmin : I'm trying to get it to run an line of MySQL and it's complaining. Anyone got any thoughts? [MI]
posted on Nov 4, 2004 - 9 answers