Home : Products : DBMan SQL : Discussion :

Products: DBMan SQL: Discussion: Re: [jai] Database Field Advice: Edit Log

Here is the list of edits for this post
Re: [jai] Database Field Advice
You want a table structure perhaps like a country column and a date column and then the same country can have multiple dates, eg....

England 01/15
England 01/25
England 03/04

I think thats how best to do it. As you say multiple dates in one column is not what you want to be doing.

Depending how the dates are entered, as Jaspercram said, you can just split and insert...eg if commas:

my @dates = split ',', $IN->param('date_field');
for (@dates) {
$DB->table('Table_Name')->insert({ country_col => $country_name, date => $_ })'

Last edited by:

Paul: Jan 21, 2003, 8:45 AM

Edit Log: