Hi,
I've got a problem from my system and i can't understand whats' happen
now it's verry strange and i'm verry tire so :
$sql = ("SELECT idaffilie, idmonaie FROM user WHERE (session = ".
$dbh->quote($sys{'session'}). ") AND (time > '". ( time() - (60 * 60 * 12) ). "')
LIMIT 1");
print $sql. "\n\n\n";
($idaffilie, $idmonaie) = $dbh->selectrow_array( $sql );
I builded my connection and I execute this part of code and it's return
to me this :
DBD::mysql::st execute failed: Unknown column '989657745LH2719W234142M2811HQ30RX9' in
'where clause' at lib.cgi line 91.
1 at lib.cgi line 91.
But if I execute this request using mysql bash it's works :/
For further information the structure of the table's :
CREATE TABLE user (
session text DEFAULT '' NOT NULL ,
ip text ,
user_agent text ,
idaffilie int(10) unsigned ,
idmonaie int(10) unsigned DEFAULT '1' ,
idclient int(10) unsigned ,
date text ,
heure text ,
time int(10) unsigned
);
So what's the problem ?
Thanks for help.
--
=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=
Nicolas JOURDEN - [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> - #41100039 -
+33 0681940905
http://www.wedoo.com/ - La Nouvelle Facon de Surfer...
http://ddx.wedoo.com/ - Mon site perso.
Programmeur, Integrateur | Perl, CGI, Mysql/PostgreSQL, HTML, Design
=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=
