samoi Posted October 29, 2009 Share Posted October 29, 2009 Hello guys! I have two tables I want to get data from! One named: users, others named villages! $SQL = mysql_query("SELECT u.uid as userID, u.name as username, u.email as email, u.online as online, u.pass as pass, v.vid as villid, v.owner as owner, v.x as x, v.y as y, v.resource as resource FROM villages as v, users as u WHERE (owner=userID) AND (username='".$username."') AND pass='".$password."' "); It takes long time to be executed and return data! Is there any faster way to get around this? Thank you Quote Link to comment https://forums.phpfreaks.com/topic/179450-query-takes-long-time-to-retrive-data/ Share on other sites More sharing options...
samoi Posted October 29, 2009 Author Share Posted October 29, 2009 Please help me out Quote Link to comment https://forums.phpfreaks.com/topic/179450-query-takes-long-time-to-retrive-data/#findComment-947382 Share on other sites More sharing options...
fenway Posted November 14, 2009 Share Posted November 14, 2009 I'm sure there's a faster way... check out the link in my sig and try to re-formulate your question. Quote Link to comment https://forums.phpfreaks.com/topic/179450-query-takes-long-time-to-retrive-data/#findComment-957415 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.