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 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 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. 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
Archived
This topic is now archived and is closed to further replies.