[PHP-DB] Popup menu problem

2003-08-18 Thread Kim Kohen
G'day all, I've struck a problem with an existing piece of code which I want to move to a new one. I'm aware of the issues with register global being off as far as forms are concerned, but I can't figure out why this snippet doesn't work. It displays the code rather than the popups. ?php

Re: [PHP-DB] Popup menu problem

2003-08-18 Thread John W. Holmes
Kim Kohen wrote: G'day all, I've struck a problem with an existing piece of code which I want to move to a new one. I'm aware of the issues with register global being off as far as forms are concerned, but I can't figure out why this snippet doesn't work. It displays the code rather than the

Re: [PHP-DB] Popup menu problem

2003-08-18 Thread Kim Kohen
G'day all I've struck a problem with an existing piece of code which I want to move to a new one. Apologies in advance. The page in question was an HTML page rather than a PHP page and I hadn't added .html to the AddType bit of the httpd.conf file. Thanks to those who replied - it's

[PHP-DB] INFORMIX (URGENT)

2003-08-18 Thread Davi José Faria Costa
Hello Everybody, I wait that somebody can help me, therefore already I depleted my possibilities. I need to develop a site in PHP with access to the Data base Informix. The such of the data base alone functions with NTFS (W2k, WNT). I installed the W2K Advanced Server in my house... and

Re: [PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-18 Thread Thomas Deliduka
As I mentioned your suggestion here does work, however while the example was simple, the application is very extensive and changing every SQL call is not possible. On 8/17/03 4:56 PM this was written: Try using the SQL to select which database. example, instead of: select * from table1

Re: [PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-18 Thread Thomas Deliduka
I am not using $dbh and $dbh2 I'm only making ONE connection to the database. I AM using mysql_query($sql,$dbh) when I make the call. I am using mysql_select_db($dbname,$dbh) to do the connection to the database but it's not selecting the one that I want. It's choosing another one and I don't

Re: [PHP-DB] Query runs fine on Console but not in PHP

2003-08-18 Thread Robert Twitty
What platform are you using? Since it appears that the script is crashing, you are probably on Linux or some other UNIX flavor. If this is the case, the TDS protocol setting may not be correct. What type of date are you retrieving with this stored procedure? -- bob On Sun, 17 Aug 2003,

[PHP-DB] problems compiling with-informix

2003-08-18 Thread matiasz
hi, my name is matts. when trying to compile php (as cgi or module) i get the following: ./configure --with-informix=/opt/informix * make * ext/mysql/libmysql/my_tempnam.o(.text+0x40): In function `my_tempnam': /usr/src/php-4.3.2/ext/mysql/libmysql/my_tempnam.c:115: the use of `tempnam' is

Re: [PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-18 Thread Micah Stevens
Agreed, sounds like a pain. to keep two copies. But if you do it to both copies, and use the same code both places (connect via URL, not 'localhost' even if you are on the same machine) then it wouldn't be any extra trouble. The OS will realize that the URL is localhost and make that connection

Re: [PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-18 Thread Thomas Deliduka
Didn't work. On 8/18/03 11:51 AM this was written: Same login for remote and local but I wonder if I did create a remote-only user it will work better. On 8/18/03 11:33 AM this was written: Agreed, sounds like a pain. to keep two copies. But if you do it to both copies, and use the same

[PHP-DB] storing serialized() data in the db - can it be queried on?

2003-08-18 Thread Matt Babineau
Hi All- I don't think that this is possible but maybe through some custom function perhaps? I am storing data in a database, and it is an Array (in PHP) so I serialized it for storage. I want to be able to query that data and be able to do something like WHERE thisField = 'john'. the field

Re: [PHP-DB] storing serialized() data in the db - can it be queried on?

2003-08-18 Thread Bob Hall
On Mon, Aug 18, 2003 at 09:39:43AM -0400, Matt Babineau wrote: Hi All- I don't think that this is possible but maybe through some custom function perhaps? I am storing data in a database, and it is an Array (in PHP) so I serialized it for storage. I want to be able to query that data and be

[PHP-DB] Help with filling a second drop down List from a prior list selection in the same page

2003-08-18 Thread Allens
Hello, Have tried for a day to figure out how to dynamically fill a second drop-down list from the first using PHP and Javascript. Still new to both would greatly appreciate some direction. Below is an example. Thanks in advance. :) All of this is inside an HTML form so that the user can add

Re: [PHP-DB] Help with filling a second drop down List from a prior listselection in the same page

2003-08-18 Thread jeffrey_n_Dyke
Sounds like you're on the right track. in the select list, add -- onChange=document.form.submit() -- this will submit the form when the user selected the an option from the list, then you could catch the submitted variable and pass it to the second drop down list and third and so on. Realizing

[PHP-DB] Problems with input and modify data on a form.

2003-08-18 Thread José Luis Palacios Vergara
I have a problem with some programs, I am using 4 frames, 3 of them are for input data, the top frame is using for input information (right now only alow show existing information), in the middle frame appear information and with the bottom frame it's possible navigate through the records, I

[PHP-DB] Best way to multi-thread (Kind of)?

2003-08-18 Thread Chris Payne
Hi there everyone, I have almost finished my forums system (Thanks for the feedback BTW on optimizing the basic query code). Now that works fine on all 6 forums (Though i've programmed the 6th forum differently to allow image uploading and resizing). My question is this, I want people to be

Re: [PHP-DB] Best way to multi-thread (Kind of)?

2003-08-18 Thread Micah Stevens
For each message have a autoincrement message ID, an INT field is sufficient I would guess. Also in each message record, have a parentID field as INT, default this to 0, and if the message is a reply to another message, make the parentID = to the first message's ID field. When you're

Re: [PHP-DB] Best way to multi-thread (Kind of)?

2003-08-18 Thread Chris Payne
Hi there, Ahhh you're a life saver, thanks for that that really helps out alot - and makes sense when I think about it :-) Regards Chris For each message have a autoincrement message ID, an INT field is sufficient I would guess. Also in each message record, have a parentID field as INT,

[PHP-DB] Mcrosoft SQL Server and for xml auto queries

2003-08-18 Thread Daniel Cher
I've been trying for months to figure out how to get for xml auto queries to work from PHP. I've got it working from ASP, which I strongly disprefer (hate!). I'd simply like to do: $sql = select * from customers for xml auto; $xml = $mssql-execute($sql); echo $xml This should return: root