Re: [PHP-DB] Advice for dataupload

2002-04-13 Thread Michael Andersson
<[EMAIL PROTECTED]> skrev i meddelandet news:[EMAIL PROTECTED]... Addressed to: "Michael Andersson" <[EMAIL PROTECTED]> [EMAIL PROTECTED] ** Reply to note from "Michael Andersson" <[EMAIL PROTECTED]> Fri, 12 Apr 2002 11:58:31 +0200 > > > "Jason Wong" <[EMAIL PROTECTED]> skrev i med

Re: [PHP-DB] Advice for dataupload

2002-04-13 Thread php3
Addressed to: "Michael Andersson" <[EMAIL PROTECTED]> [EMAIL PROTECTED] ** Reply to note from "Michael Andersson" <[EMAIL PROTECTED]> Fri, 12 Apr 2002 11:58:31 +0200 > > > "Jason Wong" <[EMAIL PROTECTED]> skrev i meddelandet > news:[EMAIL PROTECTED]... > > On Monday 08 April 2002 1

Re: [PHP-DB] Advice for dataupload

2002-04-12 Thread Michael Andersson
"Jason Wong" <[EMAIL PROTECTED]> skrev i meddelandet news:[EMAIL PROTECTED]... > On Monday 08 April 2002 19:15, Michael Andersson wrote: > > > What happens to a blob field with lets say a image when dumping a mysql > > table to a file? > > I don't use BLOB fields. You try it and let me know ;-)

Re: [PHP-DB] Advice for dataupload

2002-04-10 Thread Jason Wong
On Monday 08 April 2002 19:15, Michael Andersson wrote: > What happens to a blob field with lets say a image when dumping a mysql > table to a file? I don't use BLOB fields. You try it and let me know ;-) > > > 3) Install phpMyAdmin on both machines. > > How do i replicate 2 mysql db:s with php

Re: [PHP-DB] Advice for dataupload

2002-04-10 Thread Michael Andersson
"Jason Wong" <[EMAIL PROTECTED]> skrev i meddelandet news:[EMAIL PROTECTED]... > On Sunday 07 April 2002 17:08, Hayan Al Mamoun wrote: > > Dear all, > > I have two design-identical database, one on my intranet, the other on the > > internet, is there any procedure that Synchronizes the content of

Re: [PHP-DB] Advice for dataupload

2002-04-07 Thread Jason Wong
On Sunday 07 April 2002 17:08, Hayan Al Mamoun wrote: > Dear all, > I have two design-identical database, one on my intranet, the other on the > internet, is there any procedure that Synchronizes the content of two > databases? > I'm using PHP applications and MySQL Database, WindowsNT4 IIS You'v

[PHP-DB] Advice for dataupload

2002-04-07 Thread Hayan Al Mamoun
Dear all, I have two design-identical database, one on my intranet, the other on the internet, is there any procedure that Synchronizes the content of two databases? I'm using PHP applications and MySQL Database, WindowsNT4 IIS Please advice Best Regards Hayan -- PHP Database Mailing List (ht

[PHP-DB] Re: OT - [PHP-DB] Advice to PHP beginners

2002-03-27 Thread -BD-
ought until now)...? newbily yours... - Original Message - From: "Adam Royle" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 27, 2002 4:44 PM Subject: [PHP-DB] Advice to PHP beginners > Just some advice... You should use a consistent programmi

[PHP-DB] Advice to PHP beginners

2002-03-27 Thread Adam Royle
Just some advice... You should use a consistent programming style, especially with PHP. You can read some guys advice here. http://www.phpbuilder.com/columns/tim20010101.php3?page=1 Some of the advantages of having a consistent style, is when you are looking for bugs. If you look over your cod

Re: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-20 Thread JD Daniels
Thanks for the replies :) Victor's suggestion put me on the right track. (I still have trouble with language constructs) Heres what I have now.. All I need to do is name my form fields with the same name as the column names from the mysql table, and presto! now I can just add/remove from the sear

RE: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-20 Thread Jonathan Hilgeman
1800 AND ID=43"; Worked well for me. Jonathan Hilgeman -Original Message- From: JD Daniels [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 10:41 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Advice On Building Dynamic MySQL Queries I am building a query from a sear

Re: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-19 Thread Joe Brown
My solution was almost as elegent... $query="select * from customers"; $queryand=false; if(!empty($f_Account)) { $query.=" WHERE upper(P.Account) like upper('$f_Account')"; $queryand=true; } if(!empty($f_First_Name)) { $query.=($queryand?" AND ":" WHERE ")."upper(p.First_Nam

Re: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-19 Thread Victor Foitzik
Hello JD, on 19.04.2001 you wrote: > if (!empty($Price)) > { > if(empty($whereclause)) > { > $whereclause.="Price$Price"; > } > els

Re: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-19 Thread Victor Foitzik
Hello JD, on 19.04.2001 you wrote: > I am building a query from a search form. This is the code I have now: > if (!empty($whereclause)) > { > $whereclause=urldecode($whereclause); > $whereclause=stripslashes($whereclause); > } > extrac

[PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-19 Thread JD Daniels
I am building a query from a search form. This is the code I have now: if (!empty($whereclause)) { $whereclause=urldecode($whereclause); $whereclause=stripslashes($whereclause); } extract($HTTP_POST_VARS); if (!empty($

Re: [PHP-DB] advice

2001-02-20 Thread Beau Lebens
imp is really good, developed by the guys at horde http://www.horde.org/imp/ uses php and a mysql db. At 11:29 PM 2/20/01 -0800, Pedro M. S. Oliveira wrote: >i need to set up a web mail service. >i use pop, mysql, php and pearl. >does anyone knows a program that would do the trick? >i don't need

[PHP-DB] advice

2001-02-20 Thread Pedro M. S. Oliveira
i need to set up a web mail service. i use pop, mysql, php and pearl. does anyone knows a program that would do the trick? i don't need to develop this as i know that there are alot of packages that do this, but i would like to know if any of you as experience with this kind of software. thank you