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 . '< '; > > So does this echo display anything? It spits out... >1974-01-09< - >4

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

2003-08-09 Thread John W. Holmes
jsWalter wrote: 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 W

[PHP-DB] Re: Conection to MS SQL 2000 from PHP in Linux

2003-08-09 Thread Chris Berlioz
Try reading this on PHP site, documentation here is pretty useful. http://us4.php.net/manual/en/ref.mssql.php Suerte. == "Jean Fernando Ortiz" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi all! > I need to know how I must connect to MS SQL Server 2000 in a Win

Re: [PHP-DB] Sorting issue

2003-08-09 Thread Jeff
Seems like changing the mixed fields back to VARCHAR worked! Thanks again guys! "David T-G" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Sorting issue

2003-08-09 Thread Jeff
kwo isn't sorting properly... actually, I need to retest the lsd column too. "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Jeff wrote: > > >$query = "SELECT kwo, lsd, date, event FROM $gradient_tablename > > $order_by_str $sor

[PHP-DB] Sorting issue

2003-08-09 Thread Jeff
Why would a mysql db think that 55 was greater than 14000. I have several headings that display sql data under them, when you click on the heading, it sorts that section (descending/ascending), but it only seems to be looking at the first two numbers in the one heading. Is there a command that f

RE: [PHP-DB] Sorting issue

2003-08-09 Thread Aaron Wolski
Seeing code might help us. Aaron > -Original Message- > From: Jeff [mailto:[EMAIL PROTECTED] > Sent: August 8, 2003 10:44 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Sorting issue > > Why would a mysql db think that 55 was greater than 14000. > > I have several headings that display

Re: [PHP-DB] Conection to MS SQL 2000 from PHP in Linux

2003-08-09 Thread colbey
Few options.. compile using sybase-ct libraries.. or use something like freeTDS, or install odbc support.. I'd look at using freetds first.. On Thu, 7 Aug 2003, Jean Fernando Ortiz wrote: > Hi all! > I need to know how I must connect to MS SQL Server 2000 in a Win 2000 Server > from my Intern