Copy table entries

[bengt]

I have two tables in a database where the SKIFT table is linked with the VAKTER table with vakter.id and skift.vaktid.
The two tables can you see here:

CREATE TABLE `vakter` (
  `id` varchar(20) NOT NULL default '0',
  `lagid` int(4) NOT NULL default '0',
  `region` int(2) NOT NULL default '0',
  `typeid` int(4) NOT NULL default '0',
  `stedid` int(4) NOT NULL default '0',
  `arrangement` varchar(255) NOT NULL default '',
  `info` text NOT NULL,
  `ansvkunde` varchar(255) NOT NULL default '',
  `rapport` tinyint(1) NOT NULL default '0',
  `userid` int(4) NOT NULL default '0',
  `dato` timestamp(14) NOT NULL,
  `ressurs` int(3) NOT NULL default '0',
  `authorid` int(5) NOT NULL default '0',
  `fra` datetime NOT NULL default '0000-00-00 00:00:00',
  `til` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `skift` (
  `id` int(5) NOT NULL auto_increment,
  `vaktid` int(4) NOT NULL default '0',
  `fra` datetime NOT NULL default '0000-00-00 00:00:00',
  `til` datetime NOT NULL default '0000-00-00 00:00:00',
  `antmannsk` int(3) NOT NULL default '0',
  `antbiler` int(3) NOT NULL default '0',
  `hospitanter` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=77 ;

the VAKTER table is the main table, and SKIFT table can contain several entries where SKIFT.VAKTID equals VAKT.ID.

I want to be able to duplicate a entry in VAKTER, and the same time copy the entries in SKIFT where SKIFT.VAKTID equals VAKTER.ID.

When copying, I have to options. How many copies, and how many days between the copies.

VAKTER.FRA, VAKTER.TIL, SKIFT.FRA, SKIFT.TIL needs to be increased with x number of days for each copy.

Is there a simple script, or a short "how-to" to do this?

[bengt]

This is the script i tried with:

if ($trac) {
	$origid = $_POST[id];
	$i = 0;
	while ($i < $antganger) {
		global $vid,$sid;
		$i++;
		if ($i == 1) { 
			//henter forrige vakt
			$sql = "SELECT *,DATE_FORMAT(fra, '%Y%m%d%H%i%s')as ffra FROM vakter WHERE id ='{$_POST[id]}' LIMIT 1";
			$result = mysql_query($sql) or die(mysql_error());
			$vakt = mysql_fetch_array($result);
		}
		if ($i == 1) {
			$nyfra = date('Y-m-d H:i:s',strtotime($vakt[fra]."+".$days." days"));
			$nytil = date('Y-m-d H:i:s',strtotime($vakt[til]."+".$days." days"));
			$sid = $_POST[id];
		} else {
			$nyfra = date('Y-m-d H:i:s' ,strtotime($nyfra."+".$days." days"));
			$nytil = date('Y-m-d H:i:s',strtotime($nytil."+".$days." days"));
		}



	$timex = getdate();
	$vid = $timex[0].$i;

	$sql = "INSERT INTO vakter "
			."(id, lagid, region, typeid, stedid, arrangement, info, ansvkunde, rapport, userid, ressurs, authorid, fra, til) "
			."VALUES('$vid','$vakt[lagid]', '$vakt[region]', '$vakt[typeid]', '$vakt[stedid]', '$vakt[arrangement]', '$vakt[info]', '$vakt[ansvkunde]', '$vakt[rapport]', '$vakt[userid]', '$vakt[ressurs]', '$vakt[authorid]', '$nyfra', '$nytil')";

	$result = mysql_query($sql) or die(mysql_error());

	//Finner skift, og kopierer hvert skift
	$sql = "SELECT * FROM skift WHERE vaktid = '{$sid}'";
	echo "<p class=>".$sql."</p>";

	$result = mysql_query($sql) or die(mysql_error());
	$x = 0;
	while ($row = mysql_fetch_array($result)) {
		$x++;
		$nysfra = date('Y-m-d H:i:s',strtotime($row[fra]."+".$days." days"));
		$nystil = date('Y-m-d H:i:s',strtotime($row[til]."+".$days." days"));

		$sql = "INSERT INTO skift (vaktid, fra, til, antmannsk, antbiler, hospitanter) VALUES('$vid', '$nysfra', '$nystil', '$row[antmannsk]', '$row[antbiler]', '$row[hospitanter]')";
		echo "<p class=red>".$sql."</p>";
		$res = mysql_query($sql) or die(mysql_error());
	}
	$sid = $vid;

	echo "Vakt med $origid, har blitt kopiert til $vid med $x skift,skift heter $vid<br>";
}


}

And this is the form

if (!$trac or $error) {
	//henter vakt info
	$sql = "SELECT * FROM vakter WHERE id = '{$id}' LIMIT 1";
	$result = mysql_query($sql) or die(mysql_Error());
	$vakt = mysql_fetch_array($result);

echo "<form method=post>";
echo "<table width=300 align=center>";
echo "<tr class=formhead>";
echo "<td colspan=2>Fyll inn informasjone</td></Tr>";
echo "<tr class=form>";
echo "<td>Arrangement: </td><td>$vakt[arrangement]</td></tr>";
echo "<tr class=form2>";
echo "<td>Ant ganger: <span class=red>*</span> </td><td><input type=text name=antganger value=\"{$antganger}\" size=3 maxlength=2></td></tr>";
echo "<tr class=form><td>Dager mellom rep: <span class=red>*</span></td><td><input type=text name=days value=\"{$days}\" size=3 maxlength=2></td>";
echo "</table>";
echo "<p align=center><input type=submit name=trac value=\"Kopier oppdrag\"></p>";
echo "<input type=hidden name=id value=\"{$id}\">";
echo "</form>";


}

It copies the entries from VAKTER ok, but the entries from SKIFT is not copied.

[bengt]

Is this to complicated, or am i not making my self understandable?