[PHP-DB] RE: ezmlm response

2001-03-07 Thread B Satish , Gurgaon
> -- > From: > [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, March 07, 2001 2:42 PM > To: [EMAIL PROTECTED] > Subject: ezmlm response > > > > hi friends > > can any one of you send me the url's to download mysql database since > three > days i have been

[PHP-DB] NT4+APACHE+PHP+DB2

2001-03-07 Thread Charles Brown
I want to connect to db2 use ODBC,But get a error:SQLSTATE 57017,means a diffrent codepage setting,my db2's codepage=437,But how can i set codepage in php?or in apache? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

[PHP-DB] (Newbie) how to evaluate a varying number of db generated checkboxes?

2001-03-07 Thread jester
I'm generating a html form with php and a MySQL database. My code generates a varying number of checkboxes depending on the number of 'options' in my database. The name of the checkbox is set to the -id- of the 'option' in my database. When the generated form is posted I want to show a page showin

[PHP-DB] ODBC test cases

2001-03-07 Thread Dan Kalowsky
Hi, I've been working on some of the bugs for ODBC in the bugs db, mainly those dealing with Windows and ODBC. One of the common bugs seems to be using odbc_prepare() and odbc_execute() in conjuction with each other. I was hoping someone might be able to do an ODBC test case for me, on somethi

[PHP-DB] ODBC test cases: CORRECTED

2001-03-07 Thread Dan Kalowsky
Made an error in the first script (forgot to update one field)... find the correction below... --- Hi, I've been working on some of the bugs for ODBC in the bugs db, mainly those dealing with Windows and ODBC. One of the common bugs seems to be using odbc_prepare() and o

[PHP-DB] mail server

2001-03-07 Thread Free Beachler
hi all, is there any way i can specify my own smtp server and override the php.ini file? i want to use the mail command on my host and i keep getting this error: Warning: Unknown error in D:\inetpub\nextepmedia\www\nexteplaunch\test_email.php on line 2 i just have a simple ph

[PHP-DB] mail function

2001-03-07 Thread Liz Bander
I need to make an email link in a table. The username is displayed as text; I need it to be a link through which I can send email. Is this possible in php? The following is the code for that I'm using: function show_logged_users($user) { $query = "select distinct uid, cn from log left jo

RE: [PHP-DB] mail server

2001-03-07 Thread Michael J. Upchurch
The function ini.set() should be the one to use, but it doesn't set all options for security reasons. See http://www.php.net/manual/en/function.ini-set.php for details. You should also check the annotations for email functions for other options. Michael J. Upchurch Partner2Partner Communication

[PHP-DB] Problem with rule

2001-03-07 Thread Olivier Thauvin
I have a problem with rule on a postgresql 7.0.3: When I do create rule truc as on insert to table do insert into othertable (value) values (new.clef); where clef is my primary key as serial, it jump one entry in the sequence table and my insert on the other table dosen't put the correct value

[PHP-DB] Date Help

2001-03-07 Thread Faye Keesic
--MS_Mac_OE_3066812333_145812_MIME_Part Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit When I want to subtract a day from a date, and pass the date to a function that will do the subtraction and then return the new value, so why does php sometimes subtract the year, i

Re: [PHP-DB] (Newbie) how to evaluate a varying number of db generated checkboxes?

2001-03-07 Thread JJeffman
If you have a way to decide which checkboxes have to be checked, just set its attribute like the line bellow: > HTH Jayme. -Mensagem Original- De: jester <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviada em: quarta-feira, 7 de março de 2001 14:00 Assunto: [PHP-DB] (Newbie) how to e

Re: [PHP-DB] Date Help

2001-03-07 Thread Richard S. Crawford
I desperately need to know whether it is possible to call an Oracle function in PHP. For example... $functionResult=hubins($name,$commit_yn) where hubins is a stored procedure in our Oracle database. Can this be done? My first thought was to do something like this: $functionCall="hubins($

[PHP-DB] Oracle Function Calls

2001-03-07 Thread Richard S. Crawford
Ah! My bad! I sent this question out with the wrong subject line. My apologies to everyone that I confused. At 01:07 PM 3/7/01 -0800, Richard S. Crawford wrote: >I desperately need to know whether it is possible to call an Oracle >function in PHP. For example... > >$functionResult=hubins

Re: [PHP-DB] mail function

2001-03-07 Thread JJeffman
You can't have links in a selection list you have to use another interface object like anchor tags () while(){ echo("Link description"); } HTH Jayme. -Mensagem Original- De: Liz Bander <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviada em: quarta-feira, 7 de março de 2001 15:03

Re: [PHP-DB] mail server

2001-03-07 Thread JJeffman
I'm not sure but I think you must have a smtp server program running to configure as your smtp server. HTH. Jayme. -Mensagem Original- De: Free Beachler <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviada em: quarta-feira, 7 de março de 2001 14:48 Assunto: [PHP-DB] mail server > hi

AW: [PHP-DB] Oracle Function Calls

2001-03-07 Thread Matthias Kopolt
YOu have to form proper SQL-Statements try to parse and execute: select foo_function ('paramstr', 999) from dual; dual is a dummy table; then fetch the resultrow and ociresult($stmt, 1) will return your functionreturnvalue mk -Ursprungliche Nachricht- Von: Richard S. Crawfo

Re: AW: [PHP-DB] Oracle Function Calls

2001-03-07 Thread Richard S. Crawford
Here is the error that I get when I try this approach: ORA-14551: cannot perform a DML operation inside a query At 10:26 PM 3/7/01 +0100, Matthias Kopolt wrote: >YOu have to form proper SQL-Statements > >try to parse and execute: > > select foo_function ('paramstr', 999) from dual; > >

AW: AW: [PHP-DB] Oracle Function Calls

2001-03-07 Thread Matthias Kopolt
Oracle Divides Function in several Groups DML means Data-Manipulating function; (in your funciton is a update or insert) to use a function in a query it needs to be "pure" only selects and arithmetics you can rewrite this function to a procedure and return your value as an out parameter

Re: AW: AW: [PHP-DB] Oracle Function Calls

2001-03-07 Thread Richard S. Crawford
Hm. Assuming that I don't have the option of rewriting the function to a procedure, is there another way to go? At 10:54 PM 3/7/01 +0100, Matthias Kopolt wrote: >Oracle Divides Function in several Groups > >DML means Data-Manipulating function; > >(in your funciton is a update or insert) > >to

[PHP-DB] parsing parameter over page 2

2001-03-07 Thread andrie
Hello All, thank for your attention i've tried to serialize my class variable and it seem to be work ( i print it out using echo $a;) but when i do unserialize to that class nothing happen, and still i can use my class ? is there something wrong ?

Re: [PHP-DB] mail server

2001-03-07 Thread Miles Thompson
Paul Schreiber has written, in PHP, an email class. His opening comments are given below, but ii doesn't do what you want. He might be worth emailing however. If you were on a Linux/Unix/etc box you could use exim, as it can be configured to be either it's own SMTP mailer or to use the ISP's.

Re: [PHP-DB] Oracle Function Calls

2001-03-07 Thread Joe Brown
this chunk of code comes out of http://www.php.net/manual/en/function.ocinewcursor.php Hope that helps, I havn't gone there (yet). ""Richard S. Crawford"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Ah! My bad! I sent this question out with the wrong s

[PHP-DB] Query times

2001-03-07 Thread Norman Tan
How do I get the query times echoed like this? http://www.ub2k.com/alpha/UltraBoard.php Thanks -- Norman Tan North Shore Interactive http://www.nsmb.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTEC

[PHP-DB] Import

2001-03-07 Thread Pankaj Ahuja
I wonder if I am posting this to the right group but can anyone tell me how to import all the tables (including the information)from the server to my local machine and vice versa. I am using a mysql database. Many Thanks Pankaj -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] Import

2001-03-07 Thread Emre YILMAZ
if you are using phpmyadmin just click your database (its listed at the left column) then at the right side select "structure and data" which is located under "View dump(schema) of database" part, then select send and then click "go" you ll be asked for the path of your backup sql file. thats it.

Re: [PHP-DB] Import

2001-03-07 Thread Pankaj Ahuja
Thanks, but is there any other method. Say something at telnet prompt. I do not use phpmyadmin - Original Message - From: Emre YILMAZ To: [EMAIL PROTECTED] Sent: Thursday, March 08, 2001 1:01 PM Subject: Re: [PHP-DB] Import if you are using phpmyadmin just click your database (its list

Re: [PHP-DB] Import

2001-03-07 Thread Beau Lebens
i think there is a command something like mysqldump try checking the mysql docs At 01:06 PM 3/8/01 +0530, Pankaj Ahuja wrote: >Thanks, but is there any other method. Say something at telnet prompt. I do >not use phpmyadmin > > >- Original Message - >From: Emre YILMAZ >To: [EMAIL PROTECTED

Re: [PHP-DB] Import

2001-03-07 Thread karakedi
username$ mysqldump -opt -user=username -password=password yourdbname > yourbackupfilename.txt :) ""Pankaj Ahuja"" <[EMAIL PROTECTED]> wrote in message 015f01c0a7a2$81fa77f0$0101a8c0@server">news:015f01c0a7a2$81fa77f0$0101a8c0@server... > Thanks, but is there any other method. Say something at

Re: [PHP-DB] Import

2001-03-07 Thread karakedi
username$ mysqldump -opt -user=username -password=password yourdbname > yourbackupfilename.txt :) ""Pankaj Ahuja"" <[EMAIL PROTECTED]> wrote in message 015f01c0a7a2$81fa77f0$0101a8c0@server">news:015f01c0a7a2$81fa77f0$0101a8c0@server... > Thanks, but is there any other method. Say something at

Re: [PHP-DB] Import

2001-03-07 Thread karakedi
username$ mysqldump -opt -user=username -password=password yourdbname > yourbackupfilename.txt :) ""Pankaj Ahuja"" <[EMAIL PROTECTED]> wrote in message 015f01c0a7a2$81fa77f0$0101a8c0@server">news:015f01c0a7a2$81fa77f0$0101a8c0@server... > Thanks, but is there any other method. Say something at

[PHP-DB] alphabetical order

2001-03-07 Thread karakedi
hi there, i ve created a database. there are two rows in it, one is "id" and the other consists of "film names". i ve managed to list and print them out sorting by ids, but i just wonder if there is a way to sort them in alphebetical order. any example is high appreciated. thx in adv. -- PH

Re: [PHP-DB] alphabetical order

2001-03-07 Thread karakedi
i am using mysql :) ""karakedi"" <[EMAIL PROTECTED]> wrote in message 987dse$svd$[EMAIL PROTECTED]">news:987dse$svd$[EMAIL PROTECTED]... > hi there, > i ve created a database. there are two rows in it, one is "id" and the other > consists of "film names". > > i ve managed to list and print them

Re: [PHP-DB] alphabetical order

2001-03-07 Thread Beau Lebens
you should be able to do this exactly the same as you have the id SELECT * FROM film_details ORDER BY film_names ASC should sort by the film name, 'A' first, up to 'Z' if that doesn't work, perhaps get all the results, drop them into an array and then sort the array, then process the array. H

Re: [PHP-DB] alphabetical order

2001-03-07 Thread Robert Gormley
SELECT * FROM films ORDER BY filmname ASC; Robert At 09:57 AM 8/03/2001 +0200, karakedi wrote: >hi there, >i ve created a database. there are two rows in it, one is "id" and the other >consists of "film names". > >i ve managed to list and print them out sorting by ids, but i just wonder if >ther

Re: [PHP-DB] alphabetical order

2001-03-07 Thread karakedi
woa that was a real quick help :) thx alot "Beau Lebens" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > you should be able to do this exactly the same as you have the id > > SELECT * FROM film_details ORDER BY film_names ASC > > should sort by the film name,

Re: [PHP-DB] alphabetical order

2001-03-07 Thread karakedi
thx :) "Robert Gormley" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > SELECT * FROM films ORDER BY filmname ASC; > > Robert > > At 09:57 AM 8/03/2001 +0200, karakedi wrote: > >hi there, > >i ve created a database. there are two rows in it, one is "id" and the