Insert til MySQL virker kun nogle gange
Jeg har lavet mit eget news-script og troede faktisk, at det fungerede kanon. Desværre (eller heldigvis) opdagede jeg ved et tilfælde, at data i visse tilfælde ikke indsættes i databasen.Hvis jeg f.eks copy/paster denne nyhed til newstext-boksen, bliver intet indsat. Why oh why ??
http://edition.cnn.com/2004/TECH/space/03/19/asteroid.ap/index.html
<?PHP
session_start();
$today = date("Y-m-d");
$now = date("H:i:s");
$author=$_SESSION['name'];
if ($newshead != '')
{
include 'upload/upload.php';
$sql = "INSERT INTO news (news_header,news_pic, news_text, news_author, news_date, news_time, news_cat) VALUES ('$newshead', '$newpic_name', '$newstext', '$loguser[name]', '$today', '$now', '$newscat')";
$result = mysql_query($sql);
$newshead = "";
}
?>
<td align="center"><h1 align="center">News Submit</h1>
<p align="center"><img src="http://ad.ads.dk/marketing/tradedoubler/uge50/468x60.gif"></p>
<table class="box" width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="title">
<p>News submission box</p>
</td>
</tr>
<tr>
<td>
<?php echo 'pic: '.$newpic_name; ?>
<form name="news" method="post" action="index.php?show=newspost" enctype="multipart/form-data">
<table border="0" align="center" cellpadding="3" cellspacing="3">
<tr>
<td width="100"><div align="right">Categori:</div></td>
<td><select name="newscat" id="newscat">
<option>Server</option>
<option>Website</option>
<option>Mohaa</option>
<option>Breakthrough</option>
</select></td>
<td width="100"> </td>
</tr>
<tr>
<td><div align="right">Picture:</div></td>
<td><INPUT TYPE="file" NAME="newpic" SIZE="50"></td>
<td> </td>
</tr>
<tr>
<td><div align="right">Header:</div></td>
<td><input name="newshead" type="text" id="newshead" size="68"></td>
<td> </td>
</tr>
<tr>
<td valign="top"><div align="right">News-text:</div></td>
<td>
<p>
<textarea name="newstext" cols="70" rows="15" id="newstext"></textarea>
</p>
<p align="center">
<input type="submit" name="Submit" value="Post news">
</p></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<tr>
<td width="95%" class="title">Newssystem Copyright by: [LLC] Dooleynator 2004</td>
</tr>
</td>
