MysqlFilter: I need someone with mighty mysql-Fu to help me out here.
I have a list of items stored in my database (60 or so per user), they get sent to the flash application that I have, then once the user is done with everything, they press "save" (20 to 60 times a day), and it saves the list of items back to the database. I was doing an insert on duplicate update, but this doesnt get rid of the items that may have been deleted.
[more inside]
posted by hatsix
on Jul 7, 2006 -
10 answers
How do I translate a MySQL date (like '1152215517') into standard dd/mm/yyyy (or any other human readable format)?
[more inside]
posted by signal
on Jul 6, 2006 -
11 answers
Need a tinker-free Linux/MySql install for Ruby On Rails. Also, seeking advice for getting started in RoR.
[more inside]
posted by Afroblanco
on Jun 27, 2006 -
19 answers
I'm useless at self-directed book learning, and I'm desperate to add PHP/MySQL to my skillset. I've found
this class at PCC, but I'd like to hear if folks know about other classes in the Portland, Oregon area, especially if you know a good one.
posted by frykitty
on Jun 5, 2006 -
7 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 by bajema
on May 22, 2006 -
11 answers
I'm encountering what I imagine is an entirely rudimentary SQL error, but am baffled as to how to solve it.
[more inside]
posted by boombot
on May 16, 2006 -
80 answers
DBAs: Is this a case where I *should not* normalize my database? (PHP/MySQL 4.0.24 question). Long explanation of the situation inside.
[more inside]
posted by fishfucker
on Apr 27, 2006 -
25 answers
I'm looking for a something (php/mysql) that will help me build a simple database driven website. The CMS i've seen and used (such as drupal, post nuke) seem like overkill.
[more inside]
posted by quarsan
on Apr 25, 2006 -
11 answers
Database experts: I'm setting up a tagging system for a site I run. What's the most efficient way to go about it?
[more inside]
posted by Savvas
on Apr 24, 2006 -
11 answers
How can I implement bi-directional synchronized table changes in a mySQL database and Microsoft Access?
[more inside]
posted by mic stand
on Apr 19, 2006 -
6 answers
Stupid web development question about updating a database on a mouse click without re-loading the page (AJAX required?)
[more inside]
posted by TunnelArmr
on Apr 5, 2006 -
13 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
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 by karen
on Feb 14, 2006 -
2 answers
I'm looking for some sort of Web-Based-Mail system that I can install on my server that I would be able to interface through PHP or Ruby.
[more inside]
posted by hatsix
on Feb 7, 2006 -
7 answers
I run a fairly large Guild Wars fansite, using MediaWiki. Lately we've been having some database problems. Basically, mysql refuses to stay running for more than 10 seconds at a time, and occasionally complains of an InnoDB error, then exits with a signal 11. I've shut it down, run myisamchk, repaired, restarted, but it keeps coming back. Anyone care to lend a hand? After the repair, myisamchk doesn't show any errors on the table, or any others, but it always crops back up.
We've tried everything from replacing the RAM in the machine, to completely rebuilding mySQL. Help! (last lines of mysql error log inside)
[more inside]
posted by zerolives
on Dec 21, 2005 -
7 answers
WebDevFilter: ™, ', and ' walk into my database, but only ô, ë, and í come back out.
[more inside]
posted by Wild_Eep
on Nov 28, 2005 -
12 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 by paul_smatatoes
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 by SpecialK
on Nov 25, 2005 -
14 answers
I need help importing mySQL data from one server to another.
[more inside]
posted by o2b
on Oct 17, 2005 -
7 answers
I want to learn PHP and MySQL. I just installed both onto my Mac OS 10.4.2 machine to serve as a sort of testing ground. I also downloaded CocoaMySQL. It's asking for a host, user and password. I assume the host is localhost. However, I can't figure out how to create a user. Can anybody help with that? Also, what would you recommend as the best learning resources for somebody who can get around HTML and CSS, but has very little programming experience?
posted by willnot
on Sep 30, 2005 -
8 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
Just getting started with php, web servers, html, mySQL, etc and have a question on phpMyadmin for those more experienced.
[more inside]
posted by Cosine
on Sep 29, 2005 -
10 answers
I want to install phpBB on my website, but I have a basic question to which I haven't been able to find the answer yet. If I am using a MySQL database behind MT for my weblog, can I install phpBB on the same database and assume it will just build additional tables in MySQL? Or does it require a completely separate database that would be addressed differently?
[more inside]
posted by mikel
on Aug 27, 2005 -
5 answers
I am responsible for setting up and maintaining a mail server for small web-hosting type business. We currently host about 75 domains, around 100 mailboxes and due to the efforts of our sales team, we are wanting to get ready for some great increases in those numbers. I am worried about my current configuration and ease of administration. More importantly (well, at least to the customers) is email deliverability -- it seems that messages delivered to some big players are being marked as SPAM or disappearing altogether. I am asking for insight and advice on 1) if my current choice of software/configuration is a good match for this situation and 2) if there any additional measures I might take to ensure email deliverability?
[more inside]
posted by id
on Aug 26, 2005 -
1 answer
Half way through a form, a user decides that they'd like to add a category to a selection list. How can I facilitate this without also losing everything they've typed into the form so far?
[more inside]
posted by handee
on Aug 24, 2005 -
17 answers
I am tasked with writing a web-based accounting software in PHP-MySQL. My background in accounting is minimal. I understand enough of debits & credits & transactions and such, but I'd like to find some resources which could help me in working out the programming workflow, database relationships, etc, ie the technical parts of developing such a system.
posted by arrowhead
on Aug 6, 2005 -
14 answers
Does any one know how to find the most common result for a column returned from a mysql select request?
posted by outofpaper
on Jul 28, 2005 -
6 answers
Can anybody recommend a good, free, preferably open source php-mysql contact management web application I can install on my own server?
posted by monju_bosatsu
on Jul 25, 2005 -
14 answers
This might be a little esoteric - but has anynone managed to get Perl's DBD::mysql module working on OSX Tiger?
[more inside]
posted by Dag Maggot
on Jul 16, 2005 -
4 answers
Heh. I am in the strange position of being
far more capable of managing Unix/Linux/OS X than I am Windows XP, and, for development purposes, I'd like to install WordPress on my Windows box.
[more inside]
posted by xyzzy
on Jun 6, 2005 -
4 answers
Is there a way to automate the task of doing a daily mySQL dump? I'm looking for something (a program perhaps) that I could automate to dump mySQL into a file and save it to my PC.
[more inside]
posted by bjork24
on May 13, 2005 -
8 answers
I'm looking to upgrade to Mac OS X 10.4 (Tiger) when it's released next week, but have one fear that's holding me back from doing it as soon as my delivery arrives: does anyone know if Tiger and the current releases of MySQL 4.0 play well together?
[more inside]
posted by delfuego
on Apr 21, 2005 -
6 answers
Is it possible to implement full-text substring table searches in MySQL?
[more inside]
posted by esch
on Mar 25, 2005 -
10 answers
My fiancée and I are currently in the thick of planning our August wedding. Is there something like
Basecamp that I can install on my home server to help us keep track of the thousand-and-one-details?
[more inside]
posted by docgonzo
on Mar 13, 2005 -
8 answers
I need to convert several dynamic websites (database driven and templated) into static ones so that they can put on a CD.
[more inside]
posted by Hartster
on Feb 24, 2005 -
13 answers
What's the best way to ensure 99.999% service of a MySQL server? I'm looking for information on best practices for redundancy, and what the best way to acheive hot-failover would be ... or if it's better to use a cluster.
[more inside]
posted by SpecialK
on Feb 22, 2005 -
7 answers
Is there a script (perl or php, no MySQL because I don't understand it and don't want to learn it) that password-protects a webpage so that it can be viewed only by someone who logs in with a username and a password, and also logs that user, so that you can have a record (very important) of who's viewed the page? If so, where can I get me one?
posted by iconomy
on Jan 26, 2005 -
11 answers
