connecting to mysql

[ferg]

Can you please help me on this issue.

I created a mysql database name MIKE in /usr/local/mysql/var/
and it has 3 tables - client, transaction and property. They appear to be ok as I can update the tables from the command prompt.

I have some php scripts in /www/htdocs/project/ that are supposed to open this database and do add changes and deletes. Across the network I can reach these PHP files running on Apache, fill out the input boxes on the web pages but when I hit submit the database/tables are not updated. Could it be that because the php files and the database reside in different places I am having this problem? Thanks for your help.

[John_Canyon]

Post your script. You may have an error that is preventing the table from being updated, you may not have the database permissions configured properly, you may have in error in your mysql_connect, there are numerous issues that could be causing this, it is however easier to see what you are doing in order to better help.

Cheers,

John