Re: SCO Openserver Install

2004-07-18 Thread Boyd Lynn Gerber
On Sun, 18 Jul 2004, Jim Ginn wrote: > Not sure why we can get PHP-MySQL functions working? > > We're using PHP: > > php4/4.3.6a (SCO build) > > Are you using same build of PHP? I am using the one that is in MP3/UP3 # php --version PHP 4.3.6 (cli) (built: May 12 2004 21:48:27) Copyright (c)

Re: Commas Missing.

2004-07-18 Thread Braulio Lumbreras
Thanks, Matthew. It worked. Braulio. "Matthew McNicol" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > I would suggest formatting the number at the presentation stage, once > the information is retrieved from the MySQL database. e.g. using PHP see: > http://www.php.net/manual

Re: SCO Openserver Install

2004-07-18 Thread Jim Ginn
Boyd Lyn Gerber: Not sure why we can get PHP-MySQL functions working? We're using PHP: php4/4.3.6a (SCO build) Are you using same build of PHP? Thanks! Jim > On Sun, 18 Jul 2004, Jim Ginn wrote: >> First - Thanks again for your help. > > Your welcome. > >> Second - Installed SCO release su

building mysql from 4.1.3 source

2004-07-18 Thread bruce
hi... is there any way of building the separate mysql rpms from the mysql 4.1.3 src rpm. i know you can do a rpmbuild --rebuild foo.src.rpm. but this gives you all the underlying rpms. i'm curious as to whether or not i could more or less pull/build a given package, and if so, how??? basiclly, i'

how to intersect resulting sets form sql query

2004-07-18 Thread L a n a
Hello, I'm trying to find a resulting set for searching two keywords, like: Select * from table where filed_a like '%keyword1%' OR field_b like '%keyword1%' INTERSECT (Select * from table where filed_a like '%keyword2%' OR field_b like '%keyword2%'). This statement gives an error in syntax. What

Re: how to select last date by current time?

2004-07-18 Thread Louie Miranda
thanks! this is what i had been looking for. the last example you had, is not working on my mysql version. btw, im using 4.0. does not have nested select still. thanks, Louie - Original Message - From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Fri, 16 Jul 2004 09:11:39 -0400 Subject:

Fw: NOKIA OFFER - Must Read

2004-07-18 Thread npk Systems
- Original Message - From: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL

building php5.0 as an apache module, with mysqli functionality

2004-07-18 Thread bruce
hi... this is cross posted to a number of lists as it seems to touch on all the apps... that said. i'm trying to build the PHP-5.0 version to run as an Apache mod. i need to work with mysql to get the "mysqli" function. i have rh8.0 linux. i'm using -httpd-2.0.50 (built from both rpm/src) -php-5

Re: SCO Openserver Install

2004-07-18 Thread Boyd Lynn Gerber
On Sun, 18 Jul 2004, Jim Ginn wrote: > First - Thanks again for your help. Your welcome. > Second - Installed SCO release supplements, Apache 1.3.31, PHP Version > 4.3.6 (--with-mysql=shared), and MySQL 4.1.3-beta. > > MySQL is running fine. PHP is recognized Apache. But PHP is not able to >

Re: SCO Openserver Install

2004-07-18 Thread Jim Ginn
Boyd Lynn Gerber: First - Thanks again for your help. Second - Installed SCO release supplements, Apache 1.3.31, PHP Version 4.3.6 (--with-mysql=shared), and MySQL 4.1.3-beta. MySQL is running fine. PHP is recognized Apache. But PHP is not able to find the the MySQL shared libraries. Simple

iterative "load data" crashes. - table limit??

2004-07-18 Thread Michaell Taylor
I have about 1,000 flat files that I have loading into a mysql table. The load is done through a shell script that iterates over each file, loading sequentially.That is, I inititate a "load data local ..." statement on each of the 1,000 files. The total size of the completed data base i

Re: Creating a Composite Index

2004-07-18 Thread Wesley Furgiuele
David: I believe you mentioned it in a previous thread, but I forget what kind of field NameMam is. It's important because you might be required to give that key part in your index a length. Also, I'm assuming that this index is on a unique identifier field. If it's not, then just substitute th

Creating a Composite Index

2004-07-18 Thread David Blomstrom
I'm trying to create my first composite index and need some help. The MySQL Manual at http://dev.mysql.com/doc/mysql/en/CREATE_INDEX.html offers these directions: CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [index_type] ON tbl_name (index_col_name,...) index_col_name: col_name [(l

Re: Commas Missing.

2004-07-18 Thread Matthew McNicol
I would suggest formatting the number at the presentation stage, once the information is retrieved from the MySQL database. e.g. using PHP see: http://www.php.net/manual/en/function.number-format.php MySQL does not store numbers with a currency symbol or with the "thousands group" separator. B