Avatar billede lisa99 Nybegynder
06. maj 2003 - 14:41 Der er 16 kommentarer og
1 løsning

hvad har jeg gjort forkert?

jeg har en gæstebog som jeg ville rette lidt i.
så man kan skrive sin hjemmeside addresse:
men jeg kan ikke få den til at skrive.
filerne ser sådan ud:
gem.php
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
<?php
ob_start();
?><title>gem</title><BODY BGCOLOR=000000 TEXT=fff000 LINK=fff000 VLINK=800080 background=>
<center><?php

require("./gbog-ting/mysql-funktioner.php");
require("./gbog-ting/design-funktioner.php");
require("./gbog-ting/indstillinger.php");



if(is_array($HTTP_POST_VARS)) {
  $navn = $HTTP_POST_VARS['navn'];
  $epost = $HTTP_POST_VARS['epost'];
  $url = $HTTP_POST_VARS['url'];
  $besked = $HTTP_POST_VARS['besked'];
} elseif (is_array($_POST)) {
  $navn = $_POST['navn'];
  $epost = $_POST['epost'];
  $url = $_POST['url']; 
  $besked = $_POST['epost'];
}




function gbog_fejl($fejl) {

    $generel_tekst = "<p>V&aelig;r venlig at g&aring; tilbage og ret til.</p>";

    $fejlmelding = "<ul>";

    for($i=0;$i<count($fejl);$i++) {
        $fejlmelding .= "<li>". $fejl[$i];
    }

    $fejlmelding .= "</ul>";

    echo top("Fejl") . "G&aelig;stebogen brokkede sig lidt over dit input:" . $fejlmelding . $generel_tekst . bund();
    exit;

}

/*
* Denne funktion skriver i gæstebogen - altså i databasen.
* Bemærk, at vi ikke bruger PHP til at indsætte tiden, men
* bruger MySQLs indbyggede funktion now().
*/

function skriv_i_gbog($navn, $epost,$url,$besked) {
   
    $ip = getenv('REMOTE_ADDR');

    $sql = "insert into gaestebog(navn,epost,url,besked,ip,tid)
        values('$navn','$epost','url','$besked','$ip',now())";

    aabn_forbindelse_og_vaelgdb();
    sql_spoerg($sql);
    luk_forbindelse();

}

/*
* Vi laver lidt simpelt fejlcheckeri og ser, om der overhovedet
* er skrevet noget. Hvis ikke, bruger vi fejlfunktionen til at brokke os.
* Fejlfunktionen slutter med "exit", der sørger for, at PHP stopper.
*/

if(!ereg("[A-z0-9]+", $navn)) {

    $fejl[] = "Du har ikke skrevet dit navn";

}

if(!ereg("[A-z0-9]+", $besked)) {

    $fejl[] = "Du har ikke skrevet nogen besked";

}

if(count($fejl) > 0) {
    gbog_fejl($fejl);
}



skriv_i_gbog(addslashes($navn),addslashes($epost),addslashes($url),addslashes($besked));





header("Location: http://monstar99.users.whitehat.dk/bibliotek_med_gaestebogen_i/gbog.php");
exit;                ?>



if($epost_p == "t") {

  $ip = getenv('REMOTE_ADDR');
  $epostens_indhold = "$navn har skrevet denne besked fra IP-adressen $REMOTE_ADDR:\n-----------------------------------------------------\n\n$besked";

  mail($admin_epost, "Der er skrevet i din gæstebog!", $epostens_indhold);

}

?>



</center><?php
ob_end_flush();
?>

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
gBog.php
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><html><?php
ob_start();
?>

<head><script language="JavaScript"><!--


var message=" Copyright © www.AmstaffPalads.dk.\n\n Kopiering uden tilladelse ikke tilladt \n\n E-mail: admin@Amstaffpalads.dk.";



function click(e) {

if (document.all) {

if (event.button == 2) {

alert(message);

return false;

}

}

if (document.layers) {

if (e.which == 3) {

alert(message);

return false;

}

}

}

if (document.layers) {

document.captureEvents(Event.MOUSEDOWN);

}

document.onmousedown=click;

// -->
</script>

<STYLE TYPE="text/css">
<!--
body {font-family: Tahoma; color: #000000; font-size: 10px; }
a:link {text-decoration:none; font-weight: bold; color:  #666666; cursor:default; }
a:visited {text-decoration:none; font-weight: bold; color: #666666; cursor:default;}
a:active {text-decoration:none;  font-weight: bold; color: #666666; cursor:default;}
a:hover {text-decoration: none; font-weight: bold; color: #303840; cursor:default;}
input, textarea, option, select{background-color:#e9e9e9;
border:solid 1px black;color:#black;font-family:tahoma;font-size: 10px;}

BODY {
scrollbar-face-color: #F5F5EC;
scrollbar-shadow-color: #505868;
scrollbar-highlight-color: #505868;
scrollbar-3dlight-color: #505868;
scrollbar-darkshadow-color: #505868;
scrollbar-track-color: #F5F5EC;
scrollbar-arrow-color: #F5F5EC;
}
-->
</STYLE>
<title>gBog</title>
</head>

<body bgcolor="#000000">
<div align="center">
  <table border="0" width="760" bgcolor="#000000" cellspacing="1" cellpadding="0">
  <center>
    <tr>
        <td bgcolor="#FFFFFF" colspan="2"><img border="0" src="http://www.amstaffpalads.dk/Billder/toppen%20copy.jpg" width="760" height="30"></td>
    </tr>
    <tr>
        <td bgcolor="#cccccc" colspan="2" height="15"> <font size="1" face="Tahoma">&nbsp;&nbsp;
          </font> </td>
    </tr>
    <tr>
        <td bgcolor="#FFFFFF" colspan="2"><img border="0" src="http://www.amstaffpalads.dk/Billder/toppet%20copy.jpg" width="760" height="55"></td>
    </tr>
    <tr>
          <td bgcolor="#cccccc" colspan="2" height="15"> <font size="1" face="Tahoma">
          </font><center>
            <a href="http://www.amstaffpalads.dk/galleri.htm"> <font face="Tahoma" size="1">Galleri</font></a><font face="Tahoma" size="1">&nbsp;&nbsp;
            <a href="http://www.amstaffpalads.dk/om.htm">Om Amstaff&nbsp;</a> &nbsp; <a href="http://www.amstaffpalads.dk/kontakt.htm">Kontakt
            os</a>&nbsp; &nbsp; <a href="http://www.amstaffpalads.dk/game%20starter.htm">Spil</a>&nbsp; &nbsp;
            <a href="http://www.amstaffpalads.dk/index.php">Forside</a>&nbsp; &nbsp; <a href="http://www.amstaffpalads.dk/Nyheder.htm">Nyheder</a>&nbsp;&nbsp; <a href="http://www.amstaffpalads.dk/links.htm">Links
        </a></font>
</center>  </td>
    </tr>
    </center>
   
 
        <table border="0" width="120%" height="165">
          <tr>
       
         
              <table border="0" width="88%" height="122" cellspacing="0" cellpadding="0">
           
              </table>
         
          </tr>

        </table>

      &nbsp;
        <p>&nbsp;
   
    <tr>
      <td bgcolor="#cccccc" colspan="2" height="15">
        <p align="center">  <?php




require("./gbog-ting/mysql-funktioner.php");
require("./gbog-ting/design-funktioner.php");
require("./gbog-ting/indstillinger.php");



if(is_array($HTTP_GET_VARS)) {
  $start_nr = $HTTP_GET_VARS['start_nr'];
} elseif (is_array($_GET)) {
  $start_nr = $_GET['start_nr'];
}



if(!$start_nr || $start_nr < 0) {
  $start_nr = 0;
}



echo top("");
echo "<p><a href=\"./\"></a></p>";



$sql = "select id, navn, epost, date_format(tid, '%e/%c %Y, %H:%i') as tiden, besked from gaestebog order by tid desc limit $start_nr, $antal_ad_gangen";
$taeller_sql = "select count(*) as antal from gaestebog";



aabn_forbindelse_og_vaelgdb();
$resultat = sql_spoerg_og_faa_svar($sql);
$optaelling = sql_spoerg_og_faa_svar($taeller_sql);
luk_forbindelse();



extract($optaelling[0]);


if($antal > ($start_nr + $antal_ad_gangen)) {
   
    $naeste_start_nr = $start_nr + $antal_ad_gangen;
    $naeste_nav = "<a href=\"$PHP_SELF?start_nr=$naeste_start_nr\">N&aelig;ste</a>";

} else {

    $naeste_nav = "<span class=\"doedt-link\">N&aelig;ste</span>";

}



if($start_nr > 0 && ($start_nr - $antal_ad_gangen) < $antal) {

    $forrige_start_nr = $start_nr - $antal_ad_gangen;
    $forrige_nav = "<a href=\"$PHP_SELF?start_nr=$forrige_start_nr\">Forrige</a>";

} else {

    $forrige_nav = "<span class=\"doedt-link\">Forrige</span>";

}



$nav = "<table width=\"$tabel_bredde\" border=\"0\" cellpadding=\"5\" cellspacing=\"0\">
    <tr><td align=\"left\" width=\"33%\">$forrige_nav</td>
    <td align=\"center\" width=\"34%\"><a href=\"skriv.php\">Skriv</a></td>
    <td align=\"right\" align=\"33%\">$naeste_nav</td></tr>
    </table>";



echo "$nav <p />";


if(count($resultat) < 1) {

  echo "Der er ingen indl&aelig;g i gBogen";

} else {

  for($i=0;$i<count($resultat);$i++) {


   
    extract($resultat[$i]);



    $besked = stripslashes($besked);
    $navn = stripslashes($navn);
    $epost = stripslashes($epost);

 

    if($html_p != "t") {
        $navn = htmlentities($navn);
        $epost = htmlentities($epost);
        $besked = htmlentities($besked);
    }

 

    $besked = nl2br($besked);



    if(ereg("@", $epost)) {
        $navn = "<a href=\"mailto:$epost\">$navn</a>";
    }

 

?>

        <table width="<?php echo $tabel_bredde; ?>" cellpadding="1" cellspacing="0" border="0" align="center">
          <tr><td class="gbog-baggrund" width="100%" align="center">

            <table border="0" cellpadding="8" cellspacing="0" width="100%">
                <tr><td class="gbog-top" width="100%">Skrevet af: <strong><?php echo $navn; ?></strong>, <?php echo $tiden; ?></td></tr>
            </table>
<table border="0" cellpadding="8" cellspacing="0" width="100%">
                <tr><td class="gbog-top" width="100%">Hjemmeside: <strong><?php echo $Url; ?></strong></td></tr>
            </table>
        </td></tr><tr><td class="gbog-baggrund" align="center" width="100%">

            <table border="0" cellpadding="8" cellspacing="0" width="100%">
                <tr>
                  <td class="gbog-bund" width="100%">
                    <?php echo $besked; ?>
                  </td>
                </tr>
            </table>

        </td></tr>
    </table><p />

<center><?php



  }



  echo $nav;



}



echo bund();

?></center> </p>
      </td>
    </tr>
  </table>
  &nbsp;


</div>

<?php
ob_end_flush();
?>
**********************************************************************************************************************skriv.php************************************************************************************************************************************************************************
<?php

ob_start();

?>

<HTML>

<HEAD><script language="JavaScript"><!--





var message=" Copyright © www.AmstaffPalads.dk.\n\n Kopiering uden tilladelse ikke tilladt \n\n E-mail: admin@Amstaffpalads.dk.";







function click(e) {



if (document.all) {



if (event.button == 2) {



alert(message);



return false;



}



}



if (document.layers) {



if (e.which == 3) {



alert(message);



return false;



}



}



}



if (document.layers) {



document.captureEvents(Event.MOUSEDOWN);



}



document.onmousedown=click;



// -->

</script>

<?php

require_once("gbog-ting/design-funktioner.php");

?>

</head>

<STYLE TYPE="text/css">

<!--

body {font-family: Tahoma; color: #0000CC; font-size: 10px; }

a:link {text-decoration:none; font-weight: bold; color:  #0000cc; cursor:default; }

a:visited {text-decoration:none; font-weight: bold; color: #0000cc; cursor:default;}

a:active {text-decoration:none;  font-weight: bold; color: #0000cc; cursor:default;}

a:hover {text-decoration: none; font-weight: bold; color: #303840; cursor:default;}

input, textarea, option, select{background-color:#e9e9e9;

border:solid 1px black;color:#black;font-family:tahoma;font-size: 10px;}



BODY {

scrollbar-face-color: #F5F5EC;

scrollbar-shadow-color: #505868;

scrollbar-highlight-color: #505868;

scrollbar-3dlight-color: #505868;

scrollbar-darkshadow-color: #505868;

scrollbar-track-color: #F5F5EC;

scrollbar-arrow-color: #F5F5EC;

}

-->

</STYLE>

<title>skriv</title>

</head>



<body bgcolor="#000000" text="#0000CC" link="#0033FF" vlink="#000066" alink="#0000CC">

<table align="center" border="0" width="760" bgcolor="#000000" cellspacing="1" cellpadding="0">



    <tr>

        <center><td bgcolor="#FFFFFF" colspan="2"><img border="0" src="ftp://web2142:1959n7z723@amstaffpalads.dk/bibliotek_med_gaestebogen_i/toppen%20copy.jpg" width="760" height="30"></td> </center>

    </tr>

    <tr>

       

    <td bgcolor="#cccccc" colspan="2" height="15"> <font size="1" face="Tahoma">&nbsp;&nbsp;

      </font> </td>

   

    </tr>

    <tr>

       

    <td bgcolor="#FFFFFF" colspan="2"><img border="0" src="ftp://web2142:1959n7z723@amstaffpalads.dk/bibliotek_med_gaestebogen_i/toppet%20copy.jpg" width="760" height="55"></td>

   

    </tr>

    <tr>

        <td bgcolor="#cccccc" colspan="2" height="15"> <font size="1" face="Tahoma">

          </font><center>

            <a href="ftp://web2142:1959n7z723@amstaffpalads.dk/bibliotek_med_gaestebogen_i/information"> <font face="Tahoma" size="1">Galleri</font></a><font face="Tahoma" size="1">&nbsp;&nbsp;

            <a href="ftp://web2142:1959n7z723@amstaffpalads.dk/bibliotek_med_gaestebogen_i/Amstaff">Om Amstaff&nbsp;</a> &nbsp; <a href="2/?side=referencer">Kontakt

            os</a>&nbsp; &nbsp; <a href="ftp://web2142:1959n7z723@amstaffpalads.dk/bibliotek_med_gaestebogen_i/bibliotek_med_gaestebogen_i/sms.php">Send sms</a>&nbsp; &nbsp;

            <a href="http://monstar99.users.whitehat.dk/bibliotek_med_gaestebogen_i/gbog.php">Gæstebog</a>&nbsp; &nbsp; <a href="2/?side=News">Nyheder</a>&nbsp;</font>

</center>  </td></table>

  <tr>

     

 

   

<tr> <center>

<?php

echo top("Skriv i g&aelig;stebogen");

?>

  <form action="gem.php" method="post">

    <table border="0" cellpadding="5" cellspacing="0">

      <tr>

        <td align="right"><b>Navn:</b></td>

        <td>

          <input type="text" name="navn" size="30" maxlength="100">

        </td>

      </tr>

      <tr>

          <td align="right"><b>E - Mail:</b></td>

        <td>

          <input type="text" name="epost" size="30" maxlength="100">

        </td>

      </tr>
<tr>

        <td align="right" valign="top"><b>Din hjemmeside:</b></td>

        <td>

        <input type="text" name="url" size="40" VALUE="http://" maxlength="255">

        </td>

      </tr>
      <tr>

        <td align="right" valign="top"><b>Din kommentar:</b></td>

        <td>

          <textarea cols="50" rows="10" name="besked"></textarea>

        </td>

      </tr>

      <tr>

        <td></td>

        <td>

          <input type="submit" value="Indryk!">

        </td>

      </tr>

    </table>

  </form>

  <?php

echo bund();

?>

</center>

<tr>

<?php

ob_end_flush();

?>
Avatar billede fri-hash Nybegynder
06. maj 2003 - 14:46 #1
måske det er det manglende $-tegn i din query

* Denne funktion skriver i gæstebogen - altså i databasen.
* Bemærk, at vi ikke bruger PHP til at indsætte tiden, men
* bruger MySQLs indbyggede funktion now().
*/

function skriv_i_gbog($navn, $epost,$url,$besked) {
   
    $ip = getenv('REMOTE_ADDR');

    $sql = "insert into gaestebog(navn,epost,url,besked,ip,tid)
        values('$navn','$epost','url','$besked','$ip',now())";

    aabn_forbindelse_og_vaelgdb();
    sql_spoerg($sql);
    luk_forbindelse();

}

rettes til

* Denne funktion skriver i gæstebogen - altså i databasen.
* Bemærk, at vi ikke bruger PHP til at indsætte tiden, men
* bruger MySQLs indbyggede funktion now().
*/

function skriv_i_gbog($navn, $epost,$url,$besked) {
   
    $ip = getenv('REMOTE_ADDR');

    $sql = "insert into gaestebog(navn,epost,url,besked,ip,tid)
        values('$navn','$epost','$url','$besked','$ip',now())";

    aabn_forbindelse_og_vaelgdb();
    sql_spoerg($sql);
    luk_forbindelse();

}
Avatar billede fri-hash Nybegynder
06. maj 2003 - 14:49 #2
desuden i gbog.php henter du slet ikke url

$sql = "select id, navn, epost, date_format(tid, '%e/%c %Y, %H:%i') as tiden, besked from gaestebog order by tid desc limit $start_nr, $antal_ad_gangen";
$taeller_sql = "select count(*) as antal from gaestebog";

rettes til

$sql = "select id, navn, url, epost, date_format(tid, '%e/%c %Y, %H:%i') as tiden, besked from gaestebog order by tid desc limit $start_nr, $antal_ad_gangen";
$taeller_sql = "select count(*) as antal from gaestebog";
Avatar billede lisa99 Nybegynder
06. maj 2003 - 14:58 #3
jeg har i databasen tilføjet dette:
alter table gaestebog add (Url varchar(255));
Avatar billede lisa99 Nybegynder
06. maj 2003 - 15:03 #4
de 2 rettelser har jeg lavet men det virker ikke helt endnu. Den gør den samme "fejl" som den hele tiden har gjort ikke at skrive hjemmeside adressen ind i gæstebogen.
Avatar billede lisa99 Nybegynder
06. maj 2003 - 15:07 #5
<?php
ob_start();
?><html>

<head><script language="JavaScript"><!--


var message=" Copyright © www.AmstaffPalads.dk.\n\n Kopiering uden tilladelse ikke tilladt \n\n E-mail: admin@Amstaffpalads.dk.";



function click(e) {

if (document.all) {

if (event.button == 2) {

alert(message);

return false;

}

}

if (document.layers) {

if (e.which == 3) {

alert(message);

return false;

}

}

}

if (document.layers) {

document.captureEvents(Event.MOUSEDOWN);

}

document.onmousedown=click;

// -->
</script>

<STYLE TYPE="text/css">
<!--
body {font-family: Tahoma; color: #000000; font-size: 10px; }
a:link {text-decoration:none; font-weight: bold; color:  #666666; cursor:default; }
a:visited {text-decoration:none; font-weight: bold; color: #666666; cursor:default;}
a:active {text-decoration:none;  font-weight: bold; color: #666666; cursor:default;}
a:hover {text-decoration: none; font-weight: bold; color: #303840; cursor:default;}
input, textarea, option, select{background-color:#e9e9e9;
border:solid 1px black;color:#black;font-family:tahoma;font-size: 10px;}

BODY {
scrollbar-face-color: #F5F5EC;
scrollbar-shadow-color: #505868;
scrollbar-highlight-color: #505868;
scrollbar-3dlight-color: #505868;
scrollbar-darkshadow-color: #505868;
scrollbar-track-color: #F5F5EC;
scrollbar-arrow-color: #F5F5EC;
}
-->
</STYLE>
<title>gBog</title>
</head>

<body bgcolor="#000000">
<div align="center">
  <table border="0" width="760" bgcolor="#000000" cellspacing="1" cellpadding="0">
  <center>
    <tr>
        <td bgcolor="#FFFFFF" colspan="2"><img border="0" src="http://www.amstaffpalads.dk/Billder/toppen%20copy.jpg" width="760" height="30"></td>
    </tr>
    <tr>
        <td bgcolor="#cccccc" colspan="2" height="15"> <font size="1" face="Tahoma">&nbsp;&nbsp;
          </font> </td>
    </tr>
    <tr>
        <td bgcolor="#FFFFFF" colspan="2"><img border="0" src="http://www.amstaffpalads.dk/Billder/toppet%20copy.jpg" width="760" height="55"></td>
    </tr>
    <tr>
          <td bgcolor="#cccccc" colspan="2" height="15"> <font size="1" face="Tahoma">
          </font><center>
            <a href="http://www.amstaffpalads.dk/galleri.htm"> <font face="Tahoma" size="1">Galleri</font></a><font face="Tahoma" size="1">&nbsp;&nbsp;
            <a href="http://www.amstaffpalads.dk/om.htm">Om Amstaff&nbsp;</a> &nbsp; <a href="http://www.amstaffpalads.dk/kontakt.htm">Kontakt
            os</a>&nbsp; &nbsp; <a href="http://www.amstaffpalads.dk/game%20starter.htm">Spil</a>&nbsp; &nbsp;
            <a href="http://www.amstaffpalads.dk/index.php">Forside</a>&nbsp; &nbsp; <a href="http://www.amstaffpalads.dk/Nyheder.htm">Nyheder</a>&nbsp;&nbsp; <a href="http://www.amstaffpalads.dk/links.htm">Links
        </a></font>
</center>  </td>
    </tr>
    </center>
   
 
        <table border="0" width="120%" height="165">
          <tr>
       
         
              <table border="0" width="88%" height="122" cellspacing="0" cellpadding="0">
           
              </table>
         
          </tr>

        </table>

      &nbsp;
        <p>&nbsp;
   
    <tr>
      <td bgcolor="#cccccc" colspan="2" height="15">
        <p align="center">  <?php




require("./gbog-ting/mysql-funktioner.php");
require("./gbog-ting/design-funktioner.php");
require("./gbog-ting/indstillinger.php");



if(is_array($HTTP_GET_VARS)) {
  $start_nr = $HTTP_GET_VARS['start_nr'];
} elseif (is_array($_GET)) {
  $start_nr = $_GET['start_nr'];
}



if(!$start_nr || $start_nr < 0) {
  $start_nr = 0;
}



echo top("");
echo "<p><a href=\"./\"></a></p>";



$sql = "select id, navn, url, epost, date_format(tid, '%e/%c %Y, %H:%i') as tiden, besked from gaestebog order by tid desc limit $start_nr, $antal_ad_gangen";
$taeller_sql = "select count(*) as antal from gaestebog";



aabn_forbindelse_og_vaelgdb();
$resultat = sql_spoerg_og_faa_svar($sql);
$optaelling = sql_spoerg_og_faa_svar($taeller_sql);
luk_forbindelse();



extract($optaelling[0]);


if($antal > ($start_nr + $antal_ad_gangen)) {
   
    $naeste_start_nr = $start_nr + $antal_ad_gangen;
    $naeste_nav = "<a href=\"$PHP_SELF?start_nr=$naeste_start_nr\">N&aelig;ste</a>";

} else {

    $naeste_nav = "<span class=\"doedt-link\">N&aelig;ste</span>";

}



if($start_nr > 0 && ($start_nr - $antal_ad_gangen) < $antal) {

    $forrige_start_nr = $start_nr - $antal_ad_gangen;
    $forrige_nav = "<a href=\"$PHP_SELF?start_nr=$forrige_start_nr\">Forrige</a>";

} else {

    $forrige_nav = "<span class=\"doedt-link\">Forrige</span>";

}



$nav = "<table width=\"$tabel_bredde\" border=\"0\" cellpadding=\"5\" cellspacing=\"0\">
    <tr><td align=\"left\" width=\"33%\">$forrige_nav</td>
    <td align=\"center\" width=\"34%\"><a href=\"skriv.php\">Skriv</a></td>
    <td align=\"right\" align=\"33%\">$naeste_nav</td></tr>
    </table>";



echo "$nav <p />";


if(count($resultat) < 1) {

  echo "Der er ingen indl&aelig;g i gBogen";

} else {

  for($i=0;$i<count($resultat);$i++) {


   
    extract($resultat[$i]);



    $besked = stripslashes($besked);
    $navn = stripslashes($navn);
    $epost = stripslashes($epost);
$url = stripslashes($url);
 

    if($html_p != "t") {
        $navn = htmlentities($navn);
        $epost = htmlentities($epost);
        $url = htmlentities($url);
        $besked = htmlentities($besked);
    }

 

    $besked = nl2br($besked);



    if(ereg("@", $epost)) {
        $navn = "<a href=\"mailto:$epost\">$navn</a>";
       
        if(ereg("http://", $url)) {
        $url = "<a href=\"$url\">$url</a>";
   
    }

 

?>

        <table width="<?php echo $tabel_bredde; ?>" cellpadding="1" cellspacing="0" border="0" align="center">
          <tr><td class="gbog-baggrund" width="100%" align="center">

            <table border="0" cellpadding="8" cellspacing="0" width="100%">
                <tr><td class="gbog-top" width="100%">Skrevet af: <strong><?php echo $navn; ?></strong>, <?php echo $tiden; ?></td></tr>
            </table>
<table border="0" cellpadding="8" cellspacing="0" width="100%">
                <tr><td class="gbog-top" width="100%">Hjemmeside: <strong><?php echo $Url; ?></strong></td></tr>
            </table>
        </td></tr><tr><td class="gbog-baggrund" align="center" width="100%">

            <table border="0" cellpadding="8" cellspacing="0" width="100%">
                <tr>
                  <td class="gbog-bund" width="100%">
                    <?php echo $besked; ?>
                  </td>
                </tr>
            </table>

        </td></tr>
    </table><p />

<center><?php



  }



  echo $nav;



}



echo bund();

?></center> </p>
      </td>
    </tr>
  </table>
  &nbsp;


</div>
</html>
<?php
ob_end_flush();
?>
********************************************************************************************************************************************************************

Parse error: parse error in /usr/home/whitehat_dk/users/monstar99/bibliotek_med_gaestebogen_i/gbog.php on line 298????????????????????????????????????????
Avatar billede lisa99 Nybegynder
06. maj 2003 - 15:51 #6
Parse error: parse error in /usr/home/whitehat_dk/users/monstar99/bibliotek_med_gaestebogen_i/gbog.php on line 298???????????????????????????????????????? fejl er rettet
Avatar billede fri-hash Nybegynder
06. maj 2003 - 16:12 #7
har du kontrolleret om url rent faktisk bliver smidt ind i databasen? hvis den gør har du kontrolleret om den bliver hevet ud af databasen?

så kan du lokalisere om det er insert-sætningen der fejler, select-sætningen der fejler eller om det blot er selve udskrivningen af variablen det er gal med
Avatar billede lisa99 Nybegynder
06. maj 2003 - 16:17 #8
hvordan gør jeg det?
der står som følger inde i  mysql:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<!-- saved from url=(0115)http://phpmyadmin.whitehat.dk/tbl_properties_structure.php?lang=da-iso-8859-1&server=1&db=monstar99&table=gaestebog -->
<HTML lang=da dir=ltr xml:lang="da"
xmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE>phpMyAdmin</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<STYLE type=text/css>BODY {
    FONT-SIZE: small; BACKGROUND-IMAGE: url(./images/vertical_line.gif); COLOR: #000000; BACKGROUND-REPEAT: repeat-y; FONT-FAMILY: arial, helvetica, geneva, sans-serif; BACKGROUND-COLOR: #f5f5f5
}
PRE {
    FONT-SIZE: small
}
TT {
    FONT-SIZE: small
}
TH {
    FONT-WEIGHT: bold; FONT-SIZE: small; COLOR: #000000; FONT-FAMILY: arial, helvetica, geneva, sans-serif; BACKGROUND-COLOR: #d3dce3
}
TD {
    FONT-SIZE: small; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
FORM {
    FONT-SIZE: small; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
INPUT {
    FONT-SIZE: small; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
INPUT.textfield {
    FONT-SIZE: small; COLOR: #000000; FONT-FAMILY: arial, helvetica, geneva, sans-serif; BACKGROUND-COLOR: #ffffff
}
SELECT {
    FONT-SIZE: small; COLOR: #000000; FONT-FAMILY: arial, helvetica, geneva, sans-serif; BACKGROUND-COLOR: #ffffff
}
TEXTAREA {
    FONT-SIZE: small; COLOR: #000000; FONT-FAMILY: arial, helvetica, geneva, sans-serif; BACKGROUND-COLOR: #ffffff
}
H1 {
    FONT-WEIGHT: bold; FONT-SIZE: large; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
A:link {
    FONT-SIZE: small; COLOR: #0000ff; FONT-FAMILY: arial, helvetica, geneva, sans-serif; TEXT-DECORATION: none
}
A:visited {
    FONT-SIZE: small; COLOR: #0000ff; FONT-FAMILY: arial, helvetica, geneva, sans-serif; TEXT-DECORATION: none
}
A:hover {
    FONT-SIZE: small; COLOR: #ff0000; FONT-FAMILY: arial, helvetica, geneva, sans-serif; TEXT-DECORATION: underline
}
A.nav:link {
    COLOR: #000000; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
A.nav:visited {
    COLOR: #000000; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
A.nav:hover {
    COLOR: #ff0000; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
A.h1:link {
    FONT-WEIGHT: bold; FONT-SIZE: large; COLOR: #000000; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
A.h1:visited {
    FONT-WEIGHT: bold; FONT-SIZE: large; COLOR: #000000; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
A.h1:hover {
    FONT-WEIGHT: bold; FONT-SIZE: large; COLOR: #ff0000; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
A.drop:link {
    COLOR: #ff0000; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
A.drop:visited {
    COLOR: #ff0000; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
A.drop:hover {
    COLOR: #ffffff; FONT-FAMILY: arial, helvetica, geneva, sans-serif; BACKGROUND-COLOR: #ff0000; TEXT-DECORATION: none
}
.nav {
    COLOR: #000000; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
.warning {
    FONT-WEIGHT: bold; FONT-SIZE: small; COLOR: #ff0000; FONT-FAMILY: arial, helvetica, geneva, sans-serif
}
TD.topline {
    FONT-SIZE: 1px
}
TD.tab {
    BORDER-RIGHT: #666 1px solid; BORDER-TOP: #999 1px solid; BORDER-LEFT: #999 1px solid; BORDER-BOTTOM-STYLE: none; border-radius: 2px; moz-border-radius: 2px
}
TABLE.tabs {
    BORDER-TOP-STYLE: none; BORDER-BOTTOM: #666 1px solid; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none
}
.syntax {
    FONT-SIZE: 90%; FONT-FAMILY: sans-serif
}
.syntax_comment {
   
}
.syntax_digit {
   
}
.syntax_digit_hex {
   
}
.syntax_digit_integer {
   
}
.syntax_digit_float {
   
}
.syntax_punct {
   
}
.syntax_alpha {
    TEXT-TRANSFORM: lowercase
}
.syntax_alpha_columnType {
    TEXT-TRANSFORM: uppercase
}
.syntax_alpha_columnAttrib {
    TEXT-TRANSFORM: uppercase
}
.syntax_alpha_reservedWord {
    FONT-WEIGHT: bold; TEXT-TRANSFORM: uppercase
}
.syntax_alpha_functionName {
    TEXT-TRANSFORM: uppercase
}
.syntax_alpha_identifier {
   
}
.syntax_alpha_variable {
   
}
.syntax_quote {
   
}
.syntax_quote_backtick {
   
}
.syntax_comment {
    COLOR: #808000
}
.syntax_comment_mysql {
   
}
.syntax_comment_ansi {
   
}
.syntax_comment_c {
   
}
.syntax_digit {
   
}
.syntax_digit_hex {
    COLOR: teal
}
.syntax_digit_integer {
    COLOR: teal
}
.syntax_digit_float {
    COLOR: aqua
}
.syntax_punct {
    COLOR: fuchsia
}
.syntax_alpha {
   
}
.syntax_alpha_columnType {
    COLOR: #ff9900
}
.syntax_alpha_columnAttrib {
    COLOR: #0000ff
}
.syntax_alpha_reservedWord {
    COLOR: #990099
}
.syntax_alpha_functionName {
    COLOR: #ff0000
}
.syntax_alpha_identifier {
    COLOR: black
}
.syntax_alpha_variable {
    COLOR: #800000
}
.syntax_quote {
    COLOR: #008000
}
.syntax_quote_double {
   
}
.syntax_quote_single {
   
}
.syntax_quote_backtick {
   
}
.syntax_indent0 {
    MARGIN-LEFT: 0em
}
.syntax_indent1 {
    MARGIN-LEFT: 1em
}
.syntax_indent2 {
    MARGIN-LEFT: 2em
}
.syntax_indent3 {
    MARGIN-LEFT: 3em
}
.syntax_indent4 {
    MARGIN-LEFT: 4em
}
.syntax_indent5 {
    MARGIN-LEFT: 5em
}
.syntax_indent6 {
    MARGIN-LEFT: 6em
}
.syntax_indent7 {
    MARGIN-LEFT: 7em
}
</STYLE>

<SCRIPT language=javascript type=text/javascript>
<!--
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
    && typeof(parent.document.title) == 'string') {
    parent.document.title = 'monstar99.gaestebog kører på localhost - phpMyAdmin 2.3.0';
}

// js form validation stuff
var errorMsg0  = 'Ingen værdi i formularen !';
var errorMsg1  = 'Dette er ikke et tal!';
var errorMsg2  = ' er ikke et gyldigt rækkenummer!';
var noDropDbMsg = '"DROP DATABASE" erklæringer kan ikke bruges.';
var confirmMsg  = 'Er du sikker på at du vil ';
//-->
</SCRIPT>

<SCRIPT language=javascript src="tbl_properties_structure-filer/functions.js"
type=text/javascript></SCRIPT>

<META content="MSHTML 6.00.2723.2500" name=GENERATOR></HEAD>
<BODY bgColor=#f5f5f5>
<H1>Database: <I><A class=h1
href="http://phpmyadmin.whitehat.dk/db_details.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99">monstar99</A></I>
- Tabel: <I><A class=h1
href="http://phpmyadmin.whitehat.dk/tbl_properties.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog">gaestebog</A></I>
kører på <I>localhost</I> </H1><!-- top menu -->
<TABLE class=tabs cellSpacing=0 cellPadding=3 width="100%" border=0>
  <TBODY>
  <TR>
    <TD width=8>&nbsp;</TD>
    <TD class=tab noWrap align=middle width=64 bgColor=silver><A
      href="http://phpmyadmin.whitehat.dk/tbl_properties_structure.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php"><B>Structure</B></A>
    </TD>
    <TD width=8>&nbsp;</TD>
    <TD class=tab noWrap align=middle width=64 bgColor=#dfdfdf><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=SELECT+%2A+FROM+%60gaestebog%60&amp;pos=0"><B>Vis</B></A>
    </TD>
    <TD width=8>&nbsp;</TD>
    <TD class=tab noWrap align=middle width=64 bgColor=#dfdfdf><A
      href="http://phpmyadmin.whitehat.dk/tbl_properties.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php"><B>SQL</B></A>
    </TD>
    <TD width=8>&nbsp;</TD>
    <TD class=tab noWrap align=middle width=64 bgColor=#dfdfdf><A
      href="http://phpmyadmin.whitehat.dk/tbl_select.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php"><B>Vælg</B></A>
    </TD>
    <TD width=8>&nbsp;</TD>
    <TD class=tab noWrap align=middle width=64 bgColor=#dfdfdf><A
      href="http://phpmyadmin.whitehat.dk/tbl_change.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php"><B>Indsæt</B></A>
    </TD>
    <TD width=8>&nbsp;</TD>
    <TD class=tab noWrap align=middle width=64 bgColor=#dfdfdf><A
      href="http://phpmyadmin.whitehat.dk/tbl_properties_export.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php"><B>Export</B></A>
    </TD>
    <TD width=8>&nbsp;</TD>
    <TD class=tab noWrap align=middle width=64 bgColor=#dfdfdf><A
      href="http://phpmyadmin.whitehat.dk/tbl_properties_operations.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php"><B>Operations</B></A>
    </TD>
    <TD width=8>&nbsp;</TD>
    <TD class=tab noWrap align=middle width=64 bgColor=#dfdfdf><A
      href="http://phpmyadmin.whitehat.dk/tbl_properties_options.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php"><B>Options</B></A>
    </TD>
    <TD width=8>&nbsp;</TD>
    <TD class=tab noWrap align=middle width=64 bgColor=#dfdfdf><A class=drop
      onclick="return confirmLink(this, 'DELETE FROM `gaestebog`')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=DELETE+FROM+%60gaestebog%60&amp;zero_rows=Tabel+gaestebog+er+t%F8mt"><B>Tøm</B></A>
    </TD>
    <TD width=8>&nbsp;</TD>
    <TD class=tab noWrap align=middle width=64 bgColor=#dfdfdf><A class=drop
      onclick="return confirmLink(this, 'DROP TABLE `gaestebog`')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;reload=1&amp;sql_query=DROP+TABLE+%60gaestebog%60&amp;zero_rows=Tabel+gaestebog+er+slettet"><B>Slet</B></A>
    </TD>
    <TD width=8>&nbsp;</TD></TR></TBODY></TABLE><BR><!-- TABLE INFORMATIONS -->
<FORM action=tbl_properties_structure.php><INPUT type=hidden value=da-iso-8859-1
name=lang> <INPUT type=hidden value=1 name=server> <INPUT type=hidden
value=monstar99 name=db> <INPUT type=hidden value=gaestebog name=table>
<TABLE border=0>
  <TBODY>
  <TR>
    <TD></TD>
    <TH>&nbsp;Feltnavn&nbsp;</TH>
    <TH>Datatype</TH>
    <TH>Attributter</TH>
    <TH>Nulværdi</TH>
    <TH>Standardværdi</TH>
    <TH>Ekstra</TH>
    <TH colSpan=6>Handling</TH></TR>
  <TR>
    <TD align=middle bgColor=#cccccc><INPUT id=checkbox_row_1 type=checkbox
      value=id name=selected_fld[]> </TD>
    <TD noWrap bgColor=#cccccc>&nbsp;<LABEL
      for=checkbox_row_1><U>id</U></LABEL>&nbsp;</TD>
    <TD noWrap bgColor=#cccccc>int(11)<BDO dir=ltr></BDO></TD>
    <TD noWrap bgColor=#cccccc>&nbsp;</TD>
    <TD bgColor=#cccccc>Nej&nbsp;</TD>
    <TD noWrap bgColor=#cccccc>&nbsp;</TD>
    <TD noWrap bgColor=#cccccc>auto_increment&nbsp;</TD>
    <TD bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/tbl_alter.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;field=id">Ændre</A>
    </TD>
    <TD bgColor=#cccccc><A
      onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP `id`')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+%60id%60&amp;zero_rows=Felt+id+er+slettet">Slet</A>
    </TD>
    <TD bgColor=#cccccc><A
      onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP PRIMARY KEY, ADD PRIMARY KEY(`id`)')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+PRIMARY+KEY%2C+ADD+PRIMARY+KEY%28id%2C+%60id%60%29&amp;zero_rows=Der+er+f%F8jet+en+prim%E6r+n%F8gle+til+id">Primær</A>
    </TD>
    <TD bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+INDEX%28%60id%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+id">Indeks</A>
    </TD>
    <TD bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+UNIQUE%28%60id%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+id">Unik</A>
    </TD>
    <TD noWrap bgColor=#cccccc>Fuldtekst </TD></TR>
  <TR>
    <TD align=middle bgColor=#dddddd><INPUT id=checkbox_row_2 type=checkbox
      value=tid name=selected_fld[]> </TD>
    <TD noWrap bgColor=#dddddd>&nbsp;<LABEL
    for=checkbox_row_2>tid</LABEL>&nbsp;</TD>
    <TD noWrap bgColor=#dddddd>datetime<BDO dir=ltr></BDO></TD>
    <TD noWrap bgColor=#dddddd>&nbsp;</TD>
    <TD bgColor=#dddddd>Nej&nbsp;</TD>
    <TD noWrap bgColor=#dddddd>0000-00-00 00:00:00&nbsp;</TD>
    <TD noWrap bgColor=#dddddd>&nbsp;</TD>
    <TD bgColor=#dddddd><A
      href="http://phpmyadmin.whitehat.dk/tbl_alter.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;field=tid">Ændre</A>
    </TD>
    <TD bgColor=#dddddd><A
      onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP `tid`')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+%60tid%60&amp;zero_rows=Felt+tid+er+slettet">Slet</A>
    </TD>
    <TD bgColor=#dddddd><A
      onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP PRIMARY KEY, ADD PRIMARY KEY(`tid`)')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+PRIMARY+KEY%2C+ADD+PRIMARY+KEY%28id%2C+%60tid%60%29&amp;zero_rows=Der+er+f%F8jet+en+prim%E6r+n%F8gle+til+tid">Primær</A>
    </TD>
    <TD bgColor=#dddddd><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+INDEX%28%60tid%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+tid">Indeks</A>
    </TD>
    <TD bgColor=#dddddd><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+UNIQUE%28%60tid%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+tid">Unik</A>
    </TD>
    <TD noWrap bgColor=#dddddd>Fuldtekst </TD></TR>
  <TR>
    <TD align=middle bgColor=#cccccc><INPUT id=checkbox_row_3 type=checkbox
      value=ip name=selected_fld[]> </TD>
    <TD noWrap bgColor=#cccccc>&nbsp;<LABEL
    for=checkbox_row_3>ip</LABEL>&nbsp;</TD>
    <TD noWrap bgColor=#cccccc>varchar(15)<BDO dir=ltr></BDO></TD>
    <TD noWrap bgColor=#cccccc>&nbsp;</TD>
    <TD bgColor=#cccccc>Nej&nbsp;</TD>
    <TD noWrap bgColor=#cccccc>&nbsp;</TD>
    <TD noWrap bgColor=#cccccc>&nbsp;</TD>
    <TD bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/tbl_alter.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;field=ip">Ændre</A>
    </TD>
    <TD bgColor=#cccccc><A
      onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP `ip`')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+%60ip%60&amp;zero_rows=Felt+ip+er+slettet">Slet</A>
    </TD>
    <TD bgColor=#cccccc><A
      onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP PRIMARY KEY, ADD PRIMARY KEY(`ip`)')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+PRIMARY+KEY%2C+ADD+PRIMARY+KEY%28id%2C+%60ip%60%29&amp;zero_rows=Der+er+f%F8jet+en+prim%E6r+n%F8gle+til+ip">Primær</A>
    </TD>
    <TD bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+INDEX%28%60ip%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+ip">Indeks</A>
    </TD>
    <TD bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+UNIQUE%28%60ip%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+ip">Unik</A>
    </TD>
    <TD noWrap bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+FULLTEXT%28%60ip%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+ip">Fuldtekst</A>
    </TD></TR>
  <TR>
    <TD align=middle bgColor=#dddddd><INPUT id=checkbox_row_4 type=checkbox
      value=navn name=selected_fld[]> </TD>
    <TD noWrap bgColor=#dddddd>&nbsp;<LABEL
    for=checkbox_row_4>navn</LABEL>&nbsp;</TD>
    <TD noWrap bgColor=#dddddd>varchar(100)<BDO dir=ltr></BDO></TD>
    <TD noWrap bgColor=#dddddd>&nbsp;</TD>
    <TD bgColor=#dddddd>Nej&nbsp;</TD>
    <TD noWrap bgColor=#dddddd>&nbsp;</TD>
    <TD noWrap bgColor=#dddddd>&nbsp;</TD>
    <TD bgColor=#dddddd><A
      href="http://phpmyadmin.whitehat.dk/tbl_alter.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;field=navn">Ændre</A>
    </TD>
    <TD bgColor=#dddddd><A
      onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP `navn`')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+%60navn%60&amp;zero_rows=Felt+navn+er+slettet">Slet</A>
    </TD>
    <TD bgColor=#dddddd><A
      onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP PRIMARY KEY, ADD PRIMARY KEY(`navn`)')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+PRIMARY+KEY%2C+ADD+PRIMARY+KEY%28id%2C+%60navn%60%29&amp;zero_rows=Der+er+f%F8jet+en+prim%E6r+n%F8gle+til+navn">Primær</A>
    </TD>
    <TD bgColor=#dddddd><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+INDEX%28%60navn%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+navn">Indeks</A>
    </TD>
    <TD bgColor=#dddddd><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+UNIQUE%28%60navn%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+navn">Unik</A>
    </TD>
    <TD noWrap bgColor=#dddddd><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+FULLTEXT%28%60navn%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+navn">Fuldtekst</A>
    </TD></TR>
  <TR>
    <TD align=middle bgColor=#cccccc><INPUT id=checkbox_row_5 type=checkbox
      value=epost name=selected_fld[]> </TD>
    <TD noWrap bgColor=#cccccc>&nbsp;<LABEL
    for=checkbox_row_5>epost</LABEL>&nbsp;</TD>
    <TD noWrap bgColor=#cccccc>varchar(100)<BDO dir=ltr></BDO></TD>
    <TD noWrap bgColor=#cccccc>&nbsp;</TD>
    <TD bgColor=#cccccc>Ja&nbsp;</TD>
    <TD noWrap bgColor=#cccccc><I>NULL</I>&nbsp;</TD>
    <TD noWrap bgColor=#cccccc>&nbsp;</TD>
    <TD bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/tbl_alter.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;field=epost">Ændre</A>
    </TD>
    <TD bgColor=#cccccc><A
      onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP `epost`')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+%60epost%60&amp;zero_rows=Felt+epost+er+slettet">Slet</A>
    </TD>
    <TD bgColor=#cccccc><A
      onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP PRIMARY KEY, ADD PRIMARY KEY(`epost`)')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+PRIMARY+KEY%2C+ADD+PRIMARY+KEY%28id%2C+%60epost%60%29&amp;zero_rows=Der+er+f%F8jet+en+prim%E6r+n%F8gle+til+epost">Primær</A>
    </TD>
    <TD bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+INDEX%28%60epost%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+epost">Indeks</A>
    </TD>
    <TD bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+UNIQUE%28%60epost%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+epost">Unik</A>
    </TD>
    <TD noWrap bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+FULLTEXT%28%60epost%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+epost">Fuldtekst</A>
    </TD></TR>
  <TR>
    <TD align=middle bgColor=#dddddd><INPUT id=checkbox_row_6 type=checkbox
      value=besked name=selected_fld[]> </TD>
    <TD noWrap bgColor=#dddddd>&nbsp;<LABEL
    for=checkbox_row_6>besked</LABEL>&nbsp;</TD>
    <TD noWrap bgColor=#dddddd>text<BDO dir=ltr></BDO></TD>
    <TD noWrap bgColor=#dddddd>&nbsp;</TD>
    <TD bgColor=#dddddd>Nej&nbsp;</TD>
    <TD noWrap bgColor=#dddddd>&nbsp;</TD>
    <TD noWrap bgColor=#dddddd>&nbsp;</TD>
    <TD bgColor=#dddddd><A
      href="http://phpmyadmin.whitehat.dk/tbl_alter.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;field=besked">Ændre</A>
    </TD>
    <TD bgColor=#dddddd><A
      onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP `besked`')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+%60besked%60&amp;zero_rows=Felt+besked+er+slettet">Slet</A>
    </TD>
    <TD bgColor=#dddddd>Primær </TD>
    <TD bgColor=#dddddd>Indeks </TD>
    <TD bgColor=#dddddd>Unik </TD>
    <TD noWrap bgColor=#dddddd><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+FULLTEXT%28%60besked%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+besked">Fuldtekst</A>
    </TD></TR>
  <TR>
    <TD align=middle bgColor=#cccccc><INPUT id=checkbox_row_7 type=checkbox
      value=url name=selected_fld[]> </TD>
    <TD noWrap bgColor=#cccccc>&nbsp;<LABEL
    for=checkbox_row_7>url</LABEL>&nbsp;</TD>
    <TD noWrap bgColor=#cccccc>varchar(255)<BDO dir=ltr></BDO></TD>
    <TD noWrap bgColor=#cccccc>&nbsp;</TD>
    <TD bgColor=#cccccc>Ja&nbsp;</TD>
    <TD noWrap bgColor=#cccccc><I>NULL</I>&nbsp;</TD>
    <TD noWrap bgColor=#cccccc>&nbsp;</TD>
    <TD bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/tbl_alter.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;field=url">Ændre</A>
    </TD>
    <TD bgColor=#cccccc><A
      onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP `url`')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+%60url%60&amp;zero_rows=Felt+url+er+slettet">Slet</A>
    </TD>
    <TD bgColor=#cccccc><A
      onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP PRIMARY KEY, ADD PRIMARY KEY(`url`)')"
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+PRIMARY+KEY%2C+ADD+PRIMARY+KEY%28id%2C+%60url%60%29&amp;zero_rows=Der+er+f%F8jet+en+prim%E6r+n%F8gle+til+url">Primær</A>
    </TD>
    <TD bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+INDEX%28%60url%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+url">Indeks</A>
    </TD>
    <TD bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+UNIQUE%28%60url%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+url">Unik</A>
    </TD>
    <TD noWrap bgColor=#cccccc><A
      href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+ADD+FULLTEXT%28%60url%60%29&amp;zero_rows=Der+er+tilf%F8jet+et+indeks+til+url">Fuldtekst</A>
    </TD></TR>
  <TR>
    <TD colSpan=13><IMG height=22 alt="Med det afmærkede:"
      src="tbl_properties_structure-filer/arrow_ltr.gif" width=38 border=0>
      <I>Med det afmærkede:</I>&nbsp;&nbsp; <INPUT type=submit value=Ændre name=submit_mult> &nbsp;<I>Eller</I>&nbsp; <INPUT type=submit value=Slet name=submit_mult>
</TD></TR></TBODY></TABLE></FORM><!-- Indexes, space usage and row statistics --><BR>
<TABLE cellSpacing=0 cellPadding=0 border=0>
  <TBODY>
  <TR>
    <TD><!-- Indexes form -->
      <FORM action=tbl_indexes.php method=post><INPUT type=hidden
      value=da-iso-8859-1 name=lang> <INPUT type=hidden value=iso-8859-1
      name=convcharset> <INPUT type=hidden value=1 name=server> <INPUT
      type=hidden value=monstar99 name=db> <INPUT type=hidden value=gaestebog
      name=table> Indekser&nbsp;: [<A
      href="http://www.mysql.com/doc/O/p/Optimising_Database_Structure.html"
      target=mysql_doc>Dokumentation</A>]<BR>
      <TABLE border=0>
        <TBODY>
        <TR>
          <TH>Nøgle</TH>
          <TH>Datatype</TH>
          <TH>Kardinalitet</TH>
          <TH colSpan=2>Handling</TH>
          <TH colSpan=2>Feltnavn</TH></TR>
        <TR>
          <TD bgColor=#dddddd>PRIMARY </TD>
          <TD bgColor=#dddddd>PRIMARY </TD>
          <TD align=right bgColor=#dddddd>23&nbsp; </TD>
          <TD bgColor=#dddddd><A
            onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP PRIMARY KEY')"
            href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+PRIMARY+KEY&amp;zero_rows=Prim%E6rn%F8glen+er+slettet">Slet</A>
          </TD>
          <TD bgColor=#dddddd><A
            href="http://phpmyadmin.whitehat.dk/tbl_indexes.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;index=PRIMARY">Ret</A>
          </TD>
          <TD bgColor=#dddddd colSpan=2>id </TD></TR>
        <TR>
          <TD bgColor=#cccccc>url </TD>
          <TD bgColor=#cccccc>INDEX </TD>
          <TD align=right bgColor=#cccccc>5&nbsp; </TD>
          <TD bgColor=#cccccc><A
            onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP INDEX `url`')"
            href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+INDEX+%60url%60&amp;zero_rows=Indeks+url+er+blevet+slettet">Slet</A>
          </TD>
          <TD bgColor=#cccccc><A
            href="http://phpmyadmin.whitehat.dk/tbl_indexes.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;index=url">Ret</A>
          </TD>
          <TD bgColor=#cccccc colSpan=2>url </TD></TR>
        <TR>
          <TD bgColor=#dddddd>epost </TD>
          <TD bgColor=#dddddd>INDEX </TD>
          <TD align=right bgColor=#dddddd>1&nbsp; </TD>
          <TD bgColor=#dddddd><A
            onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP INDEX `epost`')"
            href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+INDEX+%60epost%60&amp;zero_rows=Indeks+epost+er+blevet+slettet">Slet</A>
          </TD>
          <TD bgColor=#dddddd><A
            href="http://phpmyadmin.whitehat.dk/tbl_indexes.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;index=epost">Ret</A>
          </TD>
          <TD bgColor=#dddddd colSpan=2>epost </TD></TR>
        <TR>
          <TD bgColor=#cccccc>epost_2 </TD>
          <TD bgColor=#cccccc>INDEX </TD>
          <TD align=right bgColor=#cccccc>1&nbsp; </TD>
          <TD bgColor=#cccccc><A
            onclick="return confirmLink(this, 'ALTER TABLE `gaestebog` DROP INDEX `epost_2`')"
            href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;sql_query=ALTER+TABLE+%60gaestebog%60+DROP+INDEX+%60epost_2%60&amp;zero_rows=Indeks+epost_2+er+blevet+slettet">Slet</A>
          </TD>
          <TD bgColor=#cccccc><A
            href="http://phpmyadmin.whitehat.dk/tbl_indexes.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;index=epost_2">Ret</A>
          </TD>
          <TD bgColor=#cccccc colSpan=2>epost </TD></TR></TBODY></TABLE><BR>Dan et
      indeks på&nbsp;<INPUT class=textfield size=4 value=1
      name=idx_num_fields>&nbsp;kolonner &nbsp;<INPUT onclick="return checkFormElementInRange(this.form, 'idx_num_fields', 1)" type=submit value=Udfør name=create_index>
      </FORM></TD><!-- Space usage -->
    <TD width=20>&nbsp;</TD>
    <TD vAlign=top>Pladsforbrug&nbsp;: <A name=showusage></A>
      <TABLE border=0>
        <TBODY>
        <TR>
          <TH>Datatype</TH>
          <TH align=middle colSpan=2>Benyttelse</TH></TR>
        <TR>
          <TD style="PADDING-RIGHT: 10px" bgColor=#dddddd>Data</TD>
          <TD noWrap align=right bgColor=#dddddd>1,804</TD>
          <TD bgColor=#dddddd>Bytes</TD></TR>
        <TR>
          <TD style="PADDING-RIGHT: 10px" bgColor=#dddddd>Indeks</TD>
          <TD noWrap align=right bgColor=#dddddd>6,144</TD>
          <TD bgColor=#dddddd>Bytes</TD></TR>
        <TR>
          <TD style="PADDING-RIGHT: 10px" bgColor=#cccccc>Total</TD>
          <TD noWrap align=right bgColor=#cccccc>7,948</TD>
          <TD bgColor=#cccccc>Bytes</TD></TR></TBODY></TABLE></TD><!-- Rows Statistic -->
    <TD width=20>&nbsp;</TD>
    <TD vAlign=top>Række statistik&nbsp;:
      <TABLE border=0>
        <TBODY>
        <TR>
          <TH>Erklæringer</TH>
          <TH align=middle>Værdi</TH></TR>
        <TR>
          <TD bgColor=#dddddd>Format</TD>
          <TD noWrap align=left bgColor=#dddddd>dynamisk </TD></TR>
        <TR>
          <TD bgColor=#cccccc>Rækker</TD>
          <TD noWrap align=right bgColor=#cccccc>23 </TD></TR>
        <TR>
          <TD bgColor=#dddddd>Række længde&nbsp;ø</TD>
          <TD noWrap align=right bgColor=#dddddd>78 </TD></TR>
        <TR>
          <TD bgColor=#cccccc>Række størrelse &nbsp;ø</TD>
          <TD noWrap align=right bgColor=#cccccc>346 Bytes </TD></TR>
        <TR>
          <TD bgColor=#dddddd>Næste&nbsp;Autoindex</TD>
          <TD noWrap align=right bgColor=#dddddd>74
  </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<HR>
<!-- TABLE WORK -->
<UL><!-- Printable view of the table -->
  <LI>
  <DIV style="MARGIN-BOTTOM: 10px"><A
  href="http://phpmyadmin.whitehat.dk/tbl_printview.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php">Vis
  (udskriftvenlig)</A></DIV><!-- Add some new fields -->
  <LI>
  <FORM onsubmit="return checkFormElementInRange(this, 'num_fields', 1)"
  action=tbl_addfield.php method=post><INPUT type=hidden value=1 name=server>
  <INPUT type=hidden value=da-iso-8859-1 name=lang> <INPUT type=hidden
  value=monstar99 name=db> <INPUT type=hidden value=gaestebog name=table> Tilføj
  nyt felt&nbsp;: <INPUT class=textfield style="VERTICAL-ALIGN: middle"
  onfocus=this.select() maxLength=2 size=2 value=1 name=num_fields> <SELECT
  style="VERTICAL-ALIGN: middle" name=after_field> <OPTION value=--end--
    selected>I slutningen af tabel</OPTION> <OPTION value=--first-->I
    begyndelsen af tabel</OPTION> <OPTION value=id>Efter id</OPTION> <OPTION
    value=tid>Efter tid</OPTION> <OPTION value=ip>Efter ip</OPTION> <OPTION
    value=navn>Efter navn</OPTION> <OPTION value=epost>Efter epost</OPTION>
    <OPTION value=besked>Efter besked</OPTION> <OPTION value=url>Efter
    url</OPTION></SELECT> <INPUT style="VERTICAL-ALIGN: middle" type=submit value=Udfør> </FORM><!-- Let MySQL propose the optimal structure -->
  <LI>
  <DIV style="MARGIN-BOTTOM: 10px"><A
  href="http://phpmyadmin.whitehat.dk/sql.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php&amp;session_max_rows=all&amp;sql_query=SELECT+%2A+FROM+%60gaestebog%60+PROCEDURE+ANALYSE%28%29">Propose
  table structure</A> [<A
  href="http://www.mysql.com/doc/p/r/procedure_analyse.html"
  target=mysql_doc>Dokumentation</A>] </DIV><!-- Query box and bookmark support -->
  <LI><A name=querybox></A>
  <FORM name=sqlform onsubmit="return checkSqlQuery(this)" action=read_dump.php
  method=post encType=multipart/form-data><INPUT type=hidden value=0
  name=is_js_confirmed> <INPUT type=hidden value=da-iso-8859-1 name=lang> <INPUT
  type=hidden value=iso-8859-1 name=convcharset> <INPUT type=hidden value=1
  name=server> <INPUT type=hidden value=monstar99 name=db> <INPUT type=hidden
  value=gaestebog name=table> <INPUT type=hidden value=0 name=pos> <INPUT
  type=hidden value=tbl_properties_structure.php name=goto> <INPUT type=hidden
  value="Din SQL-forespørgsel blev udført korrekt" name=zero_rows> <INPUT
  type=hidden name=prev_sql_query> Kør SQL forspørgsel(er) på database monstar99
  [<A href="http://www.mysql.com/doc/S/E/SELECT.html"
  target=mysql_doc>Dokumentation</A>]&nbsp;&nbsp;&nbsp;Felter: <SELECT size=1
  name=dummy> <OPTION value=id selected>id</OPTION> <OPTION
    value=tid>tid</OPTION> <OPTION value=ip>ip</OPTION> <OPTION
    value=navn>navn</OPTION> <OPTION value=epost>epost</OPTION> <OPTION
    value=besked>besked</OPTION> <OPTION value=url>url</OPTION></SELECT> <INPUT onclick="sqlform.sql_query.value = sqlform.sql_query.value + sqlform.dummy.value" type=button value=Indsæt name=insert>
  <BR>
  <DIV style="MARGIN-BOTTOM: 5px"><TEXTAREA dir=ltr onfocus="if (typeof(document.layers) == 'undefined' || typeof(textarea_selected) == 'undefined') {textarea_selected = 1; this.form.elements['sql_query'].select();}" name=sql_query rows=7 wrap=virtual cols=80>SELECT * FROM `gaestebog` WHERE 1</TEXTAREA><BR><INPUT
  id=checkbox_show_query type=checkbox CHECKED value=1 name=show_query>&nbsp;
  <LABEL for=checkbox_show_query>Vis forespørgslen her igen
  </LABEL><BR></DIV><I>Eller</I> Tekstfilens placering&nbsp;:<BR>
  <DIV style="MARGIN-BOTTOM: 5px"><INPUT class=textfield type=file
  name=sql_file><BR></DIV><INPUT type=submit value=Udfør name=SQL> </FORM><!-- Insert a text file -->
  <LI>
  <DIV style="MARGIN-BOTTOM: 10px"><A
  href="http://phpmyadmin.whitehat.dk/ldi_table.php?lang=da-iso-8859-1&amp;convcharset=iso-8859-1&amp;server=1&amp;db=monstar99&amp;table=gaestebog&amp;goto=tbl_properties.php&amp;goto=tbl_properties_structure.php&amp;back=tbl_properties_structure.php">Importer
  tekstfil til tabellen</A></DIV></LI></UL></BODY></HTML>
Avatar billede fri-hash Nybegynder
06. maj 2003 - 16:35 #9
det der er bare koden på den webside du kan administrere din database med (phpmyadmin)

du skal gå ind på http://phpmyadmin.whitehat.dk og logge på med dine oplysninger ... derefter vælger du din database og tabel i framen til venstre ... tabellens struktur vises så i højre frame, hvor der skal være et link der hedder "[VIS]" ...klik på dette for at se indholdet i tabellen
Avatar billede lisa99 Nybegynder
06. maj 2003 - 16:38 #10
id  tid  ip  navn  epost  besked  url 
Ret  Slet  51 2003-05-04 13:49:57 62.107.4.206 Louise Mønster monstar99@msn.com hej hej NULL
Ret  Slet  52 2003-05-04 14:04:35 62.107.4.206 Louise Mønster monstar99@msn.com hej NULL
Ret  Slet  53 2003-05-04 14:43:36 62.107.4.206 LOUISE monstar99@msn.com http://www.eksperten.dk/ NULL
Ret  Slet  54 2003-05-05 15:42:01 62.107.4.206 monstar99 monstar99@msn.com hjaskh http://www.amstaffpalads.dk
Ret  Slet  55 2003-05-05 22:04:15 62.107.4.206 Louise & Cynide monstar99@msn.com HEJ url
Ret  Slet  56 2003-05-05 22:05:27 62.107.4.206 Louise & Cynide monstar99@msn.com HEJ url
Ret  Slet  57 2003-05-05 22:07:07 62.107.4.206 louise monstar99@msn.com http://www.amstaffpalads.dk url
Ret  Slet  58 2003-05-05 22:10:44 62.107.4.206 Louise & Cynide monstar99@msn.com fshsh url
Ret  Slet  59 2003-05-06 10:17:10 62.107.4.206 monstar99 monstar99@msn.com dgg url
Ret  Slet  60 2003-05-06 10:26:05 62.107.4.206 monstar99 monstar99@msn.com hej med jer url
Ret  Slet  61 2003-05-06 10:32:10 62.107.4.206 Louise monstar99@msn.com hjemmeside url
Ret  Slet  62 2003-05-06 10:37:43 62.107.4.206 Louise monstar99@msn.com hej url
Ret  Slet  63 2003-05-06 10:42:40 62.107.4.206 Louise monstar99@msn.com hej url
Ret  Slet  64 2003-05-06 10:46:39 62.107.4.206 Louise monstar99@msn.com helrkhel url
Ret  Slet  65 2003-05-06 13:54:20 62.107.4.206 monstar99 monstar99@msn.com hej url
Ret  Slet  66 2003-05-06 14:29:34 62.107.4.206 Louise monstar99@msn.com hej her er jeg url
Ret  Slet  67 2003-05-06 14:35:28 62.107.4.206 Louise monstar99@msn.com gdfg url
Ret  Slet  68 2003-05-06 14:36:41 62.107.4.206 Louise monstar99@msn.com sdgs url
Ret  Slet  69 2003-05-06 14:57:29 62.107.4.206 Louise monstar99@msn.com fas url
Ret  Slet  70 2003-05-06 15:01:27 62.107.4.206 Louise monstar99@msn.com rwer http://www.amstaffpalads.dk
Ret  Slet  71 2003-05-06 15:18:41 62.107.4.206 Louise monstar99@msn.com gfwgd http://www.amstaffpalads.dk
Ret  Slet  72 2003-05-06 15:24:32 62.107.4.206 Louise monstar99@msn.com fasf http://www.amstaffpalads.dk
Ret  Slet  73 2003-05-06 16:09:31 80.63.255.118 fri-hash test@test.dk dette er blot en test, undskyld hvis det spammer http://testURL.com
Avatar billede lisa99 Nybegynder
06. maj 2003 - 16:39 #11
så det stor rigtigt i mysql ikk?
Avatar billede fri-hash Nybegynder
06. maj 2003 - 16:47 #12
jo det står rigtigt, jeg tror jeg har lokaliseret fejlen til at være meget simpel (men godt gemt i alt det viste kode *G*)

dette
<tr><td class="gbog-top" width="100%">Hjemmeside: <strong><?php echo $Url; ?></strong></td></tr>

er IKKE det samme som
<tr><td class="gbog-top" width="100%">Hjemmeside: <strong><?php echo $url; ?></strong></td></tr>

altså $Url (stort U) er ikke den variabel der har fået tildelt værdien fra databasen, den hedder $url(lille u)
Avatar billede lisa99 Nybegynder
06. maj 2003 - 16:49 #13
så jeg skal bare lave om i databasen og skriv url med lille der også så skulle det virke? ikk?
Avatar billede lisa99 Nybegynder
06. maj 2003 - 16:50 #14
med stort
Avatar billede fri-hash Nybegynder
06. maj 2003 - 16:51 #15
jeg tror det er nok at rette
<?php echo $Url; ?>

til
<?php echo $url; ?>
Avatar billede lisa99 Nybegynder
06. maj 2003 - 16:53 #16
det har jeg gjort og nu virker det fedt takker
Avatar billede fri-hash Nybegynder
06. maj 2003 - 16:54 #17
selv tak
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Vi tilbyder markedets bedste kurser inden for webudvikling

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester