Hi.  A quick hack to figure out your problem is 
to change:

IF (mysql_query($query)){
  print "Row added to table";
 } else {
 print "error adding row";
 }

To:

if (!$result = mysql_query($query)) {
  print 'Query Error: ' . mysql_error();
  exit;
} else {
  print 'Success! Row added.';
}

In short, mysql_error() is your friend.

Regards,
Philip Olson




On Tue, 2 Apr 2002, menezesd wrote:

> 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

Reply via email to