MYSQL insert error

Anon

Hello.

I have the next problem about insert values into a Mysql table.

Warning: MySQL: Unable to save result set in /usr/local/apache-1.3.12-DSO/htdocs/login/backend.php on line 409

Warning: MySQL: Unable to save result set in /usr/local/apache-1.3.12-DSO/htdocs/login/backend.php on line 410

Warning: MySQL: Unable to save result set in /usr/local/apache-1.3.12-DSO/htdocs/login/backend.php on line 411
I have tested my code in other computer and its works right.
but looking the logs with "tail" i can see the insert did it right, Althought display that wrongs. I think this error is caused because the apache user is not root? The select do it with no errors.

Must I insert any user or host in my Mysql table ??

Anon

you need a mysql user for the database (the one you specify with the USER Paramter when opening a connection to the MYSQL Server, this (Mysql User) needs of course all the rights you want him to use e.g. SELECT, INSERT, UPDATE ... you can give a user these rights for single tables, single databases or globally, have a look at the mysql manual for that...
But it has nothing to do with your apache user!! Giving Apache root rights sounds really funny (can I have your domain name to play a bit with it ? :-)) Just don't do it !!!!

But to solve your problem try to figure out what kind of error you get from mysql...
after each of your three mysql operations 409 -411 insert a
print "<b>Generated Error:</b> " . mysql_error();
that should give you a hint whats going wrong ...

cya Rob

Anon

:-D better, i'll dont say my domain ;-D.

I thought That open database connection with "root" from a php document was enought, but I dont think that user is needed to insert values. All examples in the web do it with user "root".
I look for some information on the web.

thank you