DTP


 
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, 01:06 PM   #1
dthomsen8
Member
 
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 07:49 AM
ACDSee database john_b Software 11 09-24-2007 09:15 AM
Database publishing w/DTP tools? himalaya General Publishing Topics 14 08-25-2006 12:41 PM


All times are GMT -8. The time now is 09:34 PM.


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