Re: [PHP-DB] Cookies

2001-04-25 Thread johndmiller
I believe that the cookie part needs to be sent to the browser before the html. You can put the set cookies any where in the php portion as long as the first thing you send is the cookie stuff setcookie.. html header info... html not html header info. setcookie html.. Hopes

[PHP-DB] MySql select and insert

2001-04-25 Thread johndmiller
Ok here is my problem. I have this database and the key is comprised of two fields, filename and path to file. When I read based on this key, I get 0 records found. When I insert the same record, it will say that the key already exists.(which id does). Why can't MySql findthe record. Also

Re: [PHP-DB] Variable passing

2001-04-24 Thread johndmiller
Use sessions. This will store the values on the server rather than passing them back and forth. Lots less typing too. On Tue, 24 Apr 2001, Johannes Janson wrote: You can output the passed varibles from the previous page in an input type=hidden in the form of the following page. Johannes

[PHP-DB] trouble reading a database (fwd)

2001-04-23 Thread johndmiller
Below is the output and code for my problem. When the database gets read, it returns 0 rows. When it writes, it says it can't because of duplicate entry. FLD_FileName and FDL_Path are the Primary key. Two questions, what I am doing wrong and is there a better way to create a string of text

[PHP-DB] RE: [PHP] trouble reading a database (fwd)

2001-04-23 Thread johndmiller
-- Forwarded message -- Date: Mon, 23 Apr 2001 20:19:57 -0500 (CDT) From: johndmiller [EMAIL PROTECTED] To: Jason Murray [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: [PHP] trouble reading a database (fwd) Thanks for the pointer about ' vs . I have changed my code

[PHP-DB] db read

2001-04-23 Thread johndmiller
I am new a database stuff. I am using mysql 4.0.1 with php on RH7.0. I am setting up a db with three fields with no-one field being unique. Do I have to have a unique field? The purpose of this db is to store a word, name of a file, and path to the file. My plan is to use a where clause, but I

[PHP-DB] trouble reading a database

2001-04-22 Thread johndmiller
Below is the output and code for my problem. When the database gets read, it returns 0 rows. When it writes, it says it can't because of duplicate entry. FLD_FileName and FDL_Path are the Primary key. Two questions, what I am doing wrong and is there a better way to create a string of text

[PHP-DB] can't connect to mysql

2001-04-19 Thread johndmiller
I just looked at my mysql.sock file and it has a length of zero. Is this the right size, I don't think it is. If not, do I have to reinstall MySQL to get the file back or can I get it from somewhere else. FYI: running RH7.0, Apache Thanks, John -- PHP Database Mailing List

[PHP-DB] MySql won't connect

2001-04-18 Thread johndmiller
I know that the pages that I am using worked. I created them, then had to reload my OS. I saved everything before erasing the HD. I have restored the files but now I get a warning message that says MySQL Connection Failed: Can't connect to local MySQL server through socket The mysql.sock