What is the best strategy to limit using processing resources in doing a zip code radius query? (explained inside) [more inside]
How can I make backups of a MySQL database (via
mysqldump) and preserve Unicode characters (such as em dashes)? [more inside]
About to create a PHP/MySQL CMS and web site for a client entirely in Japanese, what do I need to know? [more inside]
Please help me create a MySQL database from a collection of images. There is of course [more inside]
I am getting spam to addresses picked up from a PHP mail script - can I stop this? [more inside]
MySQL refuses to index my table properly, because the data I'm looking for is only three letters long. [more inside]
I need some PHP/MySQL forum software with certain features. [more inside]
I work at a small non-profit book publisher, and I need to build a database for our website. [more inside]
Through a mutual friend, I've been approached to develop the back end of a website. My compensation for my work will be a percentage of the profits this website brings in. I have no idea what percentage to ask for, or what's fair. [more inside]
MySQLFilter: Help me with my 56 million record table! Lots of cumbersome background inside... [more inside]
Moving from Blogger to Wordpress: Can I pay someone to have it done? [more inside]
MySQL/PHPmyAdmin for a band: How do I easily create a repository of lyrics that can be brought in for multiple albums? [more inside]
I need help converting a Postgres-specific SQL query to MySQL [more inside]
Can you recommend a MySQL hosting provider? [more inside]
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]
How do I translate a MySQL date (like '1152215517') into standard dd/mm/yyyy (or any other human readable format)? [more inside]
Need a tinker-free Linux/MySql install for Ruby On Rails. Also, seeking advice for getting started in RoR. [more inside]
Are PHP/mySQL applications inherently insecure and unstable? [more inside]
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.
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]
I'm encountering what I imagine is an entirely rudimentary SQL error, but am baffled as to how to solve it. [more inside]
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]
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]
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]
How can I implement bi-directional synchronized table changes in a mySQL database and Microsoft Access? [more inside]
Stupid web development question about updating a database on a mouse click without re-loading the page (AJAX required?) [more inside]
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?
I use Textpattern to manage my Web site. I really want to use my text editor to edit my templates. [more inside]
Can anyone point me to a good documentation/samples for building an app using mod_python and cheetah? (and mySQL/DBUtils etc)? [more inside]
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]
What is the best alternative interface for an SQL server? [more inside]
I need to learn SQL, presumably mySQL. [more inside]
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]
I need help with what I hope is a fairly simple mySQL query question. [more inside]
WebDevFilter: ™, ', and ' walk into my database, but only ô, ë, and í come back out. [more inside]
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]
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]
I need help importing mySQL data from one server to another. [more inside]
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?
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]
Just getting started with php, web servers, html, mySQL, etc and have a question on phpMyadmin for those more experienced. [more inside]
WordPress, MySQL and OS X Server. Our tables keep getting corrupted. Help! [more inside]
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]
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]
SoftwareFilter: Need a portal / groupware or CMS solution with the following features: [more inside]
How can I preserve the unsubmitted contents of a web form whilst calling a refresh on its structure?
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]
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.
Does any one know how to find the most common result for a column returned from a mysql select request?
Can anybody recommend a good, free, preferably open source php-mysql contact management web application I can install on my own server?
This might be a little esoteric - but has anynone managed to get Perl's DBD::mysql module working on OSX Tiger? [more inside]