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
How can I connect to a SQL Server 2005 database using windows authentication with PHP? [more inside]
posted on Mar 20, 2008 - 6 answers
I'm planning on starting a database freelancing business. I understand a lot of people prefer Microsoft Access or FileMaker. With the current evolving trend of applications going on the web and add to that my somewhat good experience with PHP, HTML, Javascript and CSS I'm seeking a cross platform efficient application environment. This is why I believe Access and FileMaker are not an option, I'm also more experienced with high level languages than I am with Access or FileMaker. [more inside]
posted on Mar 13, 2008 - 11 answers
I'm looking for a way to organize a list of members of my neighborhood association, preferably something web-based, but that doesn't require the actual members to log in. [more inside]
posted on Feb 11, 2008 - 5 answers
For database usage, is it better to store data in XML or serialized format? In particular, PHP serialization. [more inside]
posted on Jan 18, 2008 - 10 answers
How do I query data from one MySQL table, but I also need to get a single piece of data from a second table too? Should I be doing a JOIN, or a separate query? [more inside]
posted on Jan 7, 2008 - 9 answers
Sum of data for all months, including months with no rows, in MySQL? [more inside]
posted on Nov 15, 2007 - 7 answers
WordPressFilter: Can I do something like this site with WordPress? [more inside]
posted on Sep 16, 2007 - 8 answers
How do I make sure a page loads with a fresh copy and not from the users cache? [more inside]
posted on Aug 9, 2007 - 7 answers
What are the best database-driven Web application development frameworks out there right now? More specifically, please orient me to toolsets you know of that are similar to Ruby on Rails. [more inside]
posted on Jul 6, 2007 - 17 answers
An 800 item database driven site in PHP and MySQL? Am I crazy? [more inside]
posted on Mar 1, 2007 - 21 answers
I have been asked to write a database application that will be running in a storefront situation and will allow the user to enter data on what is sold (in this case, bicycles and bicycle accessories and parts) and generate basic bookkeeping reports (i.e. end-of-day sales, quarterly sales, that sort of thing.) [more inside]
posted on Dec 20, 2006 - 8 answers
How would you write an application in PHP that tracks multiple users, and the users' multiple sites? [more inside]
posted on Dec 5, 2006 - 7 answers
Bridging PHP and Python object serialization [more inside]
posted on Oct 10, 2006 - 7 answers
Are there any free PHP and MySQL based apps for setting up a bootleg trading site? [more inside]
posted on Sep 27, 2006 - 2 answers
MySQL/PHPmyAdmin for a band: How do I easily create a repository of lyrics that can be brought in for multiple albums? [more inside]
posted on Jul 17, 2006 - 8 answers
I know how to make database-driven web sites using Windows servers, Access, IIS, and ASP.
I want to learn how to do the same using Linux, Apache, MySQL, PHP, and... whatever you use instead of Access.
Where do I start?
posted on Dec 10, 2004 - 18 answers
I know, I know -- not another web photogallery AskMe question, but: I've actually settled on the gallery itself. I'm using JAlbum. Having made the choice, though, I'm left with two questions:
1. JAlbum makes nice galleries, but doesn't create a top-level index page. (I could hand-code it, but my wife will be doing most of the updating and I don't want her to have to go mucking around in HTML.) The easiest solution, I'd think, would be just to reformat the directory listing into something attractive -- all I really need to communicate to the user is descriptive folder names and upload dates, but I'd prefer to make something more handsome than the standard Apache page. Can anyone recommend a particular PHP file system manager or other solution?
2. JAlbum's auto upload is ridiculously slow -- better just to FTP it. When JAblum makes a gallery, though, it includes a lot of stuff I'm not using -- icon sets, borders, etc. It's not a ton of space, but I'm going to uploading a lot of these galleries, and it'll add up. Is there a programmatic way I can stop JAlbum from including all this, instead of weeding it out before each upload? (I'm using the BluPlusPlus skin.)
posted on Sep 5, 2004 - 1 answers
I need to set up a database-driven document archive of mostly text files and links. I want the archive to have a tree structure and allow the public to browse it without logging in. I want each file to have a description. I prefer PHP or Perl and need to use it on a shared hosting account. I would think something open source like this would be out there, but I can't find it. Any advice?
posted on Sep 4, 2004 - 2 answers
