TEENFRONT Posted September 7, 2006 Share Posted September 7, 2006 HeyIm looking for much needed advice. I have 3 user tables in a database set to 25000 max entries, i have over 60000 users. so table 1 and 2 are full, with 10,000 entries in table 3.This runs my multiplayer pool site, www.8baller.co.uk - he said he coded it it like that ( mutliple user tables ) to make it faster etc. coz the game is really mysql intensive. Iv just bought a dedicated server and now everything is hosted in the same place, so i can now start messing with the database and creating my own stats etc..But how do i get values of all 3 tables? so say...i want to display the newest user...so it would be entry 10001 in user table 3.. how on earth do i find out which table number the newest user is in? and how do i say pick the guy with the highest score out of all 3 user tables?Im confused lol. Link to comment https://forums.phpfreaks.com/topic/20053-help-with-3-tables/ Share on other sites More sharing options...
HuggieBear Posted September 7, 2006 Share Posted September 7, 2006 [quote]he said he coded it it like that ( mutliple user tables ) to make it faster etc.[/quote]How odd.... So do you have some existing code we can look at? He must either be looking at rownum or a auto incrementing ID or something.Maybe show us the code used to 'insert a new user' into the DB?Rich Link to comment https://forums.phpfreaks.com/topic/20053-help-with-3-tables/#findComment-88004 Share on other sites More sharing options...
TEENFRONT Posted September 7, 2006 Author Share Posted September 7, 2006 its done through the flash game itself so i cannot show u any code.im looking at this from the "start afresh, working with an existing database" aspect.. Link to comment https://forums.phpfreaks.com/topic/20053-help-with-3-tables/#findComment-88009 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.