chanchelkumar Posted September 7, 2007 Share Posted September 7, 2007 Hi Friends, I am working with some widgets which is to be displayed in selected pages For that i wrote a Joint query which is given below... The problem is i want to check the publish status from another table. how can i make it with one query... $selwidg="select distinct a.$widgetpage from cw_widgemanage as a, widget as b,cw_userdetails as c where a.userid='$usrid' and (a.$widgetpage=b.widgetname) and (b.foruser=c.usertype)"; help me thanks in advance.... Link to comment https://forums.phpfreaks.com/topic/68372-stucked-with-a-joint-query-help-me/ Share on other sites More sharing options...
Illusion Posted September 7, 2007 Share Posted September 7, 2007 first echo your query, it gives the exact query sent to mysql. Link to comment https://forums.phpfreaks.com/topic/68372-stucked-with-a-joint-query-help-me/#findComment-343774 Share on other sites More sharing options...
chanchelkumar Posted September 7, 2007 Author Share Posted September 7, 2007 I tried it ... but no use .. how can i join another table which contains widgetname gives result as "on" Link to comment https://forums.phpfreaks.com/topic/68372-stucked-with-a-joint-query-help-me/#findComment-343777 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.