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' "; 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()); 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 ? 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 ! 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 Link to comment https://forums.phpfreaks.com/topic/48603-mysql-query-help/#findComment-237990 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.