Hello Friends.
I know I am asking for too much. But somehow, I am stuck
with three books I am refering and still not being able to
solve my problem, which I would greatly appreciate if any
of you gurus can assist. The problem is as follows :
I have three sections in this mail :
1. My table structure
2. My test.html file whose ACTION is testphp1.php file
3. My testphp1.php file.
The problem is that I keep getting the error "error adding
rows" as the rows are not adding in the database.
My table structure :
====================
Table name : news
Fields :
newsid INT(11)
title carchar(100)
author varchar(40)
posted INT(11)
body MEDIUMTEXT
My test.htm file :
==================
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="testphp1.php">
<p>
<input type="text" name="newsid">
</p>
<p>
<input type="text" name="title">
</p>
<p>
<input type="text" name="author">
</p>
<p>
<input type="text" name="body">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>
My testphp1.php file :
======================
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<?
$link=mysql_connect("localhost","menezesd","FX3PYTys");
if ($link){
print "link id is $link";
} else {
print "error connecting to database";
}
$posted=time();
$query="INSERT INTO 'news'
('newsid','title','author', 'posted', 'body')
VALUES($newsid,'$title','$author',$posted,'$body' )";
print ($query);
IF (mysql_query($query)){
print "Row added to table";
} else {
print "error adding row";
}
mysql_close($link);
?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
