.
not exactly this way but something like this:
$data = array(
'people' = array('lamp', 'lists', 1, '2008-12-12'),
'organization' = array(56, 'Lamp List', 'web'),
'addresses' = array('123 Main St.', 'Toon Town', 'NY', '12345')
}
thanks for any help.
-afan
From: Andy Shellam andy-li...@networkmail.eu
To: Lamp Lists lamp.li...@yahoo.com
Cc: mysql@lists.mysql.com
Sent: Wednesday, December 17, 2008 2:29:08 PM
Subject: Re: need help with query...
Hi Afan
Why not prefix your field names with the table name?
select
From: Andy Shellam andy-li...@networkmail.eu
To: Lamp Lists lamp.li...@yahoo.com
Cc: mysql@lists.mysql.com
Sent: Wednesday, December 17, 2008 2:48:31 PM
Subject: Re: need help with query...
Hi,
Hi Andy,
the reason I can't use this because fields (columns
hi,
I would like to get your opinions regarding which query you think is better
solution and, of course - why.
I have (very simplified example) 3 tables: orders, members and addresses
I need to show order info for specific order_id,
solution 1:
select ordered_by, order_date, payment_method,
- Original Message
From: John Hicks [EMAIL PROTECTED]
To: Lamp Lists [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, July 8, 2008 11:20:16 AM
Subject: Re: which query solution is better?
Lamp Lists wrote:
hi,
I would like to get your opinions regarding which query you
hi,
I need to change ft_min_word_len fro 4 to 3. the
proces is very well explained on mysql.com
though, when open /etc/my.conf can't find the
ft_min_word_len line?
when check is there:
mysql show variables like 'ft_min_word_len'
ft_min_word_len4
am I looking at the wrong file or something?
Thanks.
Though, I added, repair table, restarted mysql - and
the same
:(
-ll
--- Warren Young [EMAIL PROTECTED] wrote:
Lamp Lists wrote:
I need to change ft_min_word_len fro 4 to 3. the
proces is very well explained on mysql.com
though, when open /etc/my.conf can't find
hi,
I created table tasks
create table tasks(
task_id, int(4) not null primary key,
task text not null,
resolution text not null,
fulltext (task, resolution)
)engine=myisam
when I run
seect * from tasks match(task,resolution)
against('certain service' in boolean mode)
I would get one record
--- Lamp Lists [EMAIL PROTECTED] wrote:
hi,
I created table tasks
create table tasks(
task_id, int(4) not null primary key,
task text not null,
resolution text not null,
fulltext (task, resolution)
)engine=myisam
when I run
seect * from tasks match(task,resolution)
against
--- Lamp Lists [EMAIL PROTECTED] wrote:
--- Lamp Lists [EMAIL PROTECTED] wrote:
hi,
I created table tasks
create table tasks(
task_id, int(4) not null primary key,
task text not null,
resolution text not null,
fulltext (task, resolution)
)engine=myisam
when I run
hi,
I have table, something like:
create table example (
ex_id integer(8) not null auto_increment primary key,
ex_col1 int(8) null,
ex_col2 int(4) not null,
index(ex_col1),
index(ex_col2)
)engine=myisam;
ex_col1 and ex_col2 are indexed
11 matches
Mail list logo