Re: [PHP] Query bug

2002-03-27 Thread Erik Price
On Wednesday, March 27, 2002, at 04:28 PM, Daniel Ferreira Castro wrote: > This way works, but not the way i would like to. > Because it selects just the fields "nome","id_proj" and "arquivo" from > the > table ALGORITMO, and here my goal is to select those fileds of > ALGORITMO and > ATAS.

Re: [PHP] Query bug

2002-03-27 Thread Daniel Ferreira Castro
This way works, but not the way i would like to. Because it selects just the fields "nome","id_proj" and "arquivo" from the table ALGORITMO, and here my goal is to select those fileds of ALGORITMO and ATAS. "Erik Price" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTE

Re: [PHP] Query bug

2002-03-27 Thread Erik Price
On Wednesday, March 27, 2002, at 04:00 PM, Daniel Ferreira Castro wrote: > I want to select the fields nome,id_proj,arquivo FROM ALGORITMO and > ATAS. But when I use the query below, I receive the error "ERROR 1052: > Column: 'nome' in field list is ambiguous". What is wrong on my query? > >

[PHP] Query bug

2002-03-27 Thread Daniel Ferreira Castro
I have a problem. I have those tables on my database: mysql> use projeto; Database changed mysql> show tables; +---+ | Tables_in_projeto | +---+ | ALGORITMO | | ATAS | | MANUAIS | | PROJETO | | REFERENCIAS | | RELATOR

Re: [PHP] Query bug, what is wrong?

2002-03-08 Thread hugh danaher
ssage - From: "Robert V. Zwink" <[EMAIL PROTECTED]> To: "Daniel F. Castro" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, March 08, 2002 6:22 AM Subject: RE: [PHP] Query bug, what is wrong? > You probably need to wrap the strings you are trying

RE: [PHP] Query bug, what is wrong?

2002-03-08 Thread Robert V. Zwink
ert Zwink http://www.zwink.net/daid.php -Original Message- From: Daniel F. Castro [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 8:29 AM To: [EMAIL PROTECTED] Subject: [PHP] Query bug, what is wrong? Thanks you Daniel Castro -- PHP General Mailing List (http://www.php.ne

Re: [PHP] Query bug, what is wrong?

2002-03-08 Thread Jason Wong
On Friday 08 March 2002 21:56, you wrote: > The error msg is > > You have an error in your SQL syntax near 'ARQUIVO,NULL)' at line 1 > Try entering that query into mysql at the command line. Does it work? -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk /* Mark's Dental-Chair Disco

Re: [PHP] Query bug, what is wrong?

2002-03-08 Thread Daniel F. Castro
The error msg is You have an error in your SQL syntax near 'ARQUIVO,NULL)' at line 1 Daniel Ferreira Castro "Jason Wong" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED]... > On Friday 08 March 2002 21:29, Daniel F. Castro wrote: > > >$qname = $HTTP_POST_VARS['ct_nome'];

Re: [PHP] Query bug, what is wrong?

2002-03-08 Thread Jason Wong
On Friday 08 March 2002 21:29, Daniel F. Castro wrote: > $qname = $HTTP_POST_VARS['ct_nome']; >$qkey = $HTTP_POST_VARS['ct_kw']; >$qdia = $HTTP_POST_VARS['ct_dia']; >$qmes = $HTTP_POST_VARS['ct_mes']; [snip] What's wrong with it? What was the erro

[PHP] Query bug, what is wrong?

2002-03-08 Thread Daniel F. Castro
Thanks you Daniel Castro -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php