Re: [PHP-DB] Query's

2003-09-30 Thread Nitin
What you'll have to do is, first show those drop down menus and then call your php script, c the attachment for exact help. Enjoy Nitin - Original Message - From: Andrew R [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 3:31 AM Subject: [PHP-DB] Query's

Re: [PHP-DB] how to select rows with repeated coloumns in one query????

2003-09-30 Thread Nitin
with Mysql 4.0 and above, u can use subqueries, so that u can put first query in the where clause of second query itself. Nitin - Original Message - From: Saurabh Dhawan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 11:26 AM Subject: [PHP-DB] how to select

Re: [PHP-DB] Query's

2003-09-30 Thread Nitin
HTML File html body form action=/some/path/script.php3 Select genre: select name=genre option value=genre1Genre 1/option --- - -- /select select name=style option value=likeLike/option option value=EqualExact/option /select /form /body/html PHP Script: ?php

Re: [PHP-DB] Email bouncer Program(s) - know any?

2003-09-30 Thread David T-G
Jerry -- This is neither a PHP nor PHP-DB question, even though you use php and mysql, but here's a reply anyway. ...and then JeRRy said... % % Hi, Hi! % % I run PHP and mysql on my site. I allow people to use % a PHP page to send me an email that is logged in the % mysql for logging

[PHP-DB] Calculating time unused

2003-09-30 Thread Shaun
Hi, I have a table called Bookings which has two important columns; Booking_Start_Time and Booking_End_Time. These columns are both of type DATETIME. Given any day how can I calculate how many hours are available between the hours of 09.00 and 17.30 so a user can see at a glance how many hours

Re: [PHP-DB] fopen : Supplied argument is not a valid File-Handle resource

2003-09-30 Thread Ferdian
How about putting in some error checking code as per example in manual? Hi Jason, The error was on : $ns = fsockopen($com_server,43); fputs($ns,$domname\r\n); Any solutions ? Kind Regards, Ferdian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] fopen : Supplied argument is not a valid File-Handle resource

2003-09-30 Thread Jason Wong
On Tuesday 30 September 2003 18:35, Ferdian wrote: How about putting in some error checking code as per example in manual? The error was on : $ns = fsockopen($com_server,43); fputs($ns,$domname\r\n); That is *where* the error occurred. But *what* is the error? Again, refer to examples in

[PHP-DB] ereg_replace

2003-09-30 Thread Dillon, John
strip_tags() is used to remove HTML tags, eg for showing text on the browser and then sending it by plain text email or storing in the db. As a matter of interest, how is this done using ereg_replace. I thought this would work ^.*$, that is being with and any number of single characters ending

[PHP-DB] Excel file into MySQL

2003-09-30 Thread Jonathan Villa
Is it possible to transfer information from an excel file (33,000 rows) into MySQL using phpMyAdmin or MySQL CC? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] ereg_replace

2003-09-30 Thread CPT John W. Holmes
From: Dillon, John [EMAIL PROTECTED] strip_tags() is used to remove HTML tags, eg for showing text on the browser and then sending it by plain text email or storing in the db. As a matter of interest, how is this done using ereg_replace. I thought this would work ^.*$, that is being with

Re: [PHP-DB] Email bouncer Program(s) - know any?

2003-09-30 Thread JeRRy
Note that even that isn't really very good because each domains is supposed to have a working postmaster@ account where any problem reports for the domain can go. If you just bounce any mail from the outside then you're not playing nice with the rest of the world. Just because other web

[PHP-DB] Replacing + with question

2003-09-30 Thread Graeme McLaren
Hi all I want the contents of a variable to be returned to the user without the + symbols, how do I do that? This is what I have so far by the string replace function doesn't replace the spaces and display bla bla bla as I want: $AddressLine1 = urlencode($AddressLine1); $AddressLine1 =

RE: [PHP-DB] odbc

2003-09-30 Thread Simpson, Doug
I solved my problem (here). IBM came out with new drivers and they sovled the problem. THanks -Original Message- From: Simpson, Doug Sent: Monday, September 29, 2003 11:38 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] odbc I am trying to connect to an AS/400 from a Linux box running RH9.

[PHP-DB] HELP-PHP install

2003-09-30 Thread Balazs Nemeth
Hi all! I'm Balazs from Hungary and I'd like to ask for your help! I want to start making progams in PHP but my browser doesn't accepts the code. I write the way of the installation. I hope somebdy will notice what the problem is.(apache-1.3.28. and php-4.3.3. and Debian) cd /apache gunzip

Re: [PHP-DB] Replacing + with question

2003-09-30 Thread Jason Wong
On Wednesday 01 October 2003 01:06, Graeme McLaren wrote: This is what I have so far by the string replace function doesn't replace the spaces and display bla bla bla as I want: Probably it's because you're trying to replace spaces with +. Swap your first 2 parameters. $AddressLine1 =

Re: [PHP-DB] HELP-PHP install

2003-09-30 Thread Jason Wong
On Wednesday 01 October 2003 01:39, Balazs Nemeth wrote: cd /apache/apache-xxx ./configure --prefix=/www cd /php/php-xxx ./configure --with-mysql --with-apache=/apache/apache-xxx --enable-track-vars make make install cd /apache/apache-xxx ./configure

Re: [PHP-DB] Excel file into MySQL

2003-09-30 Thread Jonathan Villa
On Tue, 2003-09-30 at 10:31, Jonathan Villa wrote: Is it possible to transfer information from an excel file (33,000 rows) into MySQL using phpMyAdmin or MySQL CC? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Excel file into MySQL

2003-09-30 Thread Jason Wong
On Wednesday 01 October 2003 02:23, Jonathan Villa wrote: On Tue, 2003-09-30 at 10:31, Jonathan Villa wrote: Is it possible to transfer information from an excel file (33,000 rows) into MySQL using phpMyAdmin or MySQL CC? Be patient! In the meantime how about reading the manuals/feature

Re: [PHP-DB] Excel file into MySQL

2003-09-30 Thread Jonathan Villa
right... I was just looking for a quick answer without having to look for it myself... (I tend to be a little self-centered sometimes, sorry) On Tue, 2003-09-30 at 13:29, Jason Wong wrote: On Wednesday 01 October 2003 02:23, Jonathan Villa wrote: On Tue, 2003-09-30 at 10:31, Jonathan Villa

Re: [PHP-DB] Replacing + with question

2003-09-30 Thread Graeme McLaren
Jason, thank you for reply. I tried switching the 1st 2 parameters in the str_replace function so that it now looks like this: $AddressLine1 = urlencode($AddressLine1); $AddressLine1 = str_replace(+, , $AddressLine1); Unfortunately as I am now replacing the + symbols with a space only the

Re: [PHP-DB] Replacing + with question

2003-09-30 Thread CPT John W. Holmes
From: Graeme McLaren [EMAIL PROTECTED] Jason, thank you for reply. I tried switching the 1st 2 parameters in the str_replace function so that it now looks like this: $AddressLine1 = urlencode($AddressLine1); $AddressLine1 = str_replace(+, , $AddressLine1); Unfortunately as I am now

Re: [PHP-DB] how to select rows with repeated coloumns in one query????

2003-09-30 Thread Jeff Shapiro
Actually, it's MySQL 4.1 and above that supports subselects. On Tue, 30 Sep 2003 12:24:51 +0530, Nitin spoke thusly about Re: [PHP-DB] how to select rows with repeated coloumns in one query: with Mysql 4.0 and above, u can use subqueries, so that u can put first query in the where clause

[PHP-DB] Re: Calculating time unused

2003-09-30 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi, I have a table called Bookings which has two important columns; Booking_Start_Time and Booking_End_Time. These columns are both of type DATETIME. Given any day how can I calculate how many hours are available between the hours of