Not updating tables with data but no errors either

2002-01-17 Thread fla wire

Hello,
I have a freebsd machine running mysql and php.  Yes I am one of those
newbies.
I have read the FU*K manual. I have a sams learn in 21 day book. also a php
essentials and build your own database drive book. I have a brazilian rain
forest of manuals,printouts etc.

We have a php page that we put in people that belong to a football pool.
However it is not adding the data to the table. We do not get any error
messages either even tho the php page is setup to display the errors.
I find no errors in the http-errrors.log. the httpd-access.log shows the
post with no errors.
I have checked permissions and the seem right.
I can go to the machine and add a person by command line. Using the same
info as in the mysql_connect on the php page i can add from the
command line.

Any help, direction or clues is greatly appreciated.

mark





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Not updating tables with data but no errors either

2002-01-17 Thread Carsten H. Pedersen

 We have a php page that we put in people that belong to a football pool.
 However it is not adding the data to the table. We do not get any error
 messages either even tho the php page is setup to display the errors.
 I find no errors in the http-errrors.log. the httpd-access.log shows the
 post with no errors.

You're looking in the wrong logs. Find the hostname.err
file in the mysql data directory, and look through that.

You may also want to try using the update log
(mysqld --update_log=...). This will help you find
out if the requests do indeed make it to the server.

/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Not updating tables with data but no errors either

2002-01-17 Thread nod

On Thursday 17 Jan 2002 4:52 pm, fla wire wrote:
 Hello,
 I have a freebsd machine running mysql and php.  Yes I am one of those
 newbies.
 I have read the FU*K manual. I have a sams learn in 21 day book. also a php
 essentials and build your own database drive book. I have a brazilian rain
 forest of manuals,printouts etc.

 We have a php page that we put in people that belong to a football pool.
 However it is not adding the data to the table. We do not get any error
 messages either even tho the php page is setup to display the errors.
 I find no errors in the http-errrors.log. the httpd-access.log shows the
 post with no errors.
 I have checked permissions and the seem right.
 I can go to the machine and add a person by command line. Using the same
 info as in the mysql_connect on the php page i can add from the
 command line.

tried the mysql_error() function in php ? printed the connection variable to 
check you have a resource id ?



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php