Lively discussions on the graphic arts and publishing — in print or on the web

Go Back   Desktop Publishing Forum > General Discussions > Web Site Building & Maintenance

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 01-07-2010, 12:06 PM   #1
dthomsen8's Avatar
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default MySQL database capabilities

I am helping someone else learn PHP and MySQL. I have forgotten much of what I know about those packages, but I know that MySQL is not difficult.

What I want is to compare two MySQL files, looking for matches in a certain key field, and then updating one of them with information from a matching record on the second file. For example, street addresses might be the key, no need for city or state because all are in the same city. After getting the street address matches (maybe with manipulation of the addresses to line up apartment numbers or the like), then to compare names in the files, too. This can be done by putting the names from the second file into the first file, and then making a run on the first file to compare and mark the matches.

The difficulty is that MySQL is designed to respond to a web page, not to run the procedural compares I am seeing to do. Any advice?
dthomsen8 is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP connection to MySQL database john_b Web Site Building & Maintenance 11 01-08-2010 06:49 AM
ACDSee database john_b Software 11 09-24-2007 08:15 AM
Database publishing w/DTP tools? himalaya General Publishing Topics 14 08-25-2006 11:41 AM

All times are GMT -8. The time now is 05:56 PM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Contents copyright 2004–2018 Desktop Publishing Forum and its members.