[PHP-DB] Re: help with PEAR::DB vs mysql_connect - solved

2003-09-19 Thread jsWalter
My include path was messed up AND the sys admin changed the password on me! Thanks anyway. walter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] help with PEAR::DB vs mysql_connect

2003-09-19 Thread jsWalter
I have 2 seperate scripts. On useing PEAR::DB and the other using mysql_connect. mysql_connect works and PEAR::DB does not. This is what I have... the 'mysql_connect' script... $db_host = 'myHost'; $db_user = 'myUser'; $db_pass = 'myPass'; $db_name = 'myDB'; $link = mysql_connec

[PHP-DB] Re: [SPAM?] [PHP-DB] Re: Approved

2003-09-08 Thread jsWalter
This is the soBig virus! Do not open attachement! Do not open attachement! Some SMTP servers bounce entire messages, even with attachements! I hope the admin in here can remove this message from the server and NNTP server so other do not get catch opening this! Walter -- PHP Database Mailing

[PHP-DB] Re: [SPAM?] [PHP-DB] Re: Approved - WARNING!!!!

2003-09-08 Thread jsWalter
This is the soBig virus! Do not open attachement! Do not open attachement! Some SMTP servers bounce entire messages, even with attachements! I hope the admin in here can remove this message from the server and NNTP server so other do not get catch opening this! Walter -- PHP Database Mailing

Re: [PHP-DB] another PHP Sql question...

2003-08-29 Thread jsWalter
> "Boaz Yahav" <[EMAIL PROTECTED]> wrote in message > I'm not sure i understand the problem. > a,c,e come from one query result and b,d,f from another? No, they all come from the same table, but the same field name but from different rows of the database. > If it's all from the same query why n

Re: [PHP-DB] [SPAM?] [PHP-DB] Re: That movie

2003-08-29 Thread jsWalter
This is the SoBig.F virus. It hijacks a random email address form an infected persons phone book, uses that address as the SENDER, and then proceeds to mail out copies of itself to everyone in he infected persons phone book. I've had my address hijacked twice now. So, be warned, clean your syste

[PHP-DB] Re: db connection php & mssql & win2k

2003-08-29 Thread jsWalter
This is what I use... // Pull in DB PEAR Collection require_once 'DB.php'; // What kind of database server are we connecting too? $db_type = 'mysql'; // local connectivity data $db_host = 'localhost'; $db_user = 'dbUsername $db_pass = 'dbUserPW'; $db_name = 'dbName'; // Data Source Name: This

[PHP-DB] another PHP Sql question...

2003-08-29 Thread jsWalter
I am querying a database just fine. Getting back what I expect, just fine. But now I've been thrown a wrench in the form of double row display. my client wants... a b c d e f ... Well, I've reached the end on my PHP/SQL knowledge (which really isn't all that far!) Right n

Re: [PHP-DB] Re: newbie lost on data import... part 2

2003-08-14 Thread jsWalter
"John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > jsWalter wrote: > What kind of columns are you inserting these values into? eps_id int(11)Yes 0 eps_name varchar(100) Yes NULL eps_num int(11) Yes NULL eps_air_dat

[PHP-DB] Re: newbie lost on data import... part 3

2003-08-14 Thread jsWalter
OK, now I am really sure it has to do with the vars I defined from my text file... Once I have the text file open, I'm looping through it... // pull RETURN off the end $trimmed = rtrim($lines[$x]); // Pull apart array element list($strDate,$strNum,$strName) = explode ("\t", $trimmed); // M

[PHP-DB] newbie lost on data import...

2003-08-14 Thread jsWalter
I have a 1400 line text file. TAB delimited. 1974-01-13 8 Cold Storage 3 fields. nothing large or complicated. I massaged the data to be in this format thinking it would make the import easier. I can open the file and drop it into an array just fine. I can EXPLODE each array item into it'

[PHP-DB] Re: newbie lost on data import... part 2

2003-08-14 Thread jsWalter
This SQL is generated by my script... INSERT INTO cbs_eps ( eps_id , eps_name , eps_num , eps_air_date ) VALUES ( '5','No Hiding Place','5','1974-01-10'); 'eps_id' is generated from the index ($x) of the array loop the others are retrieved from the tab delimted text file When run from the

[PHP-DB] Re: newbie lost on data import - solved

2003-08-11 Thread jsWalter
It seems that my text file was a UNICODE text file I have no idea how that happened as this was exported from Excel. So, anyway, now I know to check the file format before I spend over 100 hours trying to figure out why I could not INSERT to a database. Thanks to all who offered help, though

Re: [PHP-DB] Re: newbie lost on data import... part 3

2003-08-09 Thread jsWalter
"John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > jsWalter wrote: > > // Spit it out to double check what I've got > > echo '>' . $strDate . '< - >' . $strNum . '< - >' . $strName

Re: [PHP-DB] PHP - Apache config problem

2003-07-14 Thread jsWalter
> I dug around in the install.txt file in PHP, and found that php4ts.dll needs to > be relocated to either where apache.exe resides, where > php4apache.dll resides, or in the windows system directory. All now works as > expected. I actually have all my PHP-centric DLLs in... G:\etc\php I've

Re: [PHP-DB] php.ini

2003-07-06 Thread jsWalter
My understanding is the location PHP looks for the php.ini is dependant on the OS and what %SYSTEMROOT% is set to. This is what I have gleemed from my reading on this, as I had the same issue. walter "Russell Griechen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > i found that

[PHP-DB] Re: fatal error with DB.php - solution

2003-07-06 Thread jsWalter
OK, I solved it. It seems that I **HAVE TO**, **MUST**, **NO CHOICE** place my php.ini in C:\WINNT (for NT and 2k) or PHP will not find it. This is a hardcoded path done at compile time. So, since no ini file, PHP was running on default values, thus it could not find DB.php since the default path

[PHP-DB] Re: fatal error with DB.php

2003-07-05 Thread jsWalter
OK, I solved it. It seems that I **HAVE TO**, **MUST**, **NO CHOICE** place my php.ini in C:\WINNT (for NT and 2k) or PHP will not find it. This is a hardcoded path done at compile time. So, since no ini file, PHP was running on default values, thus it could not find DB.php since the default path

[PHP-DB] Re: fatal error with DB.php

2003-07-04 Thread jsWalter
"Pete Morganic" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > edit the php.ini file and change the include paths to being where your > isntallation is ; Thanks Pete for the idea, but I should give you what I had in my INI... That was the first thing I did... include_path =

[PHP-DB] fatal error with DB.php

2003-07-03 Thread jsWalter
I am trying to use DB.php, but I am getting htis error... Fatal error: main(): Failed opening required 'DB.php' (include_path='.;c:\php4\pear') I can't find this path defined *anywhere* I don't have PHP installed there. How can I "fix" this include path issue. [besides placing the PEARS direct

[PHP-DB] guidance for a rooky on a database class

2003-07-02 Thread jsWalter
I "borrowed" the database class definition (see below) from the PHP docs [http://www.php.net/mysql_close]. I've been reading (and reading, and reading) about '.htaccess' and 'mysql.default_host' and what to set and how to set; or at least I'm trying to read and understand. It is my understanding

[PHP-DB] Re: PHP DB Interaction with Javascript?

2003-06-30 Thread jsWalter
"Aaron Wolski" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi All, > > Trying to get my head around something and want to know if it's possible > first. > > Can PHP and Javascript interact to the point of PHP querying a DB to > find out what records are in use as a variable for an