RE: [PHP-DB] Capturing select values from a multliple-select list box

2001-10-22 Thread Beau Lebens
i *think* you can do something like and then it will pass an array on submission (someone please correct if wrong!) failing that, you could use a javascript:onChange() function to set the value of a hidden field using something like (snippet from previous project) function updateValueString() {

[PHP-DB] datetime in MSSQL7

2001-10-22 Thread kras
Hello! How can I force PHP to fetch datetime field i 'mmdd hh:mm:ss' WITHOUT using MSSQL query like *SELECT convert(varchar,dtfield,20) as 'dtfield'* and so on? I have a few tables on MSSQL with the different structures and some of fields are datetime. I have to use CLASS in php with querys

Re: [PHP-DB] I'm stuck!

2001-10-22 Thread Robin McKenzie
Have you tried something like: $last_access=now(); $update_query = "UPDATE guestbook SET last_access='$last_access' WHERE guest_id='$guest_id'"; Otherwise... have you tried entering the query manually (e.g. with phpmyAdmin, etc.) using a relevant guest_id: UPDATE guestbook SET last_access='NOW(

[PHP-DB] Warning: MySQL: Unable to save result set

2001-10-22 Thread Doug Schasteen
Warning: MySQL: Unable to save result set in on line *** I recently upgraded to php 4 from 3. I also upgraded MySQL to 3.23.43 at the same time and repopulated my database with a .sql file. Everything works fine but I get this warning message every time I do an UPDATE, DELETE, or an INSERT. The

[PHP-DB] Re: [PHP] This is my second work :)

2001-10-22 Thread Robin McKenzie
Philip, I don't really see the problem with Arash's post. If people want to help him out with critique, then that's their option. This board is hardly swamped with similar postings, is it? Robin Mckenzie "Philip Olson" <[EMAIL PROTECTED]> wrote in message news:Pine.BSF.4.10.10110150632510.35

Re: [PHP-DB] Re: fulltext not for me/alternatives

2001-10-22 Thread Szii
In the source directory, there's a "myisam/ftdefs.h" file. You can change the min word size there. Note that you will have rebuild it, and reinstall. Usually via "make/make install." Also you have to rebuild the indicies. Easiest way is to drop and readd them. 'Luck -Szii - Original Mess

Re: [PHP-DB] Creating a file using php

2001-10-22 Thread DL Neil
Yes it is easier for you. Congratulations! Is it "easier" for the person answering? Is it "easier" for the people reading and deleting irrelevant posts? =dn - Original Message - From: "Harpreet" <[EMAIL PROTECTED]> To: "'DL Neil'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: 22 Octob

RE: [PHP-DB] looped insert

2001-10-22 Thread Rick Emery
Construct your INSERT a piece at a time. Something like: $sql = "INSERT INTO $myanet02 (staffdev,strategies,rules,news,information,policies) VALUES("; for($i=0;$imailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 11:23 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] looped insert Hi everyone

[PHP-DB] Capturing select values from a multliple-select list box

2001-10-22 Thread kimbjork
I have this bit of code where I am presenting the user a mulitiple-select dropdown box in a form as shown below: $county"; } ?> My newbie question is, "How can I capture the values associated with the users' selections from the 'county' box?" Besides wanting to save the

RE: [PHP-DB] Creating a file using php

2001-10-22 Thread Jonathan Hilgeman
DN has a point, though. You shouldn't rely on the mailing list, otherwise you're going to turn out to be a pretty whacked programmer who doesn't know a good portion of the available options and commands. It's a good thing to just browse through the manual from time to time. Most people on here don

RE: [PHP-DB] Creating a file using php

2001-10-22 Thread Harpreet
Blunt: NO!!! Duh Polite: Well its easier to post and get a reply rather then me going and serching fo it.;) regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 12:59 PM To: [EMAI

[PHP-DB] Informix + PHP any gotcha's to watch out for?

2001-10-22 Thread davemacgb
I've been asked to create a B2B web site for on-line ordering. The customer's software runs on SCO OpenServer 5 (UNIX) unfortunately the run-time environment for the software is limited to either its own proprietary database, Informix or Oracle. This means that switch to another database like MyS

Re: [PHP-DB] Creating a file using php

2001-10-22 Thread DL Neil
Harpreet, Blunt: Do you ever check the PHP manual before posting? Polite: XXVI. Filesystem functions http://www.php.net/manual/en/ref.filesystem.php =dn - Original Message - From: "Harpreet" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 22 October 2001 17:34 Subject: [PHP-DB] Cre

[PHP-DB] Creating a file using php

2001-10-22 Thread Harpreet
Is there a command in PHP that can create a textfile and allows writing data to it dynamically? Can someone point me to a tutorial or site . Thanks in advance, help is appreciated. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.ph

[PHP-DB] Notes DB

2001-10-22 Thread Carlos Augusto Abarca
Hello everyone: I have a very urgent request... I´m trying to connetc to a Domino Notes Database writting a script in PHP but I haven´t been able to find any informatiion on this topic. I know that the logical step is to use ODBC conections but the problem is that my client has Domino R5 Web Serv

[PHP-DB] looped insert

2001-10-22 Thread Russ Michell
Hi everyone: I've been fiddling with this all day, and well - if it was working you wouldn't be reading this right now! ;-) My script should take the selections made by users and process them via straightforward MySQL inserts: //Get all table column names, dynamically display them as checkboxe

RE: [PHP-DB] How to write errorhandling??

2001-10-22 Thread Rick Emery
First, that "Failed to Connect" message looks like a database failure to connect message; nothing to do with mail() Second, are you REALLY trying to send header info at line 256? That's pretty far down in a program. Usually, those decsions are made within the first 10 to 20 lines. So, is line 2

RE: [PHP-DB] Check Boxes!

2001-10-22 Thread Rick Emery
Sometimes, PHP becaomes confused when a variable is included in another word, such as you are doing with $i in: if($HTTP_POST_VARS["chkAuthStatus_$i"] = 'on') To avoid this problem, use braces to segregate the PHP variable from the rest of the word: try: if($HTTP_POST_VARS["chkAuthStatus_${i}"

RE: [PHP-DB] variable operators in queries

2001-10-22 Thread Rick Emery
Is the the EXACT code you used? If it is, I can see why it failed. You're trying to assign the text to "sql" not "$sql". sql="SELECT * FROM poeple WHERE age $Date_operator 20"; If, in fact, you are assigning to $sql, then print out $sql to ensure it contains what you expect it to contain.

Re: [PHP-DB] How to write errorhandling??

2001-10-22 Thread Dobromir Velev
Hi, I never said it is impossible to use mail() on a WIN machine - it just needs some additional adjustments of the php configuration file. For those who need more information on the topic check the user contributed notes at http://www.php.net/manual/en/ref.mail.php Regards Dobromir Velev -O

Re: [PHP-DB] How to write errorhandling??

2001-10-22 Thread DL Neil
Luditus/Dobromir, It IS possible to run the mail function on a Win machine - I had a Win2000/IIS(with its own SMTP stub) box running PHP mail happily. Also it is possible to have a Win-with-no-local-SMTP configuration. I have re-jigged my WinNT portable to run the same PHP/Apache script connecti

Re: [PHP-DB] How to write errorhandling??

2001-10-22 Thread Andrey Hristov
That's correct. I've seen a discussion on dev phorum about embeding SMTP code in PHP, but as I remember the final decision was that SMTP code will stay outside of PHP code. -- Andrey Hristov Web Developer Icygen Corporation BUILDING SOLUTIONS http://www.icygen.com On Monday 22 October 2001

Re: [PHP-DB] How to write errorhandling??

2001-10-22 Thread Dobromir Velev
Hi, I see that everybody is looking for the error in the header function - but the error actually is that Luditus is trying to use mail on a Windows box with no SMTP server on it. It is possible to suppress the mail function output using @mail, but it won't fix the problem - if you want to use mai

Re: [PHP-DB] fulltext not for me/alternatives

2001-10-22 Thread Michiel_Lange
first off... how do you know you are a computer geek? to look for s_e_x in your database, and if you can't find it, recompile it *EEEK* :) For the rest, I am afraid, I cannot really help you, as I don't really get the problem at hand...

Re: [PHP-DB] Asigning function values to variables??

2001-10-22 Thread Russ Michell
Not entirley sure what you're trying to do but, if the '.box_header' and '.box_footer' are css classes, then it won't show up in people's text-only email. if not then try removing the second periods '.' so i tlooks like: $body .= "box_header('test')."; $body .= "text"; $body .= "box_footer()."

Re: [PHP-DB] PHP and Oracle

2001-10-22 Thread Michiel_Lange
You use // to comment, that is quite fine, but it could be that I can't see the layout of the file rightly, but when I opened the file it looked like this: // echo (" "; // echo ... etc... that won't work if you want to comment a block out you can much better use this kind of commenting ou