Go4Expert - View Single Post

zeal

add.php

Code:

<?
<html>

<head>
<style>
   <link rel="stylesheet" type="text/css" href="../misc/css1.css">
</style>

<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>International Cricket News</title>
</head>
<script language="JavaScript">
		function validateForm(objForm)
		{
			if (objForm.nhead.value == '')
			{
				alert('Please Enter A News Heading!!!');
				objForm.nhead.focus();
				return false;
			}
			else
			return true;
		}	
</script>
<body>
<hr>
	<font face=arial size=4>
		<b> News</b><br>
		<br>
</font>
<form action="insertnews.php" method="post" onSubmit='return validateForm(this);'>
<table border="0" width="100%">
  <tr class="smallfontblack">
    <td width="17%">Heading<sup><font color=red>*</font></sup></td>
    <td width="83%"><input type="text" name="nhead" size="100" maxlength=255 class="input_ns"></td>
  </tr>
    <tr class="smallfontblack">
    <td width="17%">News Message</td>
    <td width="83%"><textarea name="nmsg" cols="100" rows="10" class="input_ns"></textarea></td>
  </tr>
   <tr class="smallfontblack">
    <td width="17%">ScortBord Link<sup><font color=red>*</font></sup></td>
    <td width="83%"><input type="text" name="score" size="30" maxlength=255 class="input_ns"></td>
  </tr>
   <tr class="smallfontblack">
    <td width="17%">Live Match Link<sup><font color=red>*</font></sup></td>
    <td width="83%"><input type="text" name="lmatch" size="30" maxlength=255 class="input_ns"></td>
  </tr>
   <tr class="smallfontblack">
    <td width="17%">Rating Link<sup><font color=red>*</font></sup></td>
    <td width="83%"><input type="text" name="rlink" size="30" maxlength=255 class="input_ns"></td>
  </tr>
   <tr class="smallfontblack">
    <td width="17%">Other Link Title<sup><font color=red>*</font></sup></td>
    <td width="83%"><input type="text" name="olinktit" size="20" maxlength="255" class="input_ns"></td>
  </tr>
   <tr class="smallfontblack">
    <td width="17%">Other Link URL<sup><font color=red>*</font></sup></td>
    <td width="83%"><input type="text" name="olinkurl" size="30" maxlength=255 class="input_ns"></td>
  </tr>

  <tr>
    <td width="17%"><input type="submit" value="Save" name="submit" class="input_ns">
      <p></td>
    <td width="83%"></td>
  </tr>
  <tr>
    <td width="17%"></td>
    <td width="83%"></td>
  </tr>
  <tr>
    <td width="17%"></td>
    <td width="83%">&nbsp;</td>
  </tr>
</table>
<p>&nbsp;&nbsp;&nbsp; </p>
</form>
</body>

</html>

insert.php

Code:

<?

	// opening connection and seting for errors
	include "../lib/lib.php";
	//error_reporting(5);
	$ctname=getPost("nhead");	
	$count=getPost("nmsg");
	$slink=getPost("score");
	$livematch=getPost("lmatch");
	$slink=getPost("score");	
	$rlink=getPost("rlink");
	$olinktit=getPost("olinktit");
	$olinkurl=getPost("olinkurl");	
	$strQuery="insert into news(nheading,ndetail,ndate,scorebord,livematch,ratting,olinktitle,olinkurl)
	 values('$ctname','$count',sysdate(),'$slink','$livematch','$rlink',
	 '$olinktit','$olinkurl')";
	Update($strQuery);
	header("Location:view_news.php");
?>

the problem is in description of news, in mysql database i have kept the data type of "nmsg" is "TEXT"