Re: [PHP-DB] PHP use in Federal Govt

2004-07-17 Thread Robert Twitty
Hi Mark The US Holocaust Memorial Museum (Department of Interior) primarily uses PHP for web application development. The reason is because the main web server is Apache on Solaris. IMHO, if you are using Apache on Linux/UNIX, then PHP is probably your best choice. If you are using IIS on Window

Re: [PHP-DB] Rewrite value from form data

2004-07-17 Thread Justin Patrin
Somnething like this? //remove all non-digits $home = preg_replace('/[^\d]/', '', $_POST['home_phone']); //if it's 10 digits if(preg_match('/\d{10}/')) { $home = preg_replace('/(\d{3})(\d{3})(\d{4})/', '\1-\2-\3', $home); } On Sat, 17 Jul 2004 12:44:46 -0400, Vincent Jordan <[EMAIL PROTECTED]> w

Re: [PHP-DB] Re: Postgres Issues

2004-07-17 Thread Jake Stride
My apologies, I am under the weather today and it was not my intention to misquote you. The problem was quite easy to fix in the end, the size of the array of values was not the same as the query was expecting, so it was a bug that I had introduced. Thanks Jake On 17/7/04 5:18 pm, "John Lim" <

[PHP-DB] Scripts waiting..

2004-07-17 Thread kylix
Hi, I need some help.. Is ant functions in PHP which allow to execute part of script (with output, because sleep() is useless in my case) then waits some seconds and finishing all script and also show output ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.p

[PHP-DB] Rewrite value from form data

2004-07-17 Thread Vincent Jordan
I have a form with a field for a telephone number. I would like to either apply some kind of formatting to force format of XXX-XXX- or rewrite after submit to insert - in 3 and 5 (or 6). Here is what I have for code: --Form- Home Phone: handler.php $home = $_POST['home_phone' I hav

[PHP-DB] Re: Postgres Issues

2004-07-17 Thread John Lim
Jake, I said it was a postgresql problem. Please don't misquote me. http://phplens.com/lens/lensforum/msgs.php?id=10131 "Jake Stride" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I am having some problems with postgresql/adodb. I keep getting the > following error with some of m

Re: [PHP-DB] Help. Mysql Query optimisation not very clever?

2004-07-17 Thread Pablo M. Rivas
Hello Ross, why don't use: explain select . and you'll see what mysql is "thinking"... ;) -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Database design for calendar

2004-07-17 Thread Rui Cunha
Hi Arnout, i'd choose your first suggestion. Using the calendar table (you can use the date field as Primary Key) and the other tables (birthdays,testpapers,) where you could use the date field as Foreign Key. With simple 1-N relationships you can solve the prob. hope it helps. Rui Cun