[PHP-DB] Create Temporary Table

Hi, PHP Version 4.3.1 Mysql Version 4.0.13 When I try and run the following query CREATE TEMPORARY TABLE temptable AS SELECT * FROM permtable; on each database, the first one will run it with no problems at all. The second returns the error: [server] ERROR 1044: Access denied for user:

Re: [PHP-DB] php.ini

On Sunday 06 July 2003 00:13, frank wrote: i found that even i have not the php.ini in my SYSTEMROOT, php can still run ... why? For window XP, should it be placed in c:/WINDOWS? or any other ? If no php.ini is found then default values will be used. -- Jason Wong - Gremlins Associates -

Re: [PHP-DB] Create Temporary Table

Does the ip address of where you are trying to access the mysql database from (client), change?If you have a dynamic ip address your ISP should have a grant something to the effect of: grant all on database.* to [EMAIL PROTECTED] identified by 'password'; This would allow your client to be

[PHP-DB] Newbie file reading into MySQL

G'day all This is probably a really basic question but I'm asking advice because I'm a real newbie and want to start off on the right foot. I'm trying to build a PHP/MySQL workflow tracking system in which each movement of an InDesign file generates a text file which contains the tracking data

[PHP-DB] Re: fatal error with DB.php - solution

OK, I solved it. It seems that I **HAVE TO**, **MUST**, **NO CHOICE** place my php.ini in C:\WINNT (for NT and 2k) or PHP will not find it. This is a hardcoded path done at compile time. So, since no ini file, PHP was running on default values, thus it could not find DB.php since the default

Re: [PHP-DB] php.ini

i found that even i have not the php.ini in my SYSTEMROOT, php can still run ... why? Sometimes they place it in C:\winnt\php.ini search for php.ini and it will show if there is a file and where it is. Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] php.ini

My understanding is the location PHP looks for the php.ini is dependant on the OS and what %SYSTEMROOT% is set to. This is what I have gleemed from my reading on this, as I had the same issue. walter Russell Griechen [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] i found that even

Re: [PHP-DB] Newbie file reading into MySQL

On Sunday 06 July 2003 19:04, Kim Kohen wrote: [snip] I'm trying to build a PHP/MySQL workflow tracking system in which each movement of an InDesign file generates a text file which contains the tracking data I want to move into the (MySQL) db. It will contain the operators name, a

[PHP-DB] Re: Create Temporary Table

The IP address CAN change, but doesn't change on such a basis that it would cause a problem. You see the issue also appears whether I am [EMAIL PROTECTED] or [EMAIL PROTECTED] it doesn't matter where I am coming from. Thx - Original Message - From: Stephen March [EMAIL PROTECTED] To:

Re: [PHP-DB] Newbie file reading into MySQL

G'day Jason Just one question: why are you storing text files containing DATA into a DB? Why not just store the data in the DB and do away with the text files? Thanks for the reply. I can see now my original wording was a bit unclear. I am, in fact, storing the data only - the text file

[PHP-DB] Re: PHP crashing with using Oracle

I had to change ext/oci8/config.m4 Remove the line highlighted in red on this page. http://cvs.php.net/diff.php/php-src/ext/oci8/config.m4?login=2r1=1.37.2.6r2=1.37.2.7ty=h The line is AC_DEFINE(HAVE_OCI8_SHARED_MODE,1,[ ]) Then do configure/make/make install again. That will get the oci8