Re: [PHP-DB] A challenge

2002-07-03 Thread kodrik
On Wednesday 03 July 2002 13:27, you wrote: > ... At least, I found it challenging. Hopefully someone here will find > this a lot easier =) > > I am developing a website wherein customers can log in, enter in the > name and type of their business (rather like the yellow pages.) I have a > da

RE: [PHP-DB] Strange MySQL Query Problem

2002-07-03 Thread Jen Swofford
Could this be as simple as a typo? textfield texfield Jen Swofford [EMAIL PROTECTED] > -Original Message- > From: eat pasta type fasta [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 03, 2002 3:27 PM > To: PHP LIST > Subject: [PHP-DB] Strange MySQL Query Problem > > > I already got s

[PHP-DB] Join on insert???

2002-07-03 Thread Jefferson Cowart
I am writing scripts to load user data into a MySQL database. I have tables in the DB called People and PeopleEmail. The PeopleEmail table stores one email address per record with one of the columns corresponding to the PID of the people table. Is there a way to run a single query that will insert

[PHP-DB] problem getting data from mysql into backend.csv...

2002-07-03 Thread matthew
hello. we are new to this list and new to php so forgive me if this is a dumb question but we are stuck... we are trying to setup the event calendar script that http://www.php.net uses on their front page. The only problem I'm having is getting the information from the mysql database to the

[PHP-DB] PHP with htaccess files

2002-07-03 Thread Larentium
RE: PHP with htaccess files... Has anyone used basic http authentication with htaccess files that reference password files and used PHP scripts that could add new users to the password file? I wanted to use a PHP login page, but most of the site I want to protect is already written in html and

Re: [PHP-DB] Strange MySQL Query Problem

2002-07-03 Thread Martin Clifford
>From your query, it looks as if you are letting the user select the table that they >can query with $pop-up1. Is that correct? If so, do all the available choices of tables have the same column names? Other than that I can't see why this query would fail. Martin >>> eat pasta type fasta <[

[PHP-DB] A challenge

2002-07-03 Thread jonathan
... At least, I found it challenging. Hopefully someone here will find this a lot easier =) I am developing a website wherein customers can log in, enter in the name and type of their business (rather like the yellow pages.) I have a database of all the customers, and each table in the

[PHP-DB] Strange MySQL Query Problem

2002-07-03 Thread eat pasta type fasta
I already got some replies for this but it wasn't it, here is the problem: I have a simple form which queries the database based on 2 pop-up menu choices and keywords entered by the user, it passes on the variables as follows: pop-up1=choice1, pop-up2=choice2, textfield=user specified data the

[PHP-DB] Strange characters from MSSQL

2002-07-03 Thread Tim K
Hi there, Can anybody help me? I'm building a webinterface to an existing MSSQL database. When displaying text from the database, strange characters like ? show up, when I'm supposed to get æ, ø and å (Danish charset). We're talking PHP4 on IIS5, W2K server. The MSSQL server is on a different m

[PHP-DB] system help!

2002-07-03 Thread Thomas \"omega\" Henning
hey all, i have this tt.sql"; $test=system($command); ?> When $command="mysqldump -uroot --password=* iktato intrat2003 "; it works and when $command="mysqldump -uroot --password=* iktato intrat2003 >tt.sql"; it doesn't work. BUT!!! i have made a consol script that runs a linux command fr

[PHP-DB] Date Times stuff

2002-07-03 Thread John Fishworld
Banging my head against a wall with this ! Hope someone can help ! Using MySQL Trying to list cities with events for that month I've correctly (i think) formatted my date to a datetime style for MySQL $month is there chosen one $tosearch = date("Y-$month-d 00:00:00"); And then this is my inq

Re: [PHP-DB] cookies multiple pages

2002-07-03 Thread Terry Romine
just checked and the server is running Apache 1.6.19 and PHP 4.0.6 Terry On Wednesday, July 3, 2002, at 09:52 AM, [EMAIL PROTECTED] wrote: > Trust me this does not work with php 4.2.1 and apache 2.0.39 from what > I am told if you get the cvs for apache 2.0.4 it should but I just down > grad

Re: [PHP-DB] cookies multiple pages

2002-07-03 Thread Khristopher_Klaich
One thing I did find was to look at your php.ini file and see where the session.save_path=/tmp this is now pointing to your server /tmp not the apache directory anymore so you will either have to change the permissions on that folder so apache can write there or make a directory somewhere else

Re: [PHP-DB] cookies multiple pages

2002-07-03 Thread Terry Romine
as in if (!isset($_COOKIE['user_data'])) { setcookie("user_data","",time()+(3600));// set for 6 weeks *24*7*6 } ?? nah.. that doesn't work either. It still creates a new cookie. On Wednesday, July 3, 2002, at 10:05 AM, [EMAIL PROTECTED] wrote: > Is this a

Re: [PHP-DB] cookies multiple pages

2002-07-03 Thread Terry Romine
1) no, the commented setcookie("user_data","",time()+(3600));// set for 6 weeks *24*7*6 I would move the *24*7*6 back into the (3600) to make it so. I just want to test for an hour 2) so maybe this is a problem with the server? I've been tearing my hair out because neither cookie

Re: [PHP-DB] cookies multiple pages

2002-07-03 Thread John Fishworld
Banging my head against a wall with this ! Hope someone can help ! Using MySQL Trying to list cities with events for that month I've correctly (i think) formatted my date to a datetime style for MySQL $month is there chosen one $tosearch = date("Y-$month-d 00:00:00"); And then this is my inqui

[PHP-DB] Re: Changing leters to *

2002-07-03 Thread Mike Germain
Password Field: INPUT TYPE=PASSWORD An INPUT element with `TYPE=PASSWORD' is a text field as above, except that the value is obscured as it is entered. (see also: section Security Considerations). For example: Name: Password: "Bartosz Matosiuk" <[EMAIL PROTECTED]> wrote in message news:[EMAIL

Re: [PHP-DB] cookies multiple pages

2002-07-03 Thread Jeffrey_N_Dyke
Is this a issue with register _globals = off. try referencing it with $_COOKIE['user_data']. Also isn't 3600 only an hour. 60secs * 60mins? i think 6 weeks would be... 151200 60 * 60 * 42days does that work? Jeff

[PHP-DB] cookies multiple pages

2002-07-03 Thread Terry Romine
I'm having a problem with cookies over several pages. I've tried to set them up per the manual, ie: prior to header, and using setcookie('cookiename',$value,time()+3600). The cookie seems to be created fine on the first page, and passed to the second page, but is not maintained when the pages

[PHP-DB] date issue with MsSql - follow up....still a bug?

2002-07-03 Thread Jeffrey_N_Dyke
Hello. I was curious if any one is using PHP4.2x with SQLserver 7(or 2000) and having luck with the datetime type. No matter the datetime in the database PHP 4.1.2 is always returning Feb 06 2036 6:37AM . The insert is correct, its only the select that this happens on. There was a bug report,

Re: [PHP-DB] PDF/FDF Support

2002-07-03 Thread Paul Burney
on 7/2/02 8:20 PM, Jefferson Cowart at [EMAIL PROTECTED] appended the following bits to my mbox: > I'm trying to write a PDF form that people can fill in. I want to then > take the data, store it in my database, and then recall the data, and > display a filled in form with that data. I see two op

[PHP-DB] RE: Refresh after DB Query - Solved

2002-07-03 Thread Hutchins, Richard
Ugh! Thanks, Adam. I knew it would be something stupid. Although I am kind of new (less than 6 months) to PHP, I'm really not that bad with it (IMHO). I really thought I had tried putting the DELETE stuff where you said to put it and it didn't work. However, new day, fresh eyes, your advice...it w

[PHP-DB] Dow name from Dow number

2002-07-03 Thread Alexander
Hello, in PostgreSQL I have this: select date_part('dow', timestamp_name), count(id) from table_name group by date_part('dow',timestamp_name); and I get a record count list grouped by week days. E.g.: ---+-- 0 | 123 1 | 16 2 | 45 ... | 6 | 9 I just want the day's nam

[PHP-DB] Re: Strange MySQL Query Problem

2002-07-03 Thread tatang
> I have a simple form which queries the database based on 2 pop-up menu > choices and keywords entered by the user, > it passes on the variables as follows: > > pop-up1=choice1, pop-up2=choice2, textfield=user specified data use : $pop-up1 = $HTTP_POST_VARS["pop-up1"]; ... each variables yo