[PHP-DB] is LIKE operator case sensitive ???

2002-08-20 Thread Smita Manohar
im using query SELECT * FROM table WHERE field LIKE '% $variable %' with this, i want it should not be case sensitive, and should not distinguish betn ram,Ram,RAM. but its not doing so. i don't want the case sensitive result. what can i do to overcome this ? pls suggest any other possible

[PHP-DB] Multi-table update question

2002-08-20 Thread Markus Lervik
Hello all, How do you people solve the problem of multi-table updates? Consider the following scenario: You got a php-program that has, say, ten fields. You got your database that has it's data normalized (as the good database designers we all are *grin*) and split up over, say, four tables.

[PHP-DB] SQL guru needed!

2002-08-20 Thread Russ
Hiya folks: I wish to be able to select items from MySQL if a variable passed via the $_GET method to my PHP4 page is introduced thus: $sql = SELECT TourName,TourID,$_GET[CatID] IN (TourCatID) FROM tour; When I echo $sql to the page, the query looks fine but doesn't work, in as far as the

[PHP-DB] securing directory tree and allowing PHP to work

2002-08-20 Thread bmw
I am trying to find out how I can secure the directory tree of my PHP scripts from the HTTP server without preventing access to my PHP scripts once in session. Right now, if I type the URL of a subdirectory of my site, I get the index of all the files and directories. Ex:

[PHP-DB] Re: securing directory tree and allowing PHP to work

2002-08-20 Thread bmw
Bmw [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am trying to find out how I can secure the directory tree of my PHP scripts from the HTTP server without preventing access to my PHP scripts once in session. Right now, if I type the URL of a subdirectory of

[PHP-DB] Re: weird MySQL restart

2002-08-20 Thread Joni Järvinen
for ($i=0; $i = $brute_queries_max; $i++) { HTH -Joni- Florin Andrei [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'm using: - apache-1.3.22 - mysql-3.23.49a - php-4.0.6 - Linux Red Hat 7.2 I have a piece of code that does this: for ($i=0; $i

RE: [PHP-DB] SQL guru needed!

2002-08-20 Thread Russ
Cheers for helping me out guys. It proved to fiddly and kludge-like to do what I wanted in SQL (I'll wait until MySQL 4 stable version is about) So I did some stuff with PHP arrays which worked fine. Thanks a lot anyway. Russ -Original Message- From: Ignatius Reilly [mailto:[EMAIL

[PHP-DB] Odp: is LIKE operator case sensitive ???

2002-08-20 Thread Krzysztof Socki
im using query SELECT * FROM table WHERE field LIKE '% $variable %' with this, i want it should not be case sensitive, and should not distinguish betn ram,Ram,RAM. but its not doing so. i don't want the case sensitive result. You can do it in this way: SELECT * FROM table WHERE

Re: [PHP-DB] Re: securing directory tree and allowing PHP to work

2002-08-20 Thread Jason Wong
On Tuesday 20 August 2002 16:30, bmw wrote: Bmw [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am trying to find out how I can secure the directory tree of my PHP scripts from the HTTP server without preventing access to my PHP scripts once in session.

Re: [PHP-DB] Re: securing directory tree and allowing PHP to work

2002-08-20 Thread Jeffrey_N_Dyke
If you are running Apache and have access to the httpd.conf file. Comment out AddModule mod_autoindex.c and restart apache. if you like this for some of your directories, then I'd follow Jason's advice. If you are using IIS or another server, I'm sure the same option is available, but I'm

[PHP-DB] RE: PHP, using System account

2002-08-20 Thread Ryan Jameson (USA)
That's what I'm doing. Since we require IE 5.0 + on our workstations I can get away with Integrated Authentication only. If you want to support Netscape you'll have to allow Basic Authentication (which is not very secure but fine on an intranet). With that enabled the Win2k workstation will

[PHP-DB] what's wrong with this ereg?

2002-08-20 Thread chip . wiegand
I am trying an email verification function, like this: if (empty($useremail)) || !eregi(^[A-Za-z0-9\_-]+@[A-Za-z0-9\_-] +.[A-Za-z0-9\_-]+.*, $email)) { $errmsg .= The email address appears to be invalid\n; } But it will not work, on one server I get this

Re: [PHP-DB] Windows XP

2002-08-20 Thread Gerard Samuel
Just a note for others who went through what I did, and a note of thanks. Regranting and flushing privileges, make everything run smooth for me. :) Joni Järvinen wrote: Hi. Try re-GRANTing the rights for user 'crash' and after you've done that, run 'flush PRIVILIGES'. Atleast on my winxp box

Re: [PHP-DB] what's wrong with this ereg?

2002-08-20 Thread Steve Cayford
Well, one thing is you've got mismatched parentheses. You need another another opening paren right after the if. Also, don't you need to escape the last hyphen in your character sets? As well as the . before the third character set? -Steve On Tuesday, August 20, 2002, at 11:11 AM, [EMAIL

Re: [PHP-DB] what's wrong with this ereg?

2002-08-20 Thread chip . wiegand
Steve Cayford [EMAIL PROTECTED] wrote on 08/20/2002 10:28:46 AM: Well, one thing is you've got mismatched parentheses. You need another another opening paren right after the if. Also, don't you need to escape the last hyphen in your character sets? As well as the . before the third

[PHP-DB] keeping form field data when reloading a form

2002-08-20 Thread chip . wiegand
I have my email checker working now, and all the other fields are checked also, but when I do enter some wrong data the form is reloaded with all blank fields. I'm sure there is a way to keep the existing data in the fields so the end-user will only have to change the incorrect fields, and not

[PHP-DB] sybase issue

2002-08-20 Thread Ronald Corsico
We have installed PHP 4.2.2 in a Solaris 2.6, with Netscape Enterprise Server 3.5.1 and Sybase SQL Server/11.0.3.3. We compiled PHP with following options, and it was successful completed with no errors. ./configure --with-nsapi=/opt/netscape/suitespot --enable-track-vars --enable-libgcc

[PHP-DB] mssql_init using freetds

2002-08-20 Thread Benjamin Walling
I've installed freetds 0.53, php 4.2.2 and apache 1.3.26. I have some of the mssql functions working (mssql_connect(), for example). I cannot get mssql_init() to work - I get Fatal error: Call to undefined function: mssql_init() in /var/www/html/stdFunctions.php on line 128 I saw a previous

Re: [PHP-DB] Multi-table update question

2002-08-20 Thread Court Shrock
If you use MySQL, instead of INSERT, do a REPLACE--they use the same syntax. Read about it here: http://www.mysql.com/doc/en/REPLACE.html On Tue, 2002-05-21 at 00:32, Markus Lervik wrote: Hello all, How do you people solve the problem of multi-table updates? Consider the following

RE: [PHP-DB] securing directory tree and allowing PHP to work

2002-08-20 Thread Gary . Every
Look into the PHP_AUTH_USER variable. It is assigned through basic authentication. Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: bmw [mailto:[EMAIL PROTECTED]] Sent:

Re: [PHP-DB] Re: securing directory tree and allowing PHP to work

2002-08-20 Thread leo g. divinagracia iii
bmw wrote: You could restrict autoindexing through apache's httpd.conf. Look it up in apache's manual. Milan This is not my personal web server. It is a remote ISP which provides PHP and MySQL support. I cannot control the HTTP or PHP server build

[PHP-DB] Database question

2002-08-20 Thread Shiloh Madsen
I was wondering if there were any good documents out there about good database design...I know the basics of creating tables, setting data types and such, and now i want to know how to use it to the best effect...generating logical, streamlined tables, etc. As a side-related note, i have a

Re: [PHP-DB] weird MySQL restart

2002-08-20 Thread Florin Andrei
Ok, the restart of the loop happens after 300 seconds no matter what. Seems to be a timeout, but then why i don't get an error instead of the loop starting all over again? And i don't see anything in php.ini that could be related to that. I upgraded to php-4.1.2 and the problem is still there.

Re: [PHP-DB] keeping form field data when reloading a form

2002-08-20 Thread Stuart McDonald
Are you setting the variables in the form? Something like this - note the value field in the username field: form method=post action=index.php name=loginuser table summary=layout table to hold login data width=300 align=center cellpadding=1 cellspacing=0 border=0 bgcolor=#ff tr td

Re: [PHP-DB] Database question

2002-08-20 Thread leo g. divinagracia iii
Shiloh Madsen wrote: I was wondering if there were any good documents out there about good database design...I know the basics of creating tables, setting data types and such, and now i want to know how to use it to the best effect...generating logical, streamlined tables, etc. have you got

Re: [PHP-DB] Database question

2002-08-20 Thread Jason Wong
On Wednesday 21 August 2002 09:15, leo g. divinagracia iii wrote: you can use either TEXT, MEDIUMTEXT or LONGTEXT. 64K, 16 million and 4 billion bytes, respectively... the downside is the space taken up when the actual data is less than the field size. The actual space taken up is only a

RE: [PHP-DB] keeping form field data when reloading a form

2002-08-20 Thread Russ
Chip: Just use the names of the fields as the values too: input type='text' name='Email' value='$Email' / HTH :-) Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 1:58 AM To: PHP_DB Subject: [PHP-DB] keeping form field data