[PHP-WIN] SQL syntax question

2005-01-10 Thread Anne Shroeder
Not sure if this is the right list to post this to or not -- I'm having a problem with getting a MySQL query to work. I need to do two things: (1) multiply the value of x*y (and thus have to do a group by) from fields in one table, AND (2) do a lookup of the name value in another table for a fore

[PHP-WIN] PHP-based survey software?

2004-12-20 Thread Anne Shroeder
Does anyone have recommendations of specific OS software they have used for constructing surveys? I've been using www.votations.com but it's not all that satisfactory and my boss wants something that will reside on our server and not look third party. I've looked through hotscripts but it's alway

[PHP-WIN] Recommended PHP search engine?

2004-11-08 Thread Anne Shroeder
I'm hoping I can get some recommendations for a search engine to implement on my site - actually, I have two needs: (1) Site 1: Linux-based, 10,000+ page site, currently on shared server (no root access) but moving to dedicated server within 2 months. Very little-no need for searching through da

[PHP-WIN] Variables not retaining values

2004-11-06 Thread Anne Shroeder
A very kind soul helped me a few months back with the problem of variables not being passed through forms (due to a setting in php.ini that the web hosting service will not change). Solution was to refer to the variable in the receiving page as $_POST["variablename"] That worked great! But now

[PHP-WIN] Server-level redirect?

2004-11-05 Thread Anne Shroeder
I'm converting an entire site from .html and .shtml files to .php. Unfortunately a lot of the internal pages have been bookmarked by users, and so what I'd like to do is have a script that checks for the existence of a .php file with the same name (e.g. the file used to be contacts.shtml and now it

[PHP-WIN] Contract: protecting code or not?

2004-10-05 Thread Anne Shroeder
I just started a project for which I need to do both database design and some original programming work. My client would like to draw up an agreement that specifies what usage is permissable for the code I develop. Apparently one of the staff people thought that if the program is very cool (it had

[PHP-WIN] Commas conundrum

2004-10-01 Thread Anne Shroeder
I'm trying to import a .csv file into a table. One of the columns of the .csv file looks like this: Manila, Philippines. I want this data to go into one field: "address" When I do the import with stripslashes (magic_quotes_gpc is turned on) it does this: insert into helpdesk values( '0', '"Ma

[PHP-WIN] Which PHP survey?

2004-08-26 Thread Anne Shroeder
http://php.resourceindex.com/Complete_Scripts/Survey_and_Voting/ I need to create a survey that has: - radio button answers - checkbox answers - matrix with radio button answers, and - free form text answers I also need to be able to give the administrator of the survey the ability to sort th

[PHP-WIN] Mail functions?

2004-08-12 Thread Anne Shroeder
Alas, I cannot use the mail() function on Windows. Someone told me about this: http://www.phpguru.org/static/mime.mail.html but attempts to get it to work have been futile. Does anyone else have a good and straightforward solution for sending mail from a web page (results from a form). Nothing

[PHP-WIN] Variables not passed through form

2004-08-09 Thread Anne Shroeder
I've always used PHP on *Nix platforms. So I'm assuming that this is a windows issue. Here is identical code (1) on an MS server: http://www.cgapdirect.org/annes/ProductCosting/contribute.php (2) on a Linux sever: http://www.language-works.com/cgap/contribute.php The form variable values are dis