SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Zealot Pozor's Avatar
    Join Date
    Apr 2004
    Location
    Switzerland
    Posts
    114
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Strange problem with query

    hi,

    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 ;


    someone who has an idea why?

    greez Pozor

  2. #2
    SitePoint Zealot colinr's Avatar
    Join Date
    Aug 2003
    Location
    san francisco, ca
    Posts
    198
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    is php controling the session id or do you have your own session control
    Web Slave

  3. #3
    SitePoint Zealot Pozor's Avatar
    Join Date
    Apr 2004
    Location
    Switzerland
    Posts
    114
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    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!

    greez Pozor


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •