[PHP-DB] foreach problem

2003-02-07 Thread Sam Folk-Williams
Hi, I can't figure out why this won't work: foreach($event_date as $val) { $sql2 = INSERT INTO cal_date_map (entry_id, date) VALUES (\$entry_id\, \$val\); $result = @mysql_query($sql2,$connection) or die (Problem executing foreach database query.); } $event_date is an array with several

[PHP-DB] Re: foreach problem

2003-02-07 Thread Bastian Vogt
$sql2 = INSERT INTO cal_date_map (entry_id, date) VALUES (\$entry_id\, \$val\); Where does $entry_id come from? Maybe it's unique? Bastian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] help with loop and query

2003-02-07 Thread Aaron Wolski
Hi guys, Hopefully last time I need to call of you people for this report I am creating. In this report there is a multiple select box like: select name=province[] class=selectcontent size=3 multiple   option value=  

[PHP-DB] Re: PHP - Oracle 7.3.4 - ORA-12154

2003-02-07 Thread Philippe Saladin
I set up PHP on a Sun Solaris box a week ago (see phpinfo output below). It has oracle 7.3.4 and php 4.0.4pl1 so I'm using the --with-oracle configure option. Due to a special module we're using we're stuck with using that php version (4.0.4pl1). Couldn't you use --with-oci, even with

[PHP-DB] Re: Oracle 9.2 + IIS 5.0 + Win2k server + PHP 4.3 + ADODB 3.10

2003-02-07 Thread Philippe Saladin
$conn-NConnect('', 'usr', 'usr_pwd', 'TNSName'); # select machines from machinetable NConnect exists in adodb since version 2.43. Have you tried with PConnect() or Connect() instead of NConnect() ? they are older (october 2002), and may be they are more robust ? Is this a bug? Should I

Re: [PHP-DB] Re: vaiable from one page to another

2003-02-07 Thread Antonio Bernabei
- Original Message - From: J.Veenhuijsen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 1:24 PM Subject: [PHP-DB] Re: vaiable from one page to another Try p.php: ?php //Not ?php echo($fname); ? Jochem Bismi Jomon wrote: hi, i hav two

Re: [PHP-DB] foreach problem

2003-02-07 Thread Jason Wong
On Friday 07 February 2003 11:22, Sam Folk-Williams wrote: Hi, I can't figure out why this won't work: foreach($event_date as $val) { $sql2 = INSERT INTO cal_date_map (entry_id, date) VALUES (\$entry_id\, \$val\); $result = @mysql_query($sql2,$connection) or die (Problem executing

Re: [PHP-DB] foreach problem

2003-02-07 Thread Sam Folk-Williams
I don't get any MySQL error... It adds the first entry_id and date exactly as it should... it seems to be acting like entry_date is not an array, but when I use the same foreach loop to echo the contents of entry_date it echoes the multiple values (2003-05-01, 2003-05-02, etc)... I use the same

[PHP-DB] Old memory contents appearing in files created by dba_open

2003-02-07 Thread Len Sorensen
I was playing around with figuring out why dba_open creates an ndbm database when run in stand alone mode (as requested) but creates a db2 database when run as an apache module. This is in php 4.2.3 on a Debian 3.0 system. I haven't tried with 4.3 yet. I am not sure if this is a bug somewhere,

[PHP-DB] Getting array values into a query

2003-02-07 Thread Michael Conway
I've been attempting to take the values from an array pulled from a session to supply the variable in a WHERE clause. list() provides only the first value as expected. implode() the last. Any suggestions or should I just load the values I want in the session through a query on the previous script

Re: [PHP-DB] Old memory contents appearing in files created by dba_open

2003-02-07 Thread Len Sorensen
On Fri, Feb 07, 2003 at 05:38:04PM -0500, Len Sorensen wrote: I was playing around with figuring out why dba_open creates an ndbm database when run in stand alone mode (as requested) but creates a db2 database when run as an apache module. This is in php 4.2.3 on a Debian 3.0 system. I

[PHP-DB] Passing ARRAY through URL

2003-02-07 Thread Squirrel User
Help. I've tried to pass large array through URL but it keep telling me page can not be displayed: ? // page1.php $mList = arrary(); ...// fill array with values $mList = urlencode( serialize( $mList ) ); header( location: page2.php?mL=$mList ); ? ? // page2.php $mList = stripslashes(

RE: [PHP-DB] Passing ARRAY through URL

2003-02-07 Thread John W. Holmes
Help. I've tried to pass large array through URL but it keep telling me page can not be displayed: If you get page not found then it's not an issue with your code. Does page2.php really exist? What does the URL look like when it says page cannot be found? Is this a PHP or HTML error that you

Re: [PHP-DB] foreach problem

2003-02-07 Thread Jason Wong
On Saturday 08 February 2003 06:16, Sam Folk-Williams wrote: I don't get any MySQL error... It adds the first entry_id and date exactly as it should... it seems to be acting like entry_date is not an array, but when I use the same foreach loop to echo the contents of entry_date it echoes the

Re: [PHP-DB] Getting array values into a query

2003-02-07 Thread Jason Wong
On Saturday 08 February 2003 06:47, Michael Conway wrote: I've been attempting to take the values from an array pulled from a session to supply the variable in a WHERE clause. list() provides only the first value as expected. implode() the last. Any suggestions or should I just load the