zapis URL do databazy

<?php
if ($_POST['nick'] =="") {
   echo "Musite zadat vas nick." ;
exit;
} elseif ($_POST['mesto'] =="") {
   echo "Musite zadat nazov mesta." ;
exit;
} elseif ($_POST['krajina'] =="") {
   echo "Musite zadat nazov krajiny." ;
exit;
}

if ($ok) {
[color=indigo]$subor = "$nick" . "_o_" . date("Ymd_Gis") . ".html";[/color]$fp = fopen($subor, "w")
     or die("Nie je mozne vytvorit subor!");


fwrite($fp, "<style>body {background-color: #333333; color: #CCCCCC; font-family: Times New Roman, Verdana; align: center; text-align: center; valign: middle}</style>") ;



for ($i = 1; $i <= 12; $i++) {
  $fotka = "fotka" . $i;
  $fotka_name = $fotka . "_name";
  $fotka_type = $fotka . "_type";
  $fotka_size = $fotka . "_size";
  $popis = "popis" . $i;
  if ($$fotka_type=="image/jpeg" ||
      $$fotka_type=="image/pjpeg" ||
      $$fotka_type=="image/gif" ||
      $$fotka_type=="image/x-png")  {
  copy($$fotka, "./fotky/{$$fotka_name}") ;

fwrite($fp, "<tr><td width=\"100%\">") ;
fwrite($fp, "<TABLE width=\"90%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" rules=\"none\" align=\"center\">") ;
fwrite($fp, "<tr><td height=\"30px\"></td></tr>\n") ;
fwrite($fp, "<tr><td align=\"center\" valign=\"middle\">") ;
fwrite($fp, "<p><p align=center>\n");

fwrite($fp, "<table border=2 bordercolor=\"#990000\" bgcolor=\"#990000\" align=\"center\" valign=\"middle\"><tr><td>") ;
  fwrite($fp, "<a href=\"./fotky/{$$fotka_name}\"
                  target=\"fotky\">") ;
  fwrite($fp, "<img src=\"./fotky/{$$fotka_name}\"
              alt=\"Photo\" border=0 height=500></a>") ;
fwrite($fp, "</td></tr>\n") ;
fwrite($fp, "</table>\n") ;
fwrite($fp, "<tr><td height=\"15px\"></td></tr>\n") ;
fwrite($fp, "<tr><td align=\"center\" height=\"30px\" bgcolor=\"#222222\"><span style=\"font-size: 17px; font-family: Time News Roman, Arial; color: #AAAAAA\">{$$popis}</span></td></tr>\n") ;
}
if ($i==1) fwrite($fp, "<br clear=center>\n") ;
}
fwrite($fp, "</p>\n") ;
fwrite($fp, "</td></tr>\n") ;
fwrite($fp, "<tr><td height=\"70px\"></td></tr>\n") ;
fwrite($fp, "</table>\n") ;
fwrite($fp, "</body>") ;
fclose($fp) ;
}

$server="localhost";
$meno="uzivatel";
$heslo="heslo";
$DB="databaza";
@$spojenie=mysql_connect($server, $meno, $heslo);
if(!$spojenie)
  echo "Nepodarilo sa vytvorit spojenie s hostitelom $hostitel!";
else {
  @$navratova_hodnota=mysql_select_db($DB);
  if (!$navratova_hodnota){
    echo "Nepodarilo sa nastavit databazu $DB!";
  }
}
$query = "
  INSERT INTO fotky (id, nick, mesto, krajina) VALUES ('', '{$_POST['nick']}', '{$_POST['mesto']}', '{$_POST['krajina']}')
";

$result = mysql_query($query);
if ($result) {
   echo "
  SQL query: $query
  <hr>Status: Údaje úspešne odoslané. <a href='vysledok.php'>Zobrazenie vašich vložených údajov.</a>
  <hr>
  ";
} else {
  echo "
  SQL query: $query
  <hr>Status: Chyba. Údaje sa nepodarilo zapísať.
  <hr>".mysql_error()."
  <hr>
  ";
}

?>

$query = "INSERT INTO fotky (id, nick, mesto, krajina, url) VALUES ('', '{$_POST['nick']}', '{$_POST['mesto']}', '{$_POST['krajina']}', '$subor')"