[PHP-DB] postgres transaction php trigger rollback

2002-04-26 Thread Igor Kryltsov
Hi, 1. User clicks edit_record.php page 2. Page starts transaction and SELECT FOR UPDATE (say this is PostgreSQL) 3. User instead of clicking Submit/Reset buttons goes to www.boyplay.com 4. Other users can not edit this record because it was locked. If somebody can give me an idea how to

[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: select name=location OPTION selected value=Choose City/OPTION OPTION value=10-Ramadan10-Ramadan/OPTION OPTION value=15 May15 May/OPTION OPTION

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: select name=location OPTION selected value=Choose City/OPTION OPTION and i got from my database: $location=Alexandria so i wanted to appear selected,how can

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

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 the

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

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

[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

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: select name=location OPTION selected value=Choose City/OPTION OPTION value=10-Ramadan10-Ramadan/OPTION OPTION

[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] 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-DB]

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 file:

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:

[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

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

[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? ?php if (!isset($location)) $location = ; $locations[] = array( = Choose City,

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 statement