[PHP-DB] Re: can OCIBindByName bind an in/out placeholder of plsql

2002-10-31 Thread DIGINEXT
I discovered recently that it was impossible to bind an output placeholder plsql (an input work only). Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 Configuration 2 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.3 Configuration 3 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.2 Wit

[PHP-DB] Re: can OCIBindByName bind an in/out placeholder of plsql

2002-10-31 Thread DIGINEXT
I discovered recently that it was impossible to bind an output placeholder plsql (an input work only). Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 Configuration 2 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.3 Configuration 3 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.2 Wit

[PHP-DB] Re: can OCIBindByName bind an in/out placeholder of plsql

2002-10-31 Thread DIGINEXT
I discovered recently that it was impossible to bind an output placeholder plsql (an input work only). Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 Configuration 2 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.3 Configuration 3 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.2 Wit

[PHP-DB] Re: can OCIBindByName bind an in/out placeholder of plsql

2002-10-31 Thread Fabien JOSEPH
I discovered recently that it was impossible to bind an output placeholder plsql (an input work only). Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 Configuration 2 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.3 Configuration 3 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.2 Wit

[PHP-DB] Re: Newbie-Question: What's that @?

2002-10-31 Thread rolf vreijdenberger
there is no difference between the two! quote: " @mysql_query($query) and @mysql_query($query)? " haha but seriously, the @ supresses error messages from php, so these will not be outputted. No information on why or how, the query in this case, it failed. you can do this on a per function basis wit

[PHP-DB] Add column to a table

2002-10-31 Thread Shaun Thornburgh
Hi, Please could someone tell me what the syntax is to add a column to a table? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Add column to a table

2002-10-31 Thread Walter, Marcel
For mysql: Alter table add column ; Regards, Marcel -Original Message- From: Shaun Thornburgh [mailto:shaun@;mania.plus.com] Sent: 31 October 2002 13:39 To: [EMAIL PROTECTED] Subject: [PHP-DB] Add column to a table Hi, Please could someone tell me what the syntax is to add a column

RE: [PHP-DB] Add column to a table

2002-10-31 Thread Aaron Wolski
ALTER TABLE TableName ADD COLUMN columnParametersHere E.g: ALTER TABLE UserTable ADD COLUMN userName varchar(255); Aaron > -Original Message- > From: Shaun Thornburgh [mailto:shaun@;mania.plus.com] > Sent: Thursday, October 31, 2002 7:39 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Ad

[PHP-DB] need help with "SHOW Colums"

2002-10-31 Thread David Rice
mysql_select_db("filterseveuk"); $query = ( " SHOW COLUMNS FROM user "); $result =  mysql_query ( $query ) or die( mysql_error () ); while ( $row = mysql_fetch_array ($result) ){ $x = 0 ; echo $row[$x] ; $x++ ; } I would like to replace the table name "user"

[PHP-DB] cookie trouble

2002-10-31 Thread Seabird
Hi everyone, I'm having some trouble configuring a cookie (first time doing this): I have a login-script and this sets a session cookie. What I really want is to pass a cookie so that returning-people don't have to log in every time, but I'm not sure how to do what part is passing on the cookie (I

Re: [PHP-DB] need help with "SHOW Colums"

2002-10-31 Thread 1LT John W. Holmes
So show us the code that you tried with. This code doesn't do us any good because it's not causing the error. ---John Holmes... - Original Message - From: "David Rice" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 31, 2002 11:31 AM Subject: [PHP-DB] need help with "S

[PHP-DB] IIS question

2002-10-31 Thread Ryan Jameson (USA)
You guys are so smart! Can anyone tell me why IIS gives a 404 error on any file with a .dat extension? Thanks.. <>< Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] IIS question

2002-10-31 Thread Ryan Jameson (USA)
Mystery solved: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q309508&; IIS Lockdown did it... to fix go to windir\System32\Inetsrv\Urlscan\urlscan.ini and remove the .dat line or other necessary extension. -Original Message- From: Ryan Jameson (USA) Sent: Thursday, October 3

[PHP-DB] mail()

2002-10-31 Thread Edward Peloke
I know this is off topic to the db list but.. I am attempting to use the mail function. I have set the smtp in the php.ini file to my smtp server but when I run the script, I get the error Warning: Failed to Connect in c:\program files\apache group\apache\htdocs\lg\nuser2.php on line 50 where li

Re: [PHP-DB] mail()

2002-10-31 Thread Jeffrey_N_Dyke
did you restart apache? epeloke@echoma n.com (Edward

Re: [PHP-DB] mail()

2002-10-31 Thread Marco Tabini
Did you restart the server? Are you sure you modified the right php.ini? On Thu, 2002-10-31 at 14:53, Edward Peloke wrote: > I know this is off topic to the db list but.. > > > I am attempting to use the mail function. I have set the smtp in the > php.ini file to my smtp server but when I run

[PHP-DB] OCISaveLob, OCILoadLob, OCISaveFile?

2002-10-31 Thread Jean Tardy
Hello, Who know haw to use those functions:OCISaveLob, OCILoadLob, OCISaveFile? Where can I find documentation and sample about this general purpose: 'lob object manipulation with oracle" Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub

[PHP-DB] Re: MAIL()

2002-10-31 Thread Tony72284
If your sending it from your Server/Computer and then to another server/www . YOu probally don't have permissions to send the mail.

RE: [PHP-DB] mail()

2002-10-31 Thread Edward Peloke
yep and I still get the same error...I modified the ini file in my windows directory..I assume that is the right one. Eddie -Original Message- From: Marco Tabini [mailto:marcot@;tabini.ca] Sent: Thursday, October 31, 2002 2:24 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: [PHP-D

RE: [PHP-DB] mail()

2002-10-31 Thread Edward Peloke
this may be dumb but I for the smtp setting, I simply put in what every is under smtp when I open up the info in outlook...do I need to put it in quotes or anything? -Original Message- From: [EMAIL PROTECTED] [mailto:Jeffrey_N_Dyke@;Keane.com] Sent: Thursday, October 31, 2002 2:31 PM To: E

[PHP-DB] Re: cookie trouble

2002-10-31 Thread Seabird
I got this fixed, but how do I reverse a md5 encryption? this way I can log people in again. Jacco -- http://seabird.jmtech.ca Attitude is Everything! But Remember, Attitudes are Contagious! Is Yours worth Catching "Seabird" <[EMAIL PROTECTED]> wrote in message news:20021031165410.94762

RE: [PHP-DB] Re: cookie trouble

2002-10-31 Thread Aaron Wolski
You cannot reverse the encryption of an md5 hash. Nor should you want to. You don't want to know their password which is why you encrypt it. When you seyup an account you convert the password to an md5 has(I assume you have done so). When they log back in.. You convert the password to an md5 hash

Re: [PHP-DB] Re: cookie trouble

2002-10-31 Thread Mark Nenadov
On October 31, 2002 02:48 pm, Seabird wrote: > I got this fixed, > > but how do I reverse a md5 encryption? this way I can log people in > again. > > Jacco You can't reverse md5. All you need to do is compare an md5'ed copy of what the user entered to what you have in your database (or wherev

RE: [PHP-DB] Multiple table select, but still returning row if no record exists in second table?

2002-10-31 Thread phplists
The query should look similar to this: SELECT table1.col as [column_a], table2.col as [column_b] FROM table1 LEFT JOIN (or LEFT OUTER JOIN) table2 ON table2.some_key_col = table1.some_key_col ... for all required keysWHERE -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visi

RE: [PHP-DB] Multiple table select, but still returning row if no record exists in second table?

2002-10-31 Thread phplists
The query should look similar to this: SELECT table1.col as [column_a], table2.col as [column_b] FROMtable1 LEFT JOIN (or LEFT OUTER JOIN) table2 ON table2.some_key_col = table1.some_key_col ... for all required keys WHERE -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Restarting Mysql

2002-10-31 Thread Michael Conway
I'm debugging a script that locks tables as part of an INSERT script (using Linux 7.1). Mysql frequently locks out the tables involved when there is an error (never gets to UNLOCK command. I have been rebooting until now. Using % "mysqladmin shutdown" works. safe_mysqld doesn't. Any suggestions

Re: [PHP-DB] need help with "SHOW Colums"

2002-10-31 Thread rolf vreijdenberger
$table="user"; > > $query = " SHOW COLUMNS FROM $user "; > > > > $result = mysql_query ( $query ) or die( mysql_error () ); > > > > while ( $row = mysql_fetch_array ($result) ){ > > > > $x = 0 ;// i don't know what you're trying to do here, but it's wrong!! It keeps resetting$x to zero and does n

[PHP-DB] string

2002-10-31 Thread John Coder
I want to list months found in db by the first three letters as in an abbrevaition of the months i.e.: Jan Feb Mar Apr and so forth I can get the names by monthname(blah) but am stuck on converting strings to first three letters I"ve been trying explode("",$blah) but that doesn't work. I'm at a l

RE: [PHP-DB] string

2002-10-31 Thread Beau Lebens
you can do this as a part of your db query check the string functions available for your rdbms. mysql would use something like; SELECT SUBSTRING(monthname(blah), 0, 3) AS monthAbbrev FROM tablename from memory HTH beau // -Original Message- // From: John Coder [mailto:jcoder@;insight

RE: [PHP-DB] string

2002-10-31 Thread John W. Holmes
DATE_FORMAT(your_column,'%b') or SUBSTRING() ---John Holmes... > -Original Message- > From: John Coder [mailto:jcoder@;insightbb.com] > Sent: Thursday, October 31, 2002 8:47 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] string > > I want to list months found in db by the first three let

RE: [PHP-DB] string

2002-10-31 Thread John Coder
Didn't even think of looking for a mysql function to accomplish this. Thanks. On Thu, 2002-10-31 at 20:52, Beau Lebens wrote: > you can do this as a part of your db query > > check the string functions available for your rdbms. > > mysql would use something like; > > SELECT SUBSTRING(monthnam

[PHP-DB] Fw: Dows anyone know why this was bounced?

2002-10-31 Thread Robert Twitty
Does anyone know why all mail that I send to any aspect of the php-db list is bounced when it is sent from the address below? -- bob - Original Message - From: "Robert Twitty" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 31, 2002 9:39 PM Subject: Returned mail: see

[PHP-DB] Am I doing This Right?

2002-10-31 Thread Tony72284
!move_uploaded_file($HTTP_POST_FILES['replay_file']['tmp_name'], "$rLoc") ) { print 'Sorry, file not correctly uploaded.'; pgMid(); nav('war3-replays-submit'); pgFoot(); exit(); // If File Was Moved And Renames

Re: [PHP-DB] Restarting Mysql

2002-10-31 Thread Jason Wong
On Friday 01 November 2002 09:04, Michael Conway wrote: > I'm debugging a script that locks tables as part of an INSERT script > (using Linux 7.1). Mysql frequently locks out the tables involved when > there is an error (never gets to UNLOCK command. I have been rebooting > until now. Using % "m

Re: [PHP-DB] Am I doing This Right?

2002-10-31 Thread Jason Wong
On Friday 01 November 2002 15:05, [EMAIL PROTECTED] wrote: > > function war3_replays_submit() { > > if ( isset($replay_file) ) { Doing what right? Where/what is the problem? -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & H