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. Link to comment https://forums.phpfreaks.com/topic/112414-solved-simple-mysql-problem/ 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.... Link to comment https://forums.phpfreaks.com/topic/112414-solved-simple-mysql-problem/#findComment-577113 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 Link to comment https://forums.phpfreaks.com/topic/112414-solved-simple-mysql-problem/#findComment-577115 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. Link to comment https://forums.phpfreaks.com/topic/112414-solved-simple-mysql-problem/#findComment-577116 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.... Link to comment https://forums.phpfreaks.com/topic/112414-solved-simple-mysql-problem/#findComment-577120 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.