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
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 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 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 on Jun 10, 2007 - 3 answers
Recommendations for a book to teach myself php and MySQL? [more inside]
posted on Nov 20, 2006 - 8 answers
Perhaps advanced MSSQL question.. [more inside]
posted 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 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 on Feb 24, 2006 - 8 answers
I need help with what I hope is a fairly simple mySQL query question. [more inside]
posted 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 on Sep 30, 2005 - 2 answers
