$query="INSERT INTO news VALUES($newsid,'$title','$author',$posted,'$body' )";
-----Original Message----- From: menezesd [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 12:03 AM To: [EMAIL PROTECTED] Subject: [PHP] Need some help please 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
