scarface83 Posted April 25, 2007 Share Posted April 25, 2007 Hi, can anyone see anything wrong with the below ? for some reason is is ignoring the where condition in table a_users ? $query2 = "SELECT absence_mgt.datestamp, absence_mgt.ID FROM absence_mgt, a_users WHERE a_users.Login='$keepit' AND a_users.TeamRef='$tm' AND absence_mgt.viewable='1' "; Quote Link to comment https://forums.phpfreaks.com/topic/48603-mysql-query-help/ Share on other sites More sharing options...
pocobueno1388 Posted April 25, 2007 Share Posted April 25, 2007 Try doing this to catch the error: mysql_query($query2)or die(mysql_error()); Quote Link to comment https://forums.phpfreaks.com/topic/48603-mysql-query-help/#findComment-237980 Share on other sites More sharing options...
scarface83 Posted April 25, 2007 Author Share Posted April 25, 2007 i have that on the next bit of code , the funny thing is , is its displaying info but its just ignoring the a_users.Login='$keepit' AND a_users.TeamRef='$tm' bit ? Quote Link to comment https://forums.phpfreaks.com/topic/48603-mysql-query-help/#findComment-237981 Share on other sites More sharing options...
MadTechie Posted April 25, 2007 Share Posted April 25, 2007 the statement looks fine to me.. check the fields exists etc, also try printing the statement and use it in myphpadmin and see what's returned, it may show the error ! Quote Link to comment https://forums.phpfreaks.com/topic/48603-mysql-query-help/#findComment-237985 Share on other sites More sharing options...
scarface83 Posted April 25, 2007 Author Share Posted April 25, 2007 i wil try that thanks for the help everyone Quote Link to comment https://forums.phpfreaks.com/topic/48603-mysql-query-help/#findComment-237990 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.