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 by charmston 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 by prophetsearcher on May 4, 2008 - 12 answers

How many database reads/writes are okay per web page view? Also, what is better, big tables or lots of join tables? [more inside]
posted by markovich on Nov 16, 2007 - 13 answers

Looking for some guidance in building an "advanced search" query using XML and optional multi-value parameters. [more inside]
posted by mkultra on Jun 26, 2007 - 6 answers

What's the best way (using the internet, and/or books) to learn how to query SQL databases with Ruby?
posted by anonymous on Jun 10, 2007 - 3 answers

Recommendations for a book to teach myself php and MySQL? [more inside]
posted by dripdripdrop on Nov 20, 2006 - 8 answers

Perhaps advanced MSSQL question.. [more inside]
posted by eas98 on Jul 31, 2006 - 7 answers

Question for the SQL ninjas in the house. Say you're grabbing data from a bunch of similar tables in a big union. Now say you want the last ten items added anywhere to the database, from any one of those tables. What's the most efficient way to do that? [more inside]
posted by mathowie on May 10, 2006 - 22 answers

I have a Windows-served website programmed in C# and connected to a SQL database. I'd like to move the whole thing to the Mac. [more inside]
posted by thejoshu on Feb 24, 2006 - 8 answers

I need help with what I hope is a fairly simple mySQL query question. [more inside]
posted by Asparagirl on Nov 29, 2005 - 18 answers

I have a MySQL database that contains two fields - name and e-mail - for a bunch of records. Separately I have a FileMaker 7 database that contains the same fields - name and e-mail - and contains other fields, like "notes". My question: can the FileMaker database, after polling the MySQL database, show name and e-mail as read-only; and then show the other fields as editable? i.e. if I make a change to the MySQL database, can I get it to show up in FM? [more inside]
posted by mark7570 on Sep 30, 2005 - 2 answers