Search results for query: *

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?

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...

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

Thanks for the response. I am now reading up on the art of database privilages.

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 =...

My thanks to Tony and all other contributors.

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))

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)...

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.

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...

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

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

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...