Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Include local libraries?
I need to use a zip function that does not appear to be available from my host' remote server. Is it possible to to install the zip library locally and include a link to this in my php scripts? -
Load data infile error
Having read the documentation I agree that it sounds like a file privilage problem. If I am using my ISP's server, can I change my own privilages or do I have to get them to do it for me? I have tried this using the following grant all on *.* to user@host identified by 'password' but got an... -
Zip File Archive fatal error
I am using php version 4.1.2 and get a Fatal error: Call to undefined function: zip_open() in.... when I run this code. <?php $zip = zip_open("price.zip"); ..... I thought that Zip File Archive was ncluded (PHP 4 >= 4.1.0) Any ideas? Thanks -
Load data infile error
Thanks for the response. I am now reading up on the art of database privilages. -
Load data infile error
When I enter 'LOAD DATA INFILE 'imptest.txt' INTO TABLE imptest' directly into phpmyadmin I get the following error Access denied for user: 'me@localhost' (Using password: YES) Yet when I use the following php code, it opens the same file without any problem. $url = '../../imptest.txt'; $fp =... -
-
Multiple Update
Tony Thanks for the tip. Just to clarify, the following update does work on version 4.0.13? UPDATE t2, t1 SET t2.price = t1.price WHERE t1.item_code=t2.item_code AND (((t1.selected)= 1)) -
Multiple Update
SELECT VERSION() returns 3.23.49 - log. Ancient. If anybody has got access to a version 4.0.4 mybe they could verify that the following does actually work, just so that we can establish a working version. CREATE TABLE t1( t1_id int(3) DEFAULT '0' NOT NULL auto_increment, item_code int(3)... -
Multiple Update
Tony I am using my isp's remote server and I have emailed them for the version no. Can you request this info from the server? I am new to mysql. Thanks. -
Multiple Update
If these examples don't work, has anybody else got examples of code that does work relating to the multiple update? I don't understand why there seems to be such a problem with what other database systems do without effort ie Access. It would be good to have a working example for everybody... -
Multiple Update
Get this error message when I run the first query; You have an error in your SQL syntax near ' t1 SET t2.price = t1.price WHERE t1.item_code=t2.item_code -
Multiple Update
Thanks for the response. I just get this error message; You have an error in your SQL syntax near 'INNER JOIN t1 ON t1.item_code=t2.item_code SET t2.price = t1.price -
Multiple Update
Hi all I have two simple tables t1 and t2. I want to update the price field in t2 with the values of the (selected) price field in t1. I have followed other threads regarding similar problems and have worked out that these two attempts should work. Alas, they don't. Anybody any ideas? Thanks...
