my problem is that the query result is empty with this:
this runs in a normal php script on my laptop
SELECT sessid,variable,userid,timestamp FROM test_ext___ac_session WHERE sessid = '6163544fe95a5e7b267c31c3c0bec351'
with the same query in phpmyadmin it works and give me the expected result.
the table i have:
CREATE TABLE `test_ext___ac_session` (
`ac_sessionID` int(11) NOT NULL auto_increment,
`sessid` varchar(32) NOT NULL default '',
`variable` text NOT NULL,
`userid` varchar(10) default '1',
`timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`ac_sessionID`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
i have my own session management, independent from any php session function.
my problem is not located on creating an id, fill in the db etc.
i have a problem with the query who should retrive the row i wanna see. this doesnt work in my skript (other querys work fine), although the exact same query work fine in the phpmyadmin environment!
Bookmarks