11 posts tagged with PHP and SQL. (View popular tags)
Displaying 1 through 11 of 11. Subscribe:
Tearing my hair out over what feels like a simple PHP/SQL question: mysql_fetch_array returns, dur, an array of all the rows that matched your query. How can I tell it to skip a row of that array? More inside. [more inside]
posted by GilloD
on Jun 27, 2009 -
14 answers
Can anyone give me advice on dealing with checkboxes in PHP, to hand off to SQL. [more inside]
posted by opsin
on Jan 30, 2009 -
8 answers
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
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 by dnash
on May 2, 2008 -
8 answers
Sum of data for all months, including months with no rows, in MySQL? [more inside]
posted by tmcw
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 by arrowhead
on Sep 3, 2007 -
10 answers
Recommendations for a book to teach myself php and MySQL? [more inside]
posted by dripdripdrop
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 by arrowhead
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 by mwhybark
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] [more inside]
posted by twine42
on Nov 4, 2004 -
8 answers