Weird problem - Setting session variable messes up database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
smarty_pockets
Forum Newbie
Posts: 3
Joined: Thu Nov 01, 2007 6:28 pm

Weird problem - Setting session variable messes up database

Post by smarty_pockets »

I have a weird problem thats making me go crazy. I have a PHP+smarty video sharing website. Everything works fine, until you log in. When you log in, some database queries start returning 0 results. If you delete your PHP session, things start working fine again.

Is there any correlation between session variable and some sort of DB caching??

Any help or pointers would REALLY be appreciated!
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Generally, there is no correlation.
User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

Post by Kieran Huggins »

nothing comes to mind... check your login code. Maybe you're overwriting something?
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Post by s.dot »

are your session database managed?
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
Post Reply