Hello,
I have a question regarding creating more than 1 table, is it possible? (Iam newbie to mySQL thing) please help:
Right now I have, let say, 3 flat texts database that I use.
Code:
First flat text database contains 17 fields: 'ID'
'Date'
'HScode'
'Name'
'Email'
'Company'
'Address'
'City'
'State'
'Zip'
'Country'
'Phone'
'Fax'
'Homepage'
'Subject'
'Details'
'RemoveAd'
Second flat text database contains 20 fields:
'ID'
'Company'
'Category'
'Description'
'Group'
'Address'
'City'
'Zip'
'Country'
'Phone'
'Fax'
'Name'
'Email'
'Homepage'
'Product1'
'Product2'
'Product3'
'Product4'
'Continent'
'Turnover'
Third database contains 26 fields
'ID'
'Date'
'CategoryInq'
'ProductName'
'Quantity'
'Specs'
'DeadDay'
'DeadMonth'
'DeadYear'
'PaymentTerms'
'UsanceDay'
'SaleTerms'
'SalePort'
'Transferable'
'BuyersLocation'
'SeekProductFrom'
'BuyerIs'
'BuyingFrequency'
'Details'
'Name'
'Email'
'Company'
'City'
'Country'
'Phone'
'Fax'
I assume that when I do the setup for fields, I have to include all the name fields above on the cfg files, am I correct?
__________________________
SantanaBlank