Re: [PHP-DB] Update/Insert

2002-04-26 Thread Jason Wong
On Saturday 27 April 2002 01:34, Natividad Castro wrote: > Hi to all, > I have a form where users can insert or update a record. Now the way I have > it, can just only do one thing either update or insert a new record. What I > would like to do is: if it is a new record, execute the insert stateme

[PHP-DB] Re: selected problem

2002-04-26 Thread Hugh Bothwell
"Its Me" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > i have the file: > edit_profile.php Just curious: why do you have May 15th and October 6th listed as locations? "Choose City", "Abou Redes" => "Abou Redes", "Abou-Zabal" => "Abou-Zabal", "A

Re: [PHP-DB] Update/Insert

2002-04-26 Thread Chris
You could try inserting it, and see if it succeeds. If its fails, then you know you have to update it. IE $sql= 'insert...' $result = mysql_query($sql); if(!$result) { $sql = 'update...'; mysql_query($sql); } -Chris At 01:34 PM 4/26/2002 -0400, you wrote: >Hi to all, >I have a form where use

[PHP-DB] Update/Insert

2002-04-26 Thread Natividad Castro
Hi to all, I have a form where users can insert or update a record. Now the way I have it, can just only do one thing either update or insert a new record. What I would like to do is: if it is a new record, execute the insert statement else execute the update statement. I don't know if it is possi

Re: [PHP-DB] selected problem

2002-04-26 Thread Richard Emery
How is your option list created? Did you pull the names and values from a database? Or is the list hard-coded? - Original Message - From: its me <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 26, 2002 3:39 AM Subject: [PHP-DB] selected problem i have the file: edit_pr

Re: [PHP-DB] selected problem

2002-04-26 Thread szii
When you build the list up, originally, you'll NOT put "selected" on Choose City, but move it to "Alexandria." -Szii - Original Message - From: "its me" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 26, 2002 1:39 AM Subject: [PHP-DB] selected problem > i have the fil

Re: [PHP-DB] FORM not inserting data

2002-04-26 Thread szii
put in a "var_dump($sql);die();" right after $result = mysql_query($sql); Then copy/paste it into mysql's command line util, and see what you get. -Szii - Original Message - From: "Neil" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 6:34 PM Subject: [PHP

[PHP-DB] PHP + Oracle problem

2002-04-26 Thread Daniel Ryhle
When i have uncommented the php_oci8.dll extension in the php.in(i use the recommended) i get the following error. "kodPHP Warning: Unable to load dynamic library 'c:/php/php_oci8.dll' - The specified module could not be found. in Unknown on line 0 " All paths are correct and it works fine with

Re: [PHP-DB] selected problem

2002-04-26 Thread Paul Burney
on 4/26/02 4:39 AM, its me at [EMAIL PROTECTED] appended the following bits to my mbox: > in it i have a form field like this: > > Choose City value=10-Ramadan>10-Ramadan value="15 May">15 May value=6-October>6-October

[PHP-DB] Newbie and having to convert from idc/htx format

2002-04-26 Thread Robert Webb
Ok, I have been somewhat tasked here to try and do a web conversion from the idc/htx format of Microsoft to a more portable format. I am looking and using php for my scripting. My current scripts are very simple. Here is my setup. Microsoft IIS using idc/htx frontend MSSQL backend database All

RE: [PHP-DB] Sybase -> MSSQL Server 2000

2002-04-26 Thread Andrew Hill
Tom, I suggest you use ODBC or Free-TDS. For info on linking your PHP build against an ODBC Driver Manager (necessary to use ODBC) see the PHP-ODBC HOWTO at http://www.iodbc.org. Best regards, Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business

Re: [PHP-DB] Mssql/Sybase errors

2002-04-26 Thread Jeffrey_N_Dyke
No thats not it. I connected above this line. All of my errors come as Sybase errors because of the install of freeteds used with the --with-sybase=/path/to/freetds flag when i configure. It actually ended up being a spacing problem where i had concatenated the query string. there were two wor

Re: [PHP-DB] Couldn't Unsubscribe

2002-04-26 Thread Jason Wong
On Friday 26 April 2002 07:11, Ilhan Guvener wrote: > Yes it seems off-topic but I only joined to this mail-list. So I don't have > any other place to ask. I sent mail to unsubscribe me from the list but > nothing happened. I'm still recieving mails from the list. What's wrong? Did you read bit t

Re: [PHP-DB] Append into another table

2002-04-26 Thread Jason Wong
On Friday 26 April 2002 09:14, Rosen Marinov wrote: > Hi, > how can I append from one table to another with same structure some > selected records RTFM for the database you're using. If you still have problems, post to the database's list or to the php-db list. -- Jason Wong -> Gremlins Associ

Re: [PHP-DB] selected problem

2002-04-26 Thread Jason Wong
On Friday 26 April 2002 16:39, its me wrote: > i have the file: > edit_profile.php > > in it i have a form field like this: > >Choose City and i got from my database: > $location="Alexandria" > so i wanted to appear selected,how can i do this?? Mark it as selected like above.

[PHP-DB] selected problem

2002-04-26 Thread its me
i have the file: edit_profile.php in it i have a form field like this: Choose City 10-Ramadan 15 May 6-October Abou Redes Abou-Zabal Al Arish Al Mahala Al Tour Al-Natroun Alexandria Asuit Aswan Bader Bani-Sweif Belbis Berkeit sabb Cairo Dahab Damanhour Disouk Dumiat Ein Soukhna El