FRe[2]: [PHP-DB] MySQL Regular expression

2003-10-10 Thread Rory McKinley
HI Owen I am not sure about strcmp - I have never used it on numbers before..MySQL 2nd Ed by DuBois PLUG Which is well worth the money - makes me look intelligent /PLUG says that strcmp sorts lexically...and to be quite honest, I need to go look that up.. but I think it will work...

[PHP-DB] Need help Get/send Variabel to another window

2003-10-10 Thread agus supriatna
Dear all I have two page one as main and secon as child, now I have problem how to send variable/data to main page from child thanks in advance asupna -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Interbase and PHP- SHOW TABLE sql command

2003-10-10 Thread George Georgeus
Hello, I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command SHOW TABLE; in the php function ibase_query(); I got Dynamic SQL Error SQL error code = -104 Token unknown - line 1, Select commands work well but this not. SHOW TABLE is a regular

Re: [PHP-DB] Interbase and PHP- SHOW TABLE sql command

2003-10-10 Thread George Patterson
I haven't used Interbase but could it be show tables;. Just a thought... On Fri, 10 Oct 2003 09:34:49 +0100 (BST) George Georgeus [EMAIL PROTECTED] wrote: Hello, I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command SHOW TABLE; in the php

[PHP-DB] textarea with multiple rows and mysql insert

2003-10-10 Thread Jason End
I have a form that includes two text areas that span multiple rows. The first textarea (rows=2, cols=50) is used to insert a pretty long url, while the second (rows=5, cols=50) is used for inserting free text (comments). When I process the form to create the mysql insert statement, the values

[PHP-DB] Informix 9.20 ifx_query SQLCODE=-410

2003-10-10 Thread Tomá¹ Tominec
Hi, I have Informix 9.2 on Solaris and IIS on XP professional. when I run SQL statement, $conn_id = ifx_connect ([EMAIL PROTECTED], name, pwd); $qry = SELECT a,b FROM c ; if (! $conn_id) { printf(Cannot connect to the DB SERVER.); } $res = ifx_query($qry,$conn_id); I will get error:

Re: FRe[2]: [PHP-DB] MySQL Regular expression

2003-10-10 Thread O Franssen
Thanks very much for your help Rory. :) -- Regards, Owen Franssen Twisted Designmailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] [PEAR Newbie] PEAR problems

2003-10-10 Thread David Russell
Hi all, I have been developing in PHP/Interbase for about 2 years, and have just started a new PHP aplication. I wanted to use PEAR's DB abstraction, but am running into (big) problems. I am sure I am doing something really stupid, but let's try anyway External .inc.php file containing the

[PHP-DB] Re: Interbase and PHP- SHOW TABLE sql command

2003-10-10 Thread David Russell
Hi George, Send me more information about the Select statement you are using, and I can look at it. Also, more info about version (interbase/firebird, PHP, server) could help. Cheers David R -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: [PEAR Newbie] PEAR problems

2003-10-10 Thread pete M
Not user but I think the DB oject is not referenced because of function try the following to see if it works (not tested just a hunch) require_once(DB.php); $dbname=c:\www\support\database\support.gdb; $dbuser=SYSDBA; $dbpass=masterkey; $dbhost=localhost;

Re: [PHP-DB] mysql_error() (was Re: Getting last insert id?)

2003-10-10 Thread Ben Edwards
On Thu, 2003-10-09 at 17:35, pete M wrote: http://www.php.net/manual/en/function.mysql-error.php Ben Edwards wrote: On Thu, 2003-10-09 at 16:33, pete M wrote: $new_id = mysql_query('select last_insert_id()'); your can also user it within a query - eg $sql = ' insert into related

Re: [PHP-DB] Interbase and PHP- SHOW TABLE sql command

2003-10-10 Thread Alexey Trunyov
George Georgeus wrote: Hello, I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command SHOW TABLE; in the php function ibase_query(); I got Dynamic SQL Error SQL error code = -104 Token unknown - line 1, Select commands work well but this not.

Re: [PHP-DB] Interbase and PHP- SHOW TABLE sql command

2003-10-10 Thread George Georgeus
Thank very much for your help. :o) That's what I need. Ge0rge --- Alexey Trunyov [EMAIL PROTECTED] wrote: George Georgeus wrote: Hello, I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command SHOW TABLE; in the php function

[PHP-DB] maildir archiving to mysql

2003-10-10 Thread Geoffrey Makstutis
Hi, I'm looking for a script or some advice that will allow me to archive a large number of maildir based email messages into a mysql database. Anyone know of such an animal? thanks -- Geoffrey Makstutis [EMAIL PROTECTED] --- Makstutis

[PHP-DB] Re: textarea with multiple rows and mysql insert

2003-10-10 Thread João Cândido de Souza Neto
Hi. I every save in text type field. Are you doing this ? Jason End [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] I have a form that includes two text areas that span multiple rows. The first textarea (rows=2, cols=50) is used to insert a pretty long url, while the second

Re: [PHP-DB] Re: textarea with multiple rows and mysql insert

2003-10-10 Thread Dan Brunner
What is your field length??? Varchar(10)?? You should set the column type to text. Dan On Oct 10, 2003, at 10:27 AM, [EMAIL PROTECTED] wrote: I have a form that includes two text areas that span multiple rows. The first textarea (rows=2, cols=50) is used to insert a pretty long url, while

Re: [PHP-DB] CONGRATULATIONS You Win

2003-10-10 Thread Matthew Moldvan
So does this mean we all won? lol On Thu, 2003-10-09 at 18:37, Francis Weeny wrote: SUNSWEETWIN PROMO LOTTERY,THE NETHERLANDS. ALFONSTRAAT B56, 1002 BS AMSTERDAM, THE NETHERLANDS. TO THE MANAGER FROM: THE DESK OF THE PROMOTIONS MANAGER, INTERNATIONAL PROMOTIONS/PRIZE AWARD DEPARTMENT,

[PHP-DB] RE: Need help Get/send Variabel to another window

2003-10-10 Thread Jeremy Shovan
Is it a frame page? -Original Message- From: agus supriatna [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 1:25 AM To: [EMAIL PROTECTED] Subject: Need help Get/send Variabel to another window Dear all I have two page one as main and secon as child, now I have problem how to

RE: [PHP-DB] RE: Need help Get/send Variabel to another window

2003-10-10 Thread Michael Scappa
I'm guessing this is html? Parent.opener.formname.formfield.value = this.value; Michael Scappa -Original Message- From: Jeremy Shovan [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 12:24 PM To: 'agus supriatna'; [EMAIL PROTECTED] Subject: [PHP-DB] RE: Need help Get/send

[PHP-DB] Table locking to prevent duplicate inserts?

2003-10-10 Thread Mayo, Chuck
Hi all, I'm working through an issue that I'm sure everyone else has already figured out, how to lock a table during a series of INSERTS to prevent duplicate entries: The scenario is this: OS Solaris 8 PHP 4.2.3 MySQL 3.23.53 Table type: MyISAM 1) A user submits a form containing about

RE: [PHP-DB] RE: Need help Get/send Variabel to another window

2003-10-10 Thread Jeremy Shovan
Looks like java script to me! Can't help you there. Sorry -Original Message- From: Michael Scappa [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 10:02 AM To: [EMAIL PROTECTED]; 'agus supriatna'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] RE: Need help Get/send Variabel to another

RE: [PHP-DB] mysql_error() (was Re: Getting last insert id?)

2003-10-10 Thread Jeremy Shovan
Use echo(mysql_error()); -Original Message- From: Ben Edwards [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 5:43 AM To: pete M Cc: PHP DB List Subject: Re: [PHP-DB] mysql_error() (was Re: Getting last insert id?) On Thu, 2003-10-09 at 17:35, pete M wrote:

[PHP-DB] argh! still not able to get my variables

2003-10-10 Thread Shiloh Madsen
First off, thank you to all the people who have helped me so far with passing variables in a URL. I THINK it worked, but it would appear not to have. this is the line in the page with the link: a href='detail.php?county_id=$county_id'$name/a So what this should do is make the line item be a

RE: [PHP-DB] argh! still not able to get my variables

2003-10-10 Thread Mayo, Chuck
Shiloh, I'm kind of a latecomer here, but on my system, this works: ? if(isset($county_id)) { print pCOUNTY ID: $county_idbr\n; } else { } print No County IDbr\n; ? p a href=?= $PHP_SELF ??county_id=1708917089/abr a href=?= $PHP_SELF ??county_id=99/a Can't think why you

[PHP-DB] TIME FORMAT USING PHP

2003-10-10 Thread Delz
Hi All, We have a time and attendance system that outputs the military time in and time out of an employee on an excel file wherein the format for the time is like this : 0900 1700 wherein 0900 is 9am and 1700 is 5pm. Is there a way in php where i can get output like this 09:00 17:00 which