Database Olympics: File Maker Pro vs. MySQL! Help us pick a database system (Anko or Firebrand). Which do you think is superior to run a print publication database? [more inside]
posted on Aug 19, 2008 - 6 answers
I usually design sites using either plain html/css or Wordpress for its CMS capabilities.
However, one client has just asked if there can be a database on his site, which they can add to and visitors/members of the site can purchase "entities" from.
This obviously needs a database with a usable front-end for the client and an ability to connect to a payment gateway to purchase "entities".
Can anyone help advise on a PHP/MySQL package to do this? I do not have the skills to build a database from scratch (I plan to learn, but cannot do so in the timescales needed for this potential assignment), and I'm presuming there must be a solution out there...
posted on Aug 18, 2008 - 4 answers
What CMS would you recommend for my podcast company? [more inside]
posted on Jul 1, 2008 - 11 answers
I'm having some trouble recreating a Drupal site on my local machine for testing/sandbox purposes. The mysql databases are the biggest stumbling block at the moment - very basic, beginner advice is probably needed. [more inside]
posted on Jun 27, 2008 - 7 answers 
Need recommendations for tools (e.g. Crystal Reports) to build reports from a MySQL database. Should be easy enough for a non-programmer to use. What are the pro's and con's of the tool(s)?
posted on Jun 5, 2008 - 3 answers
I've had what I think is a decent idea for a website. Rather than asking someone to "punch it up" in their "spare time" I'd like to learn to do it myself. I know a bit about html and took a turbo pascal class 11 years ago. Since then it's been all humanities, social science, and law. What do I need to learn and what, in your experience, are the best books/web sites to learn from? [more inside]
posted on May 22, 2008 - 8 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
What is the best way to work databases like we does with version control (Subversion or CVS) for the source files?
I was researching but probably I'm not using the right words or there's some special way to work.
posted on Mar 12, 2008 - 19 answers
SQL Filter: What query can I use to count the number of times a word appears in a text field? [more inside]
posted on Feb 21, 2008 - 6 answers
I need to code a form to gather contact information from visitors to my website, and I'm looking for alternatives to mySQL. [more inside]
posted on Feb 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
Career-wise, is it a smart move to take a mysql position after building up ten years of Oracle experience? [more inside]
posted on Sep 18, 2007 - 6 answers
WordPressFilter: Can I do something like this site with WordPress? [more inside]
posted on Sep 16, 2007 - 8 answers
MYSQL question: I want to develop simple input form for our internal office MYSQL. We need to attach files to our product information. I'm using OO, but it doesn't deal with BLOBs what other software could I use to create forms to our database? [more inside]
posted on Aug 20, 2007 - 6 answers
DATETIME, TIMESTAMP, TIME, DATE. Which should I use for general-purpose date storage in a recent MySQL version? [more inside]
posted on Aug 20, 2007 - 16 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
MySQL, why won't you replicate properly? [more inside]
posted on May 29, 2007 - 6 answers
An 800 item database driven site in PHP and MySQL? Am I crazy? [more inside]
posted on Mar 1, 2007 - 21 answers
Is there an easy, preferably open source way of editing MySQL table contents? I was hoping for something which would let me use Excel (or OO Calc) to edit the live database. I need to search/replace many items in a poorly imported database. [more inside]
posted on Feb 6, 2007 - 10 answers
mySQLfilter: How can I ignore "A, An, & The" at the beginning of book titles when sorting results alphabetically by title? [more inside]
posted on Dec 5, 2006 - 10 answers
Mysql5... why won't you accept more connections from a set of IP addresses? [more inside]
posted on Nov 16, 2006 - 12 answers
What is the easiest way to get this data into a MySQL database? [more inside]
posted on Nov 2, 2006 - 19 answers
Stupid database question: what are some quick "viewer" applications my customers can use to work with data I'm providing locally in a mySQL database? [more inside]
posted on Nov 1, 2006 - 10 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
How to improve MySQL (5.0.22-max-log, PPC) + InnoDB table performance? [more inside]
posted on Sep 24, 2006 - 9 answers
How can I make backups of a MySQL database (via mysqldump) and preserve Unicode characters (such as em dashes)? [more inside]
posted on Aug 28, 2006 - 8 answers
I work at a small non-profit book publisher, and I need to build a database for our website. [more inside]
posted on Aug 9, 2006 - 23 answers
MySQLFilter: Help me with my 56 million record table! Lots of cumbersome background inside... [more inside]
posted on Jul 19, 2006 - 12 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 need help converting a Postgres-specific SQL query to MySQL [more inside]
posted on Jul 14, 2006 - 14 answers
Need a tinker-free Linux/MySql install for Ruby On Rails. Also, seeking advice for getting started in RoR. [more inside]
posted on Jun 27, 2006 - 19 answers
I'm working on a website for my band, and I would like to have a section on the main page which lists news items. I don't want to have to edit the html file every time I want to add an update though. I'd like it to run from a database or something, so can I set something up to display the 5 most recent database entries on my website? [more inside]
posted on May 22, 2006 - 11 answers
How can I implement bi-directional synchronized table changes in a mySQL database and Microsoft Access? [more inside]
posted on Apr 19, 2006 - 6 answers
Can anyone point me to a good documentation/samples for building an app using mod_python and cheetah? (and mySQL/DBUtils etc)? [more inside]
posted on Feb 14, 2006 - 2 answers
What is the best alternative interface for an SQL server? [more inside]
posted on Jan 12, 2006 - 6 answers
I need help with what I hope is a fairly simple mySQL query question. [more inside]
posted on Nov 29, 2005 - 18 answers
MySQL Hell: I've spent most of my vacation trying to figure out why MySQL has gone nuts. It's part of a Movable Type install with tons of posts, comments, and log entries, and it's always run smoothly before. The problem is that it'll bomb on random queries, seemingly every minute or two, since status queries always show uptime in tens of seconds. Repairing the larger tables and restarting the server has done nothing, and no major changes have been made. What's wrong? Is this a *nix issue, a MySQL issue, or an MT issue? And how do I go about telling the difference, or fixing any of them? [more inside]
posted on Nov 28, 2005 - 32 answers
I need to get MySQL working with Visual Studio 2005. I come from the PHP world, and while I know C, C# is a new language to me. [more inside]
posted on Nov 25, 2005 - 14 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
Database Query [+]
posted on Jan 24, 2005 - 11 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 am a freelance journalist, and a document freak. But also I am very chaotic. I would like to use some sort of database to keep track of the articles, documents, web snippets, references, quotes, URLs, bibliography that I use in my work. But I have many questions and doubts [more].
Should I use a database that it is linked to the external documents (which I keep nonetheless), or should I go for a database that has all of these documents embedded? I work in a Windows / OSX environment (desktop PC and a G4 Powerbook), so this keeps me from going all the way to Access (which I hate) or Filemaker (which I don’t know very well). I’ve been thinking of keeping a MySQL database server, maybe powered with a modification of something like Everything, and accessing the data via web browser, but I fear that the thing wouldn’t escalate well. (Keep in mind that I am not a programmer, I can install Movable Type or GeekLog in my webserver, and tinker a little with php files changing little things here and there, although I have friends that can help me)
I don’t know if there are built-in solutions for what I need, or if you can point me to a database template (for Access or FileMaker) already built for journalist research. The fact is that I have tons of information and documents (some of them already stuffed in CD and DVD backups), but I have a hard time keeping track of everything, and very often it is very difficult for me to retrieve information that I know I have saved but I can’t tell where it is.
posted on May 11, 2004 - 9 answers
