[PHP-DB] Access db

Hi everyone Can PHP access an access database residing on a unix / linux box? I know theres and ODBC extension but is that only for windows? Regards Luke -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Optimal mySQL query for next prev page system

Thanks for the replies. Its time for me to start do some patching for my SQL statement, :) -- Kim Steinhaug --- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't.

Re: [PHP-DB] Query Case In-sensitive

Use LIKE clause instead of = SELECT item_number FROM item WHERE item_code LIKE 'M1234' ; This will perform case-insensitive matching on all databases I used before (Including Oracle, MySQL, SQL-Server) - Original Message - From: ramki [EMAIL PROTECTED] To: [EMAIL PROTECTED];

[PHP-DB] works on production server but not on localhost

hey guys.. just getting back in to using a little php. have 2 simple hit counters that work fine on the production server. but on my localhost it throughs several errors. looks like a permissions thing? i am not sure if there is a setting in my php.ini file that needs to be tweaked. kind of

Re: [PHP-DB] works on production server but not on localhost

You are probably right, it looks like a permission problem. What is the OS (win, Linux) of your machine? It's not about PHP.INI, If your operating system is Windows give write permission to the directory these text files reside. You can do it by using Internet Services Manager If it is a unix

Re: [PHP-DB] Query Case In-sensitive

As an Oracle DBA (9+ years, versions 7.x - 9.x) I just wanted to make a correction. The LIKE command uses wild card characters ( _ and % ) for substitutions. Oracle IS a case-sensitive RDBMS and the LIKE command will NOT do case-insensitive queries. Roy A. Jones US Pharma Database

RE: [PHP-DB] works on production server but not on localhost

ok... im on xp running iis win i tried to figure out how to change permissions on files did a few example but it never seemed to work. is there a free chmod tool? or a simple way to do it in windows? again, i am sure i sound noob, and am... thanks for the response. -paul -Original

Re: [PHP-DB] works on production server but not on localhost

Settings - Control Panel - Administrative Tools -Internet Services Manager Click the Default Web Site on the list, directories will be shown Right click the directory the files reside and Select Properties You can give write permission to the directory here. HTH Mustafa - Original

Re: [PHP-DB] Query Case In-sensitive

Yes you are right, I have tried the queries on Oracle and MySQL, it works right on MySQL (case insensitive) but not on Oracle. Thank you for the correction. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Wednesday, November

RE: [PHP-DB] works on production server but not on localhost

already tried that read write execute scripts. no go -Original Message- From: mustafa ocak [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 7:54 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] works on production server but not on localhost Settings - Control Panel -

Re: [PHP-DB] works on production server but not on localhost

Try setting security settings on directory itself eg full control for IUSR_.. to do this right click on directory -propertys- security add a user IUSR_... and give full access Works fine for me Jochem Paul Ihrig wrote: already tried that read write execute scripts. no go -Original

RE: [PHP-DB] works on production server but not on localhost

i don't have a security tab under properties when just browsing the directory. i only get a Directory Security tab when i am in the Internet Information Services there i have Anonymous access checked User name IUSR_BAlgh pass * Allow IIS to control password checked also Integrated Windows

Re: [PHP-DB] works on production server but not on localhost

Do you have NTFS of FAT32 as filesystem?? If NTFS you can set permissions in directories or files if FAT32 you can not. Jochem Paul Ihrig wrote: i don't have a security tab under properties when just browsing the directory. i only get a Directory Security tab when i am in the Internet Information

Re: [PHP-DB] works on production server but not on localhost

Try setting permissions on counterlog.txt itself inside IIS and and on the file itself Jochem Paul Ihrig wrote: i don't have a security tab under properties when just browsing the directory. i only get a Directory Security tab when i am in the Internet Information Services there i have

RE: [PHP-DB] works on production server but not on localhost

it's ntfs -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] works on production server but not on localhost

if it is ntfs you should have a security tab if you right click in the file counterlog.txt . If not the you should login as administrator. then set full controll to counterlog.txt for IUSR_... Jochem Paul Ihrig wrote: it's ntfs -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] Current page url

is there any way to determine the url of the current page. The idea is to make a generic 'quickpoll' which posts to the page from which it was activated Regards Hugh Dickinson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Current page url

$_SERVER['PHP_SELF'] http://ca.php.net/reserved.variables There are many others you could use as well. HTH Aaron -Original Message- From: Hugh Dickinson [mailto:[EMAIL PROTECTED] Sent: November 19, 2003 7:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Current page url is there

RE: [PHP-DB] works on production server but not on localhost :: fix

how weird is this just had to uncheck allow anonymous access. and keep checked Integrated Windows authentication just seems a bit silly... every thing works fine now. thanks for the help! will have better questions for you all in a day or so... -paul -- PHP Database Mailing List

Re: [PHP-DB] works on production server but not on localhost :: fix

From: Paul Ihrig [EMAIL PROTECTED] how weird is this just had to uncheck allow anonymous access. and keep checked Integrated Windows authentication just seems a bit silly... every thing works fine now. Of course it works because you're now running the PHP scripts as yourself, and you

[PHP-DB] informix error

Hi, I was wondering if anyone has seen this informix error before. It has me stumped. Searching on google didn't reveal anything. Running my query in informix returns the proper results, so I'm not sure what the problem is. Warning: ifx_fetch_row(): 4 is not a valid Informix Result resource

Re: [PHP-DB] informix error

this is usually based on what your passing this function. it can be a result of a bad query or just a bad variable. do you have the correct variable that is holding a result of an ifx_query() call. if you could post the prior lines of this that would probably make it clearer. also try

Re: [PHP-DB] Access db

To the best of my knowledge you cannot access an Access database directly from UNIX or Linux. The reason is because the Jet Engine has not been ported to those platforms. Your only options may be something like EasySoft's ODBC-ODBC bridge or ODBTP. -- bob On Wed, 19 Nov 2003, Luke van Blerk

RE: [PHP-DB] Access db

Thanks Robert I'll probably just extract the data with an access to mysql script and run it on mysql. - Luke Robert Twitty wrote: To the best of my knowledge you cannot access an Access database directly from UNIX or Linux. The reason is because the Jet Engine has not been ported to those

Re: [PHP-DB] Read file

It's usually easier to show with an example : This took about 30 minutes to write : Here's an XML file - copy and paste, and save as hotels.xml : ?xml version=1.0? hotels hotel id1/id nameBangkok oriental/name address50 High Street,