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.
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
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?
>
>
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
You probably need to wrap the strings you are trying to input with quotation
marks.
Try modifying this line (add \") :
$query = "INSERT INTO projeto (nome,setor,arquivo,status) VALUES
(\"$qname\",\"$qdes\",\"$qFILE\",'ok')";
Robert Zwink
http://www.zwink.net/daid.php
-Original Message
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
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'];
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
8 matches
Mail list logo