Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

PHP Forum


You are currently viewing our PHP Forum as a guest. Please register to participate.
Login



Freelance Jobs

Reply
model agency merging databases
Old 07-21-2012, 12:56 PM model agency merging databases
goheadtry's Avatar
Super Spam Talker

Posts: 767
Name: John
Location: United States of America, California
Trades: 0
I have an old site and a new one
Ok here's where it gets tricky
There a database with a table for models in both but the column structure is different in both so is the database name and the table names and the field names
But both have a few fields in common one is the models name the other is the facebook the Twitter and the aliases the alias field is all the aliases seperated by commas nothing else matches ok both tables have some models that exist in the other but its impossible for two girls to have the same name so if the names the same its that girl I want a PHP script that checks the first database for a me in that tables field for the models name if the models in the other database grab the facebook url aliases etc but one item at a time so it doesn't overwrite something there then if the girl from the first one doesnt exist grab it make a new row and plug in only the fields that I need name facebook Twitter etc can someone please write a script payment is possible also if nobody can help me free its my SQL I wanted a PHP script where I just ty
Pe in one text box field from the first then field from second push go and its based on model name please help also my phone number is 8186697573 text me what is charge if help free that's cool too I'm running out of options and I've never done something like this one database has 18000 results the other has about 30000

Last edited by goheadtry; 07-21-2012 at 01:01 PM..
goheadtry is offline
Reply With Quote
View Public Profile Visit goheadtry's homepage!
 
 
Register now for full access!
Old 07-21-2012, 02:33 PM Re: model agency merging databases
chrishirst's Avatar
Defies a Status

Posts: 43,949
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Quote:
this one database has 18000 results the other has about 30000
So they are only tiny by SQL standards.

Would you please retype the requirements with some punctuation and spacing so it is easier to read and figure out what you actually need?
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 07-21-2012, 07:19 PM Re: model agency merging databases
King Spam Talker

Posts: 1,090
Name: Paul W
Trades: 0
Your stated requirement aren't precise enough or detailed enough but, filling in the blanks, I'd have charged half a day's contract rate to do this. You'll probably find a cheaper rate on freelancer.com
__________________
Great music:
Please login or register to view this content. Registration is FREE



Please login or register to view this content. Registration is FREE
PaulW is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to model agency merging databases
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.15663 seconds with 11 queries