[PHP-DB] Update Query?

2001-10-01 Thread Jay Paulson
Hello- I'm trying to run an update query in an application I'm making. I keep getting a MySQL error however when I try and print out the mysql_error() nothing is returned. I run the same query in phpMyAdmin and the query runs fine. Below is the update query I'm running and the php code that

[PHP-DB] Last Modified question..

2001-08-28 Thread Jay Paulson
I have a problem... I want to check the last modified time that a file was changed/updated. Actually, it's an employee database that I'm working on and I thought about just checking the last modified date on the file that the information was stored on. However, I get a permission denied error

Re: [PHP-DB] Last Modified question..

2001-08-28 Thread Jay Paulson
] To: Jay Paulson [EMAIL PROTECTED] Cc: PHP DB list (E-mail) [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 4:44 PM Subject: Re: [PHP-DB] Last Modified question.. a) What kind of database is this? b) use fstat() to check the modification time on a specific file. c) You will have to modify

Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Jay Paulson
but it worked for me Dan -- From: Jay Paulson Reply To: Jay Paulson Sent: Wednesday, August 22, 2001 11:29 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] restoring mysql db after mysqldump Hello everyone- I have done the mysqldump function and got

[PHP-DB] MySQL ERROR 1036: Table 'foo' is read only

2001-08-22 Thread Jay Paulson
Running on RH, Apache. I had this working on Win2K, then switched to Linux by running the mysqldump then moving over the dump file and runing the mysql -u root -p 'add_databases.sql'. It creates the database then the table and then it tries to populate the table and i get an ERROR 1036: Table

Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Jay Paulson
: Rick Emery [EMAIL PROTECTED] To: 'Jay Paulson' [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 12:18 PM Subject: RE: [PHP-DB] restoring mysql db after mysqldump Are your privileges in MySQL set correctly? If ROOT doesn't have read/write access, the script

[PHP-DB] MySQL read only?

2001-08-22 Thread Jay Paulson
Anyone know why a MySQL table is set to read only? I'm logged in as the root user of MySQL and I have checked the privalages of the root user in the MySQL table and everything is set to Yes and I'm able to add and delete users in the MySQL table. Here's what I did... I had a database on my

[PHP-DB] MySQL read only?

2001-08-21 Thread Jay Paulson
Hello everyone-- I keep getting an error with MySQL when I try to Update or Insert a record into my database. The error message is as follows: MySQL said: Table 'zone' is read only I went and checked the files and set the permissions on them so that they were read and write only but that