Re: [PHP-DB] Re: One query, different tables?

As someone else say, is problem of DB design, probably you can do all the necessary queries in only one transaction. Un saludo, Jorge. 2013/8/9 Karl DeSaulniers > Probably with separate queries I would say. Query store 1, move to truck > then query truck and move to store 2. > >

[PHP-DB] PHP4/Apache on Win95 to remote Oracle

he ORACLE_SID, ORACLE_HOME and TNS_ADMIN variables in the autoexec.bat so that they are declared as of machine bootup. I also added them to the httpd.conf for Apache configuration like this: SetEnv ORACLE_SID MDC6 SetEnv ORACLE_HOME D:\PROGRA~1\ORAWIN95 SetEnv TNS_ADMIN D:\PROGRA~1\ORAWIN95\NET80\ADMIN Please help Before I switch to ASP... Later, Jorge [EMAIL PROTECTED]

Re: [PHP-DB] Join Sentences

melhor a fazer e para por as declaracoes numa funcao. Depois quando chamar a funcao, se alguma declaracao erra, regresse da funcao com um codico proprio. Espero que esta resposta lhe pode ajudar. Later, Jorge [EMAIL PROTECTED] - Original Message - From: Gaby <[EMAIL PROTECTED]> To: &

Re: [PHP-DB] PHP4/Apache on Win95 to remote Oracle

Hi Steve, I can successfully connect to Oracle using SQL Plus. In addition, when I call phpinfo() all the variables are set properly and OCI is enabled... I also changed ORACLE_HOME=D:\PROGRA~1\ORAWIN95 to have a full path name (program files) but the problem still exists... Later, Jorge [EMAIL

Re: [PHP-DB] PHP4/Apache on Win95 to remote Oracle

Mark, > Go to bugs.php.net and search thru the open bugs for "oracle" You'll find > a good dozen bugs on Windows that seem to be describing this problem. > #6396 and #8132 come to mind. In addition, bug #7446 for standard Oracle Later, Jorge [EMAIL PROTECTED] - Ori

Re: [PHP-DB] PHP4/Apache on Win95 to remote Oracle

Hi Stas, I already tried that solution to no avail... Later, Jorge Hello, "Jorge Santos"! You wrote: > $connect = OCIPLogon ("MDC", "MDC", $tns) or die ("It's > not possible to > connect"); Try to put "MDC6" as your 3rd par

Re: [PHP-DB] Undefined Variable and argument not valid . . .

Hi John, You're trying to use a variable that is not set. Try using the isset function... Like this: if (isset($COCOD)) $result = mysql_query("SELECT * FROM tblAA_MIKER_COMPDAT WHERE COCOD=$COCOD",$db); Hope this helps... Later, Jorge [EMAIL PROTECTED] - O

Re: [PHP-DB] Undefined Variable and argument not valid . . .

the elements to be indexed by field names and MYSQL_BOTH FORCES the indexes to be stored both ways. It may be possible that your default is setup to MYSQL_NUM and that would be why you're getting an error. Try: $myrow = mysql_fetch_array($result,MYSQL_ASSOC); Hope this helps. Later, Jo

Re: [PHP-DB] Passing vars

additional problems and performance issues. By keeping your data at hand on the server a simple fopen and fclose can do the job. By self writing code you only have to write the file and not read it later. My 2 cents, (Perhaps 3 cents), Jorge [EMAIL PROTECTED] - Original Message - Fro

Re: [PHP-DB] Oracle & WinNT4/2000

se have this problem (PHP to Oracle 8.0.5)?? Later, Jorge [EMAIL PROTECTED] - Original Message - From: Randall Barber <[EMAIL PROTECTED]> To: Jorge Santos <[EMAIL PROTECTED]> Sent: Friday, February 16, 2001 10:42 PM Subject: Re: [PHP-DB] Oracle & WinNT4/2000 > Try upgr

Re: [PHP-DB] Oracle & WinNT4/2000

Randall, Apparently I mis-understood you. I thought you meant upgrade the servers... Yes we can upgrade the client. Do you have a URL available for the 8.1.6 version of the client... Thanks. Later, Jorge [EMAIL PROTECTED] - Original Message - From: Randall Barber <[EMAIL PROTECTED]&

Re: [PHP-DB] deleting carts

s called. There's no reason to create a cron to delete records because you can have the shopping cart script do it automatically... Hope this helps, Jorge [EMAIL PROTECTED] - Original Message - From: Nicholas W. Miller <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday

[PHP-DB] PHP+Oracle+Sessions

Hi. Is there any way to store an OCI8 connection resource $conn = ociplogon("",""); in a session like session_register('conn') and then use this connection by accessing the var in the other pages? I've tried this but it doesn't work... Thanks -- PHP Database Mailing List (http://www.php.ne

[PHP-DB] InterBase 6, PHP & Windows 9x

Hi there, I would like to know if it is possible do develop a Interbase-driven web site with PHP under Windows 98. If it's possible, which web server do you recommend? Any guidelines or on-line docs I should read? Many thanks in advance, Jorge Alvarez -- PHP Database Mailing List

Re: [PHP-DB] headers already sent

You have some content at line 2 in file trial.php. Check if there is a space (or a session command) at that line. -- Jorge Oliveira » Cloreto.com matthew perry wrote: When I insert the following header: header ("Content-type: application/vnd.ms-excel"); header ("Cont

[PHP-DB] Re: DBF question: column names?

Hi, You can open the DBF file in Excel and the first column is the name, so if you want to know the structure you can use DBU.exe that is included in clipper. "Suzerain.Studios" <[EMAIL PROTECTED]> escribió en el mensaje news:a05111a52b9c64fa4b608@;[192.168.2.5]... > Hi there. > > I'm not famili

Re: [PHP-DB] Interbase Problem

What OS is running in the InterBase machine? Are you running IB Classic or SuperServer? I haven't seen this error but have read about it a few times, in those cases the machine was running Windows NT and IB SS. -Jorge ""Niel Zeeman"" <[EMAIL PROTECTED]> escribió

[PHP-DB] PHP Bug with InterBase

orm using Apache, PHP 4.05 and Interbase 6.01, however the person reporting this confirmed that the bug is not present in a Linux environment. Any insight is appreciated. Regards, -Jorge -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addition

[PHP-DB] PHP 4.0.6 InterBase Bug

ck to PHP 4.0.5, which works just fine. Thanks for your help, -Jorge -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] T_String?

I am getting the following error: Parse error: parse error, unexpected T_STRING in C:\Program Files\Apache Group\Apache2\htdocs\view.php on line 4 On line: $result = mysql_query(select * from guestbook) or die (mysql_error()); And I have no idea where the T_STRING is coming from. I know this is

[PHP-DB] Converting text field to barcode CODE 39

Hello. Can anyone tell me where I can find information or examples about printing on screen or in PDF (with FDPF for example) for text fields stored on a MySQL Database with PHP 4 , PHP 5. Best regards, Jorge Gimenez

[PHP-DB] Digital Signature and PHP4/5

Hello. I am looking for info about PHP+ Database (Mysql/Postrgesql) + Digital Signature. Does anyone know about any site, book... about this? Best regards, Jorge Gimenez -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Read HTML code and store it in database

onnect_url(url); //code to search data in $url; //code to store data; Any ideas?. Best regards, Jorge Giménez -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] nl2br & BLOB field of MySQL

It's probably a problem of my code, can anyone help me? I have a BLOB field in a MySQL table. This field is filled in a php page with a , where I can enter it formatted, with ENTER's to split some lines from others. In another page, this field is seen (not updated) - so I don't have a tag. As I w

Re: [PHP-DB] Wrapping problems

Hi, I've tried the solution you gave to be able to see the line breaks of a blob field of MySQL and it doesn't work. Sorry, I'm a newbie to PHP & MySQL. Can you imagine why it's not formatting (eg. line breaks) the text? Thanks in advance. Jorge "Ray Black III&quo

[PHP-DB] Special character on an INSERT statement

Hi . I'm trying to do this on an INSERT statement. $sql= "INSERT (' TONS OF CD'S ') or any phrase with the character ' . Obviously it gives an error when execeting mysql_query. How can I do it ? Thanks, Jorge Giménez

Fw: [PHP-DB] Special character on an INSERT statement

es, there are no INSERT examples. I ' m a newbie PHP programmer . Thanks again, Jorge Giménez - Original Message - From: "Jorge Giménez Mayorgas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 28, 2001 6:48 PM Subject: [PHP-DB] Sp

[PHP-DB] Re: Special Character on INSERT statement

Hi again It is solved I used $value="'".urlencode($value)."'" And urldecode for showing the data. Thanks everybody for the help. Later, Jorge Giménez - Original Message - From: Jorge Giménez Mayorgas <[EMAIL PROTECTED]> To: <[EMAIL

[PHP-DB] MSSQL Views and Multiples selects on Mysql

documentation and I think it's ok. It gives me with mysql_errorno the error 1064, any ideas? . Is there any program , script , etc to migrate to MySQL SQL syntax the views of MSSQL . Later, Jorge Gimenez

Re: [PHP-DB] Trouble connecting to MSSQL 2k DB

Try put the php dlls on %systemroot%/system. I have IIS 5.0 + PhP 4.0.6 + MSSQL on a W2k server working perfectly. Later, Jorge Giménez - Original Message - From: "Sean Swehla" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 13

[PHP-DB] Array key problem

Hi! Anyone got an idea what the problem may be with the following code $test[]="a"; $test[]="b"; foreach ($test as $key=>$value) { if($key == "something") echo $key } even though theres no key in the array named "something" the code will print the key "0" Thanks

[PHP-DB] Date

How can a make a query that lists all the fields where a datefield as the date of tomorow? thanks