337 posts tagged with mysql.
Displaying 251 through 300 of 337. Subscribe:

Zip Code Radius Searches That Aren't Painful

What is the best strategy to limit using processing resources in doing a zip code radius query? (explained inside) [more inside]
posted by JakeWalker on Aug 28, 2006 - 12 answers

How can I preserve Unicode characters in `mysqdump`?

How can I make backups of a MySQL database (via mysqldump) and preserve Unicode characters (such as em dashes)? [more inside]
posted by cmyers on Aug 28, 2006 - 8 answers

Japanese PHP/Mysql development tips?

About to create a PHP/MySQL CMS and web site for a client entirely in Japanese, what do I need to know? [more inside]
posted by malphigian on Aug 28, 2006 - 7 answers

MySQL help!

Please help me create a MySQL database from a collection of images. There is of course [more inside]
posted by LoopyG on Aug 27, 2006 - 10 answers

Stop the Spam!

I am getting spam to addresses picked up from a PHP mail script - can I stop this? [more inside]
posted by jontyjago on Aug 20, 2006 - 13 answers

mysql hope

MySQL refuses to index my table properly, because the data I'm looking for is only three letters long. [more inside]
posted by reklaw on Aug 14, 2006 - 16 answers

Seeking PHP/MySQL forum software

I need some PHP/MySQL forum software with certain features. [more inside]
posted by disaster77 on Aug 13, 2006 - 5 answers

How can I build a database and interface for a book publisher's website?

I work at a small non-profit book publisher, and I need to build a database for our website. [more inside]
posted by mekanic on Aug 9, 2006 - 23 answers

What percentage of the profits should I be asking for?

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]
posted by cgg on Jul 22, 2006 - 15 answers

No, no—*million* with an M.

MySQLFilter: Help me with my 56 million record table! Lots of cumbersome background inside... [more inside]
posted by disillusioned on Jul 19, 2006 - 12 answers

Blogger to Wordpress for a Fee?

Moving from Blogger to Wordpress: Can I pay someone to have it done? [more inside]
posted by 0bvious on Jul 18, 2006 - 8 answers

The [Title] bone's connected to the [Lyrics] bone...

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 by Brainy on Jul 17, 2006 - 8 answers

Converting Postrges-specific query to Mysql

I need help converting a Postgres-specific SQL query to MySQL [more inside]
posted by mcstayinskool on Jul 14, 2006 - 14 answers

MySQL hosting provider?

Can you recommend a MySQL hosting provider? [more inside]
posted by Mo Nickels on Jul 10, 2006 - 14 answers

Mysql - Deleting items omitted from an insert|update

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

Translate MySQL dates

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

"There's no place like home...."

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

What's wrong with PHP?

Are PHP/mySQL applications inherently insecure and unstable? [more inside]
posted by aisforal on Jun 22, 2006 - 18 answers

PHP/MySQL class in Portland?

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

How can I integrate this simple database into my website?

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

Knocked Out Before The Bell Rang

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

MySQL Normalization Question

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

Need CMS for a simple database driven site

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

What's the best way to set up a tagging system?

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

Bi-Directional Synchronization of database changes in mySQL and Access

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

AJAX for idiots.

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

PHP/MySQL question on search / sort

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

Edit MySQL content directly from text editor?

I use Textpattern to manage my Web site. I really want to use my text editor to edit my templates. [more inside]
posted by rossmeissl on Mar 1, 2006 - 2 answers

got any mod_python and cheetah resources?

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

PHP:or:Ruby Webmail program I can hack?

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

Easy Interface for SQL

What is the best alternative interface for an SQL server? [more inside]
posted by benjh on Jan 12, 2006 - 6 answers

Need SQL lessons

I need to learn SQL, presumably mySQL. [more inside]
posted by captainscared on Jan 4, 2006 - 22 answers

Why is mysql constantly exiting with signal 11?

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

SELECT answer FROM askmefi

I need help with what I hope is a fairly simple mySQL query question. [more inside]
posted by Asparagirl on Nov 29, 2005 - 18 answers

How to get PHP to stop 'mis-rendering' some entities like ™ and single smart quotes.

WebDevFilter: ™, ', and ' walk into my database, but only ô, ë, and í come back out. [more inside]
posted by Wild_Eep on Nov 28, 2005 - 12 answers

Why does MySQL keep restarting?

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

M$ no like MySQL

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

Import data into mySQL?

I need help importing mySQL data from one server to another. [more inside]
posted by o2b on Oct 17, 2005 - 7 answers

How do I create users in MySQL, and how do I learn to use MySQL

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

Can FileMaker have hooks into MySQL?

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

Help with phpMyadmin?

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

MySQL, OS X, and a corrupted table.

WordPress, MySQL and OS X Server. Our tables keep getting corrupted. Help! [more inside]
posted by katieinshoes on Sep 10, 2005 - 5 answers

phpBB and MT using the same DB?

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

Open source e-mail scalability

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

I need a portal / groupware or CMS solution

SoftwareFilter: Need a portal / groupware or CMS solution with the following features: [more inside]
posted by letterneversent on Aug 25, 2005 - 14 answers

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]
posted by handee on Aug 24, 2005 - 17 answers

Building a web-based accounting software

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

select "order by occurrence" mysql

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

Contact management web application?

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

YourSQL, definitely not mine.

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

Page: 1 2 3 4 5 6 7