RE: [PHP] mySQL problem

2001-11-02 Thread Jon Snell
The issue here is that you aren't getting an index of Company from that query. It is probably stored under the index of UCASE(Company). Try: $Query = SELECT UCASE(Company) as ucCompany, Icons, ID,...; Then the ucCompany field will contain your capitalized company data. Jon -Original

RE: [PHP] installing php as cgi on linux

2001-07-27 Thread Jon Snell
This is a long shot, but... MSIE has a nasty habit of saving the mime type of a page. If you attempted to load the URL before PHP was set up properly, it won't load until after you closed IE and reopened. -Original Message- From: Richard Kurth [mailto:[EMAIL PROTECTED]] Sent: Friday,

RE: [PHP] deletion of temp files

2001-07-10 Thread Jon Snell
One way to do this is to create a special directory in htdocs reserved only for temporary files. Add the following line to crontab or a user with permissions to delete: 0 * * * * find /usr/local/apache/sitename/htdocs/specialdir/ -cmin +1440 -exec -rm -f {} Every hour this script will delete

RE: [PHP] Password Generator?

2001-04-19 Thread Jon Snell
There is code in the source for NetHack to create pronounceable words. Also, combining words would probably be somewhat easy. A lazy coder could import a unix dictionary file into a MySQL table and do "select word from word order by rand limit 2" and just combine the results. -Original

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-21 Thread Jon Snell
Yes, I would recommend locking your tables before doing this just in case. Another solution would be to create a unique-key based on the bed field and date field. This way you are guaranteed never to double book, and can just check for errors after insert rather than do an additional select

RE: [PHP] Cache Database-driven site

2001-03-12 Thread Jon Snell
There are already some caching packages out there, I'm not sure how they perform with CGI (look into Squid). Having each page check for a cached version of itself sounds like a complicated approach. Another idea is to generate portions of your site as that don't change often from perl scripts,

RE: [PHP] update two frames at once?

2001-03-12 Thread Jon Snell
Doing multiple frames and forms with JavaScript is not really a good idea. Debugging the code for this can become a nightmare... -Original Message- From: Rene Maldonado [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 6:59 PM To: Michael George Cc: [EMAIL PROTECTED] Subject: Re:

RE: [PHP] Grab and print user IP address

2001-03-12 Thread Jon Snell
These are normally already stored as variables in PHP for you. Run the phpinfo(); function and it will display a list of the current variables and values... -Original Message- From: Dream [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 4:00 AM To: [EMAIL PROTECTED] Subject: [PHP]

RE: [PHP] exec as another user

2001-03-07 Thread Jon Snell
It would be a much better idea to set the +s flag on the executable you are trying to run, and make sure it's owned by the other user. -Original Message- From: Henrik Hansen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 1:10 PM To: php general Subject: Re: [PHP] exec as

RE: [PHP] Please Help!!!! - Really BASIC stuff!

2001-03-06 Thread Jon Snell
to insert/select/update to the database the website works with). Jon Snell -Original Message- From: Nick Norton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 3:57 PM To: [EMAIL PROTECTED] Subject: RE: [PHP] Please Help - Really BASIC stuff! Just put the following instead of a l

RE: [PHP] Passing variables to a scripting engine... (like php)

2001-02-15 Thread Jon Snell
It is sent as text to stdin. -Original Message- From: Diego Fulgueira [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 4:45 PM To: Php-General Subject: [PHP] Passing variables to a scripting engine... (like php) Ok. I already posted a question asking how to pass parameters

RE: [PHP] run safe_mysqld from php code *urgent*

2001-02-15 Thread Jon Snell
This is an issue with user permissions. You *could* create a world executable suid script that did executed the command. PHP would then call that. This is dangerous though, and I'd avoid it. -Original Message- From: Student Center [mailto:[EMAIL PROTECTED]] Sent: Thursday, February

RE: [PHP] gethostbyaddr timeout

2001-01-31 Thread Jon Snell
...why do you need to do this? It seems very odd. Jon Snell -Original Message- From: Aaron Gould [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 11:17 AM To: [EMAIL PROTECTED] Subject: [PHP] gethostbyaddr timeout I'm at the end of my rope here... I have a 100,000+ line file

RE: [PHP] Importing MS Access into MySQL?

2001-01-29 Thread Jon Snell
. Jon Snell -Original Message- From: James, Yz [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 3:46 PM To: [EMAIL PROTECTED] Subject: [PHP] Importing MS Access into MySQL? Hey all, I heard somewhere (I think) that it's possible to import a Microsoft Access file (when saved