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.... Quote Link to comment 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. Quote Link to comment 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" Quote Link to comment 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.