[PHP-DB] .htaccess

2001-09-18 Thread its me
where i can find info abour .htaccess and .htpasswd files and what should be the code inside them its urgent please guys -- PHP Database Mailing List

RE: [PHP-DB] .htaccess

2001-09-18 Thread Michael Yevdokimov
Hey man It's simple... .htaccess AuthName Authentication required AuthType Basic require user admin, mike, nick, bill AuthUserFile /path/to/password/file/.htpasswd file .htaccess should be located in the directory you want to protect .htpasswd this file consists of the logins and passwords

[PHP-DB] odbc_connect sometime fails

2001-09-18 Thread Philippe NONN
I developped a PHP application with multi-frame presentation. This application worked well under NT4/IIS/PHP4.0.2. Since I migrate it under W2000/IIS/PHP4.0.6/ODBC for MS-Access, I sometimes encounter problems while connecting to the database in one of the frame (odbc_connect). The error

Re: [PHP-DB] db's war

2001-09-18 Thread Tom Carter
Having worked in IBM and in Open Source community I feel I've know both systems very well. MySQL is different to the big boys of DB2 and Oracle. They are designed for enterprise level, and to handle a complexity and quantity of data which mysql just isn't there. The SQL used in mysql is vastly

[PHP-DB] Re: db's war

2001-09-18 Thread Steve Brett
i've used postgresql and mysql on linux platforms (mysql on windoze) and have been really suprised by mysql. i must admit thought that postgresql is far more complex and more powerful. although i haven't used db2 or oracle in anger i can certainly see postgres making gains in the near future ...

[PHP-DB] Help Please! Complex AND OR LIKE queries MySQL/PHP

2001-09-18 Thread Dave Watkinson
Hi everyone I need to write a small search script for our admin site (and eventually for the outsiders too!). There's a text box where the user types in what they're searching for. It's easy enough to parse their string into an array and create the query from it, for example user typed in

[PHP-DB] Sort HTML tables...

2001-09-18 Thread Gustavo Damy
Like to know if anybody has a script to sort data for a column over multiple tables with MySQL ? thanks on advance .. cordially.. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

RE: [PHP-DB] Help Please! Complex AND OR LIKE queries MySQL/PHP

2001-09-18 Thread Rick Emery
Just use PHP's string searching functions. I had a similar situation where I was inserting user-provided data into a MySQL database. I searched for MySQL bad words that I didn't want a hacker to insert into queries, such as DELETE, ADD, INSERT, MODIFY, etc. to prevent mischief. FYI, you can

RE: [PHP-DB] Help Please! Complex AND OR LIKE queries MySQL/PHP

2001-09-18 Thread Dave Watkinson
Cheers Rick ... I think I nailed it. I've copied my little function below for anyone else interested. Am keen on the saving milliseconds bit, though (will add it to the function below before making it live). Any more tips? Dave function parse($what) { $what =

[PHP-DB] MYSQL/PHP what is the difference between unset() and mysql_free_result() ? II

2001-09-18 Thread Bas Jobsen
unset() simply deletes the pointer to the data without releasing the space held by the data. mysql_free_result() releases the data storage pointed-to by the $result pointer. This is important because $result could be pointing-to a dataspace containing a large number or rows returned

Re: [PHP-DB] Sort HTML tables...

2001-09-18 Thread Justin Buist
Like to know if anybody has a script to sort data for a column over multiple tables with MySQL ? thanks on advance .. cordially.. Are you looking for the 'ORDER BY' clause? It's used something like: SELECT blah FROM blah WHERE blah = true ORDER BY column name here Justin Buist Trident

RE: [PHP-DB] problemhandling form variables

2001-09-18 Thread Rick Emery
When you printed the string $imgupload, what were its contents? -Original Message- From: Todd Moy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 12:40 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] problemhandling form variables I have an upload field on a form that is

[PHP-DB] Re: Application-based locking with PHP?

2001-09-18 Thread Heikki Tuuri
Hi! InnoDB type tables in MySQL provide row level locking and transactions. See http://www.innodb.com Regards, Heikki Tuuri Innobase Oy Barry L. Jeung wrote in message ... Just wondering if anyone has tried doing quasi application based locking with PHP? My scenario is this. I'm

[PHP-DB] php + MYSQL based banner exchange system

2001-09-18 Thread Andrius Jakutis
Hello all, I need your recomendations, where to download from a good (profesional - many options) banner exchange system (subj.). I need it for free (I understand that not everything what is free is also good :) ). Any ideas? Sorry, if my message is offtopic. Sincerely, Andrius -- PHP

RE: [PHP-DB] php + MYSQL based banner exchange system

2001-09-18 Thread Boaz Yahav
http://www.phpwizard.net/projects/phpAds/ Sincerely berber Visit http://www.weberdev.com Today!!! To see where PHP might take you tomorrow. -Original Message- From: Andrius Jakutis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 6:24 AM To: [EMAIL PROTECTED]

Re: [PHP-DB] db's war

2001-09-18 Thread Szii
IMHO, having run all three, I summarize them like this... MySQL, Postgres Fast, open source, free. Good for projects, small-medium sized businesses, and playing around. DB2 Good, solid database. Their UI needs work (it's 100% java-based) and it's significantly more complex (and

RE: [PHP-DB] db's war

2001-09-18 Thread Andrew Hill
You might want to also check out Virtuoso http://www.openlinksw.com/virtuoso/ It's as scalable ast the 'cadillacs' and has expected features like triggers, foreign keys, and stored procedure support, and is considerably cheaper. It also has advanced XML, SOAP, and WebDAV features - fun to work

Re: [PHP-DB] Cookies ???

2001-09-18 Thread Mark Collin
instead of setting multiple cookies, why not start using seassions its dead easy with php4 and you can then do all your security stuff with sessions, much easier, much more secure etc - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'Jason Caldwell' [EMAIL PROTECTED]; [EMAIL

[PHP-DB] MySQL alphabetical listing

2001-09-18 Thread Photocon
Heya all... I have a listing of last names in a table. I would like to get MySQL to give me a result set of last names that began with a letter so that in PHP I can put them into alpha order. I don't want a set of all names, just those with one letter (the idea being I can then have one

[PHP-DB] Exporting Access - MySQL with a macro

2001-09-18 Thread Jonathan Hilgeman
I've set up a MySQL datasource on a Windows machine and it works - I have tested it. I want to export a table from Access to the datasource, and I have been able to do it manually. HOWEVER, NOW I am trying to do the same thing except via a macro, and Access is giving me trouble. It keep saying