Fejl i php...
Den kommer med en fejlmeddelelse:You have an error in your SQL syntax near '' at line 1
Kan ikke lige regne den ud.. HAr prøvet og prøvet.. Hmm..
Håber I kan nogle tricks.. :-)
------------------------------------------
<?php
include("header.php");
?>
<?php if($action == "Gem"){ ?>
<?php
$conn = mysql_connect("xxxxx", "xxxx", "xxxx");
mysql_select_db("xxxxx");
mysql_query("update projekt_cd set artist='$artist', titel='$titel', genre='$genre', tilbud='$tilbud', nyhed='$nyhed', tilfojet='$tilfojet', tekst='$tekst', tracks='$tracks', pris='$pris' where id = $id") or die(mysql_error());
?>
<DIV STYLE="text-align:center"><B><FONT FACE="Arial" SIZE="-2" COLOR="#FF0000">Cd'en er nu rettet databasen. Den har id-nummer:</FONT></B></DIV>
<?
}
?>
<?php
$conn = mysql_connect("xxxxx", "xxxxx", "xxxxx");
mysql_select_db("xxxxx");
$result = mysql_query("select * from projekt_cd where id='$id'");
while ($row = mysql_fetch_array($result)) {
?>
<FORM ACTION="<? echo $PHP_SELF; ?>?action=Gem" ENCTYPE="x-www-form-urlencoded" METHOD="POST">
<TABLE BORDER="0" CELLSPACING="0" CELLPADDING="3">
<TR>
<TD ALIGN="left"><B><FONT FACE="Arial" SIZE="-1" COLOR="#FFFFFF">ID: </FONT></B></TD>
<TD ALIGN="left"><INPUT TYPE="text" VALUE="<? echo $row["id"]; ?>" SIZE="5" MAXLENGTH="5" NAME="artist" CLASS="but"></TD>
</TR>
<TR>
<TD ALIGN="left"><B><FONT FACE="Arial" SIZE="-1" COLOR="#FFFFFF">Artist: </FONT></B></TD>
<TD ALIGN="left"><INPUT TYPE="text" VALUE="<? echo $row["artist"]; ?>" SIZE="20" MAXLENGTH="50" NAME="artist" CLASS="but"></TD>
</TR>
<TR>
<TD ALIGN="left"><B><FONT FACE="Arial" SIZE="-1" COLOR="#FFFFFF">Tittel: </FONT></B></TD>
<TD ALIGN="left"><INPUT TYPE="text" VALUE="<? echo $row["titel"]; ?>" class="but" SIZE="20" MAXLENGTH="50" NAME="titel"></TD>
</TR>
<TR>
<TD ALIGN="left"><B><FONT SIZE="-1" COLOR="#FFFFFF"><FONT FACE="Arial">Genre: </FONT></FONT></B></TD>
<TD ALIGN="left">
<SELECT SIZE="1" NAME="genre" class="but">
<OPTION>Blues
<OPTION>Dance
<OPTION>HipHop
<OPTION>Jazz
<OPTION>Classic
<OPTION>Metal
<OPTION>Opera
<OPTION>Opsamlinger
<OPTION>POP
<OPTION>Rap
<OPTION>Rock
<OPTION>Soul
<OPTION>Techno
</SELECT></TD>
</TR>
<TR>
<TD ALIGN="left"><B><FONT SIZE="-1" COLOR="#FFFFFF"><FONT FACE="Arial">Tilbud: </FONT></FONT></B></TD>
<TD ALIGN="left"><INPUT TYPE="checkbox" VALUE="2" NAME="tilbud"></TD>
</TR>
<TR>
<TD ALIGN="left"><B><FONT SIZE="-1" COLOR="#FFFFFF"><FONT FACE="Arial">Nyhed: </FONT></FONT></B></TD>
<TD ALIGN="left"><INPUT TYPE="checkbox" VALUE="2" NAME="nyhed"></TD>
</TR>
<TR>
<TD ALIGN="left"><B><FONT FACE="Arial" SIZE="-1" COLOR="#FFFFFF">Tiløjet af: </FONT></B></TD>
<TD ALIGN="left"><INPUT TYPE="text" VALUE="<? echo $row["tilfojet"]; ?>" class="but" SIZE="20" MAXLENGTH="50" NAME="tilfojet"></TD>
</TR>
<TR>
<TD ALIGN="left"><B><FONT FACE="Arial" SIZE="-1" COLOR="#FFFFFF">
Om Cd'en: </FONT></B></TD>
<TD ALIGN="left"><TEXTAREA WRAP="physical" ROWS="20" COLS="50" NAME="tekst" CLASS="but"><? echo $row["tekst"]; ?></TEXTAREA></TD>
</TR>
<TR>
<TD ALIGN="left"><B><FONT FACE="Arial" SIZE="-1" COLOR="#FFFFFF">
Tracks: </FONT></B></TD>
<TD ALIGN="left"><TEXTAREA WRAP="physical" ROWS="20" COLS="50" NAME="tracks" class="but"><? echo $row["tracks"]; ?></TEXTAREA></TD>
</TR>
<TR>
<TD ALIGN="left"><B><FONT FACE="Arial" SIZE="-1" COLOR="#FFFFFF">Pris: </FONT></B></TD>
<TD ALIGN="left"><INPUT TYPE="text" VALUE="<? echo $row["pris"]; ?>" SIZE="6" MAXLENGTH="6" NAME="pris" CLASS="but"></TD>
</TR>
<TR>
<TD ALIGN="left"></TD>
<TD ALIGN="left"><INPUT TYPE="submit" VALUE="Gem" NAME="Gem" class="button"> <INPUT TYPE="reset" VALUE="Slet" NAME="Slet" class="button"></TD>
</TR>
</TABLE>
<INPUT TYPE="submit" VALUE="Gem" NAME="Gem" class="button">
<?
}
mysql_close($conn);
?>
<?php
include("footer.php");
?>
------------------------------------------------
