xcmir Posted June 29, 2008 Share Posted June 29, 2008 Hi when using PHP to run an MYSQL query I am getting a small problem in this command: SELECT * FROM table1 where field='value' What I am trying to do is select the data from field which is in table2. When I query the above command, it tries to select field from table1. How do I solve this?? Help much appertiated. Quote Link to comment Share on other sites More sharing options...
MasterACE14 Posted June 29, 2008 Share Posted June 29, 2008 SELECT * FROM table2 where field='value' I'm speechless.... Quote Link to comment Share on other sites More sharing options...
xcmir Posted June 29, 2008 Author Share Posted June 29, 2008 I need to get the data from table1 not table2 Quote Link to comment Share on other sites More sharing options...
trq Posted June 29, 2008 Share Posted June 29, 2008 You r question makes no sense. Are you wanting data from table1 or table2, your last two posts contradict each other. Quote Link to comment Share on other sites More sharing options...
xcmir Posted June 29, 2008 Author Share Posted June 29, 2008 Hi, I just realised my statement doesnt make sense at all ??? But I think I have figured it out...guess my brain wasnt working.... 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.