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

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
I actually created an array of different conditions like: $ConditionsArray = array("Var1 > 500","Var2 < 1800","ID=43"); and then: $Conditions = join(" AND ", $ConditionsArray); This constructs: $Conditions = "Var1 > 500 AND Var2 < 1800 AND ID=43"; Worked well for me. Jonathan Hilgeman -O

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

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