Login

03-22-2012, 11:07 PM

[eluser]USCTrojans[/eluser]
Hello,

I have a logged in model that is called in my parent function to check for users being logged in. When I call another function in that controller, and call a model it "inherits the search parameters from the parent which is searching a different table. Does anyone know how to clear the query?

I'm getting an error that looks like this

Code:

A Database Error Occurred



Error Number: 1066



Not unique table/alias: 'sessions'



SELECT `network` FROM (`sessions`, `sessions`, `sessions`, `morehousej09_gmail_com`) WHERE `session_id` = '3022ad6c14c0508885196a7d9783424b' AND `session_id` = '3022ad6c14c0508885196a7d9783424b' AND `session_id` = '3022ad6c14c0508885196a7d9783424b' AND `username` = '[email protected]'



Filename: /Users/MorehouseJ09/Documents/Web Development/Danzan Capital/Sprint 1/modules/mainsite/models/user_information_retrieve.php



Line Number: 23

But in the model that is called , only the "morehouse_j09_gmail_com" table should be searched. How do I clear the results from that parent function which searches my "sessions" table in sql?

Thanks