starting point for finding that mistake Baron! :)
*knocks head against wall repeatedly*
On 10/30/07 5:09 PM, "Baron Schwartz" <[EMAIL PROTECTED]> wrote:
> Mike,
>
> Mike Morton wrote:
>> OK - I am at a total loss here :)
>>
>> We have added an addi
>
> 860.674.8796 / FAX: 860.674.8341
>
> www.the-infoshop.com
> www.giiexpress.com
> www.etudes-marche.com
>
>> -Original Message-
>> From: Mike Morton [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, October 30, 2007 9:56 AM
>> To: Jerry Schw
rtz
> The Infoshop by Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: 860.674.8341
>
> www.the-infoshop.com
> www.giiexpress.com
> www.etudes-marche.com
>
>> -Original Message-
>> Fro
- which by my thought process should be the most
relevant of all returns?
Any thoughts on this? The term "vic" used in this case is the search string
submitted by the user.
You can see the search in action at
http://www.tienda.com/support/search.html
--
Cheers
Mike Morton
(in my opinion) an unnecessary step that could be handled
at the database query
Thanks!
Sample query:
Select * from development order by status
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED
ion` varchar(100) default NULL,
`english` text,
`spanish` text,
`active` char(1) default 'n',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7096 ;
--
Cheers
Mike Morton
*
* Tel
;Ham" probably is not being indexed. You will
> need to change the minimum word length. See
> http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html
>
> Mike
> (P.S. Send me a free ham while you're at it.)
>
>
> At 02:02 PM 1/31/2007, Mike Morton
rk closely with (pay) someone with the knowledge and
expertise to assist in this. (using PHP)
TIA - hope someone can help!
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
***
ere
either...
Any suggestions?
TIA!
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
"Indeed, it would not be an exaggeration to describe the history of the
co
rong here, but is there a way to accomplish this
logic using an if statement in the where statement?
TIA!
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
"Indeed,
; the consol?
> \. latest_distribution.sql
>
>
> -Original Message-
> From: Mike Morton
> To: [EMAIL PROTECTED]
> Sent: 8/26/04 12:05 PM
> Subject: Mysql command line queries not working
>
> I know the subject is not totally descriptive of the problem, but:
>
&
ted without comments, as removing them
every time there is a new dump will be tedious to say the least...
3. Am I a total idiot and have missed something dead simple?
TIA!
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTEC
004-04-01' and '2004-04-31' and title='33329' group by
date_format(hit_date,"%Y-$m-%d")
Or something along those lines?
Tia!
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
*
ios where the
> normal connection closure may be skipped...
>
> My $0.02...
>
> Dan Greene
>
>
>
>> -Original Message-
>> From: Mike Morton [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, January 06, 2004 2:15 PM
>> To: [EMAIL PROTECTED]
>
think of anything else that I can pass on, if anyone has any
suggestions or ideas I would appreciate it as I am plumb out of them! :)
TIA
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
*
Is anyone aware of international standards for field lengths for commonly
used database fields?
I.e
Firstname
Lastname
Address
City
State
Etc
The basic contact information for a user...?
If anyone knows of a standard, please email me a link or reference to it.
Thanks :)
--
Cheers
Mike
ur insert queries
> instead.
>
> or read about the TIMESTAMP type, but I guess that's too much precision since
> you only wanted the date, not the time.
> http://www.mysql.com/doc/en/DATETIME.html
>
> Mike
>
> On Thursday 13 November 2003 16.15, Mike Morton wrote:
&
TIA! :)
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
"Indeed, it would not be an exaggeration to describe the history of the
computer industry for the past d
yone know of any better, or equal deals out there that also allow
> shell access?
>
> Thanks very much in advance for your help.
>
> best,
>
> Matthew Gold
>
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EM
d)
> WHERE affiliate_id='a280' AND afs.stat_date BETWEEN '2003-01-01' AND
> '2003-09-31'
> GROUP BY afs.stat_date
>
> Hope that helps.
>
> Matt
>
>
> - Original Message -
> From: "Mike Morton" <[EMAIL PROT
d)
> WHERE affiliate_id='a280' AND afs.stat_date BETWEEN '2003-01-01' AND
> '2003-09-31'
> GROUP BY afs.stat_date
>
> Hope that helps.
>
> Matt
>
>
> - Original Message -
> From: "Mike Morton" <[EMAIL PROT
t was a bit clearer
Is it possible to return results like this, and if so, what is wrong with my
query?
TIA!
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
***
Thanks to everyone that replied on and off list - off to the group by docs
;)
On 8/28/03 5:09 PM, "William R. Mussatto" <[EMAIL PROTECTED]> wrote:
> Mike Morton said:
>> Hey y'all - I have been at this too long today - this is driving me
>> nuts!
>>
t
ideally I would like to do it in one query. If this is possible to do - how?
TIA!
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
"Indeed, it would not
help/advice on how to put this into one query so I only have to loop through
a result set once without doing all sorts of other connections.
As you can see I am using MYSQL 3 - so no union queries - and I cannot
upgrade the database since it is on
>
>>
>> Date: Thu, 26 Jun 2003 18:02:23 +
>> To: [EMAIL PROTECTED]
>> From: Syamsul Arifien
>> Subject: Help me pls
>>
>> Hi ...
>> I hv problem...
>> I can't conec to my MysqlSvr with mysql_connect() in my php script..
>>
e member id is a
>> specific number. I.e. Something like:
>>
>> Select count(*) from orders,old_orders where orders.member_id='2' or
>> old_orders.member_id='2';
>>
>> The problem is the above returns 3 rows, the two tables comb
eone point me in the
right direction?
TIA
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
"Indeed, it would not be an exaggeration to describe the history of the
28 matches
Mail list logo
