insert into table
Jeg har dette script. Det ser ud til at vaere ok, men der er noget galt, da det dataene ikke bliver indsat i tabellen. Hvad goer jeg galt?<?php
if($ok){
$tabel = "press";
$insertSQL = "INSERT INTO $tabel (date, author, organisation, country, headline, text)
values('$date', '$author', '$organisation', '$country', '$headline', '$text')";
if(mysql_query($insertSQL)){
echo "The Press Release is accepted.";
$dato_array = getdate();
$date = $dato_array["mday"] . "/" . $dato_array["mon"] . "-" . $dato_array["year"];
}
}
else{
?>
<form action="<?php echo $PHP_SELF;?>" method="post">
Author:<br>
<input type=text name=author><br>
Organisation:<br>
<input type=text name=organisation><br>
Country:<br>
<input type=text NAME="country"><br>
Headline:<br>
<input type=text name=headline><br>
Text:<br>
<textarea name=text cols=35 rows=10></textarea><br>
<input type=submit value=Save>
</form>
<?
}
?>
