[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 ho

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

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); > > > > Unfortunate

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 " " onl

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] 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
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] 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 --activate-module=src/modules

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 = url

[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 < a

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] 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 = str_replac

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 se

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 bein

[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

[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 endin

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

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: http://www.php.

[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 the

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 reason

Re: [PHP-DB] Query's

2003-09-30 Thread Nitin
HTML File Select genre: Genre 1 --- - -- Like Exact PHP Script: - Original Message - From: "Nitin" <[EMAIL PROTECTED]> To: "Andrew R" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, September 30, 2003 12:21 PM Subject: Re: [PHP-DB] Qu