Mensagem sobre o tópico
COMPARAÇÂO de $ nãso funfa
Received: by 10.100.248.4 with SMTP id v4mr1294803anh.16.1246649083444;
Fri, 03 Jul 2009 12:24:43 -0700 (PDT)
Return-Path: <renat...@gmail.com>
Received: from mail-gx0-f221.google.com (mail-gx0-f221.google.com [209.85.217.221])
by gmr-mx.google.com with ESMTP id 21si312555yxe.4.2009.07.03.12.24.42;
Fri, 03 Jul 2009 12:24:42 -0700 (PDT)
Received-SPF: pass (google.com: domain of renat...@gmail.com designates 209.85.217.221 as permitted sender) client-ip=209.85.217.221;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of renat...@gmail.com designates 209.85.217.221 as permitted sender) smtp.mail=renat...@gmail.com; dkim=pass (test mode) header...@gmail.com
Received: by mail-gx0-f221.google.com with SMTP id 21so1609014gxk.3
for <listaphp@googlegroups.com>; Fri, 03 Jul 2009 12:24:42 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=gamma;
h=domainkey-signature:mime-version:received:in-reply-to:references
:date:message-id:subject:from:to:content-type;
bh=yJ/FUkCXu0XcWfyfmaz3VsP0tXzDtfYxwcS2Jt/mpr0=;
b=t+hYlx6kx+Hc01lO4nx5ufEmol1PQ/PZ5IZo9vY5/vz8fi+l5eXlLTKRrp1XXCm9+P
L6Gk/J1zOFz5etPGQQfamVrtJxo9SemflJqGd+5bWmhcnn9hpkCrlGM1F0uIRsiLSTAq
1N05jGuRnOK4K3CmIKoL9BO4yxKJLZG4ExGrw=
DomainKey-Signature: a=rsa-sha1; c=nofws;
d=gmail.com; s=gamma;
h=mime-version:in-reply-to:references:date:message-id:subject:from:to
:content-type;
b=Tz/NBbJ/01J5zQQbg/UvGnsAfq+VZHIUFCWkUy/mqRwbDYk3H93qWZ7AjiaPx67NLv
+dGkVGGzjSO64e6zCKY8WOiFrDt9B6+XJnSGdXEzddZjUZT+Q+rp1/vrmWEb+xZ8tCvU
RDsodbGNS+E1j+tQZCLjku5imCO/Qy/p8gTZ4=
Mime-Version: 1.0
Content-Type: multipart/alternative;
boundary="0016361643459eee2b046dd21b73"
Received: by 10.90.54.6 with SMTP id c6mr1330875aga.29.1246649080802; Fri, 03
Jul 2009 12:24:40 -0700 (PDT)
In-Reply-To: <bd28f7ca-63dc-4a86-873d-572beffcc950@y9g2000yqg.googlegroups.com>
References: <bd28f7ca-63dc-4a86-873d-572beffcc950@y9g2000yqg.googlegroups.com>
Date: Fri, 3 Jul 2009 16:24:40 -0300
Message-ID: <3538d9520907031224r17f71317s3608ad4d73f5a...@mail.gmail.com>
Subject: =?ISO-8859-1?Q?Re=3A_=5B_PHP_=2D_Google_=5D_COMPARA=C7=C2O_de_=24_n=E3so_funfa?=
From: Renato de Freitas Freire <renat...@gmail.com>
To: listaphp@googlegroups.com
--0016361643459eee2b046dd21b73
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
"Te=F3rica mente meu script esta certo mas s=F3 num funciona, pode ajudar??=
"
hehehe.. se teoricamente estivesse certo, estaria funcionando hehehe...
brincadeiras a parte...
o que est=E1 retornando nos seus debugs?
tipo.. oq q essa linha retorna? echo "<br> -> ".$query."<br><br>";
pra vc comparar as datas no mysql, elas tem q estar no formado correto, que
seria 'YYYY-MM-DD'
se for datetime 'YYY-MM-DD HH:MM:SS'
--
Renato de Freitas Freire
ren...@morfer.org
On Fri, Jul 3, 2009 at 4:18 PM, Renato Mendes <renatoc...@gmail.com> wrote:
>
> Fala ai galera tipo tenho uma consulta a bd q recebe datas para
> atualiza=E7=E3o de dados
>
> mas tipo q c caso data1 for > q data2 ele n=E3o atualiza.
>
> Te=F3rica mente meu script esta certo mas s=F3 num funciona, pode ajudar?=
?
>
>
> for ($i!=3D0;$i<sizeof($professorSenha);$i++){
> if ($professorSenha[$i]["SENHAPROFESSOR"] !=3D
> $professorSenha[$i]
> ["SENHAPROFESSOR_WEB"] && $professorSenha[$i]["SENHAPROFESSOR_WEB"] !=3D
> "" ){
> $query =3D "UPDATE ".$franquia."_ts_professores "=
;
> $query .=3D "SET senhaprofessor =3D
> '".$professorSenha[$i]
> ["SENHAPROFESSOR_WEB"]."', data_alteracao =3D '".$professorSenha[$i]
> ["DATA_ALTERACAO_WEB"]."' ";
>
> $query .=3D "WHERE codprofessor =3D
> '".$professorSenha[$i]
> ["CODPROFESSOR"]."' ";
> $query .=3D "AND data_alteracao <=3D
> '".$professorSenha[$i]
> ["DATA_ALTERACAO_WEB"]."' ";
> echo "<br> -> ".$query."<br><br>";
>
> var_dump($professorSenha[$i]["DATA_ALTERACAO_WEB"]=
);
> $banco->query($query); //Atera=E7=E3o feita 15/05=
/09
>
>
> echo (mysql_query($query)) ? "" : "erro";
> }
> }
>
>
> valeu
> >
>
--0016361643459eee2b046dd21b73
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<div>"Te=F3rica mente meu script esta certo mas s=F3 num funciona, pod=
e ajudar??"</div><div>hehehe.. se teoricamente estivesse certo, estari=
a funcionando hehehe...</div><div><br></div><div>brincadeiras a parte...</d=
iv>
<div><br></div><div>o que est=E1 retornando nos seus debugs?</div><div><br>=
</div><div>tipo.. oq q essa linha retorna?=A0<span class=3D"Apple-style-spa=
n" style=3D"border-collapse: collapse; ">echo "<br> -> "=
.$query."<br><br>";</span></div>
<div><span class=3D"Apple-style-span" style=3D"border-collapse: collapse;">=
<br></span></div><div><span class=3D"Apple-style-span" style=3D"border-coll=
apse: collapse;">pra vc comparar as datas no mysql, elas tem q estar no for=
mado correto, que seria 'YYYY-MM-DD'</span></div>
<div><span class=3D"Apple-style-span" style=3D"border-collapse: collapse;">=
se for datetime 'YYY-MM-DD HH:MM:SS'</span></div><div><span class=
=3D"Apple-style-span" style=3D"border-collapse: collapse;"><br></span></div=
><div>
<br></div><div>--</div><div>Renato de Freitas Freire</div><a href=3D"mailto=
:ren...@morfer.org">ren...@morfer.org</a><br>
<br><br><div class=3D"gmail_quote">On Fri, Jul 3, 2009 at 4:18 PM, Renato M=
endes <span dir=3D"ltr"><<a href=3D"mailto:renatoc...@gmail.com">renatoc=
c...@gmail.com</a>></span> wrote:<br><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
Fala ai galera tipo tenho uma consulta a bd q recebe datas para<br>
atualiza=E7=E3o de dados<br>
<br>
mas tipo q c caso data1 for > q data2 ele n=E3o atualiza.<br>
<br>
Te=F3rica mente meu script esta certo mas s=F3 num funciona, pode ajudar??<=
br>
<br>
<br>
for ($i!=3D0;$i<sizeof($professorSenha);$i++){<br>
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0if ($professorSenha[$i]["SENHAPROFESSO=
R"] !=3D $professorSenha[$i]<br>
["SENHAPROFESSOR_WEB"] && $professorSenha[$i]["SENHA=
PROFESSOR_WEB"] !=3D<br>
"" =A0){<br>
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0$query =A0=3D "UPDATE =
".$franquia."_ts_professores ";<br>
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0$query .=3D "SET senha=
professor =3D '".$professorSenha[$i]<br>
["SENHAPROFESSOR_WEB"]."', data_alteracao =3D '"=
;.$professorSenha[$i]<br>
["DATA_ALTERACAO_WEB"]."' ";<br>
<br>
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0$query .=3D "WHERE cod=
professor =3D '".$professorSenha[$i]<br>
["CODPROFESSOR"]."' ";<br>
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0$query .=3D "AND data_=
alteracao <=3D '".$professorSenha[$i]<br>
["DATA_ALTERACAO_WEB"]."' ";<br>
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0echo "<br> ->=
".$query."<br><br>";<br>
<br>
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0var_dump($professorSenha[$i=
]["DATA_ALTERACAO_WEB"]);<br>
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0$banco->query($query); =
=A0//Atera=E7=E3o feita 15/05/09<br>
<br>
<br>
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0echo (mysql_query($query)) =
? "" : "erro";<br>
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0}<br>
=A0 =A0 =A0 =A0}<br>
<br>
<br>
valeu<br>
<br>
</font></blockquote></div><br>
--0016361643459eee2b046dd21b73--
|
