[PHP-DB] Trouble with "date" column

2002-01-08 Thread Nally, Tyler G.
Hello, My boss is going through the mysql.com tutorials starting at ... http://www.mysql.com/articles/ddws/12.html ... and currently stuck at ... http://www.mysql.com/articles/ddws/13.html The boss is using phpMyAdmin to access the database, and everything has been working just fine

RE: [PHP-DB] How to insert to DB from txt??? Please help

2002-01-04 Thread Nally, Tyler G.
How about LOAD DATA INFILE 'filename.txt' INTO TABLE Table FIELDS TERMINATED BY ',' < comma delimited for tabs use '\t' LINES TERMINATED BY '\n' < *nix line terminator, for Dos/Win use '\r\n' IGNORE 1 LINES < use if the first line of the file has col. hdrs. (colu

RE: [PHP-DB] Re: parse error

2001-12-13 Thread Nally, Tyler G.
Not sure but if line 358 is... 358>no .. as it says below, then the ">" before the "no" needs a beginnnig to it somehow. It's like a html-tag that's only half baked. -- __ _Tyler Nally / /__ _(_)___ __

RE: [PHP-DB] RE: Getting apache to recognize"index.php"....

2001-12-04 Thread Nally, Tyler G.
Luke M. said: > Find the DIRECTORYINDEX attribute in httpd.conf and add 'index.php' to > the list: > > DIRECTORYINDEX index.html index.php index.wml homepage.html > index.shtml > homepage.shtml index.cgi homepage.cgi index.htm \ Index.html > Homepage.html Index.shtml Homepage.shtml Index.cgi H

RE: [PHP-DB] Re: Alternating rows pulled from database

2001-11-29 Thread Nally, Tyler G.
Not knowing what else is going on here... at the very least your row counting variable is inconsistent. You mention row_count (in the modulus test) and rowcount (in the initialization and incrementation). > -Original Message- > From: MrBaseball34 [mailto:[EMAIL PROTECTED]] > Sent: Thurs

RE: [PHP-DB] Why use MySQL with PHP

2001-11-16 Thread Nally, Tyler G.
Hmm it's not PHP functionality that makes html ugly as shown at validator.w3.org. It's the person's html/php coding ability to avoid coding mistakes. Basically, PHP gives functionality. A part of that functionality is for the php programmer to make correct HTML as output so the

RE: [PHP-DB] Re: UPDATE table Problem

2001-10-18 Thread Nally, Tyler G.
[*NOTE* - I sent this yesterday. Since I didn't receive a copy back from the listprocessor, I assumed that it was lost somewhere along the way. --TGN ] Hmm I'd first put a "or die" clause onto the clause... $updated = mysql_query

RE: [PHP-DB] Sessions and Frames

2001-10-18 Thread Nally, Tyler G.
The manual says... Remember that the header() function must be called before any actual output is sent, either by normal HTML tags blank lines in a file, or from PHP. It is a very common error to read code with include(), or require(), functions, or another file access function, and h

RE: [PHP-DB] wildcard in mysql search with php

2001-10-18 Thread Nally, Tyler G.
> From: Thomas "omega" Henning [mailto:[EMAIL PROTECTED]] > Subject: [PHP-DB] wildcard in mysql search with php > > Is there a way to use wildcards in search in a mySQL db? > e.g. I have a dbase of over 24000 records and i can only search exact > matches is there a way to search something like thi

[PHP-DB] Storing HTML in database

2001-10-02 Thread Nally, Tyler G.
Hello, I'm trying to store HTML (that is cut-n-paste from source) into a textarea field on a web page. As it's submitted to the php page that processes it, the database column that it ends up with strips the "<" and ">" out of the html so that it doesn't end up in the source. Example I ca