Reapz Posted November 19, 2003 Posted November 19, 2003 OK... My app' analyses server logs then puts the info gathered into an MS Access DB. The user can then upload the DB to their MySQL DB or generate PHP pages from the data stored in it. At least... thats what it is supposed to do... One of the tables will end up with the same amount of fields as there are entries and they will be named after the entries. The idea being that I can later see how many points Dave has against Andy etc. eg: ##### Fred Dave Andy Jim Tom etc... Fred Dave Andy Jim Tom etc... I've never used Access for anything particularly interesting so I didn't know about the field limit of 255. Ok so I'll maybe I'll use Excel instead.... Nope... maximum 255 columns there too... DOH! It's unlikely that I will need to use all 255 fields/columns but it is possible. So what I need is an alternative to Access and Excel that doesn't have these limitations. So if anyone can suggest something that would be great. Incidentally... Does MySQL have limitations such as these aswell? Cheers, Andy. Quote I'm getting the hang of this now... No really I am!
Moderators Robby Posted November 19, 2003 Moderators Posted November 19, 2003 I would consider re-designing the logical structure of the way you're handling this. You are thinking too much in Excel when you should be think terms of Database tables. Instead of going across and adding new fields, you should be adding rows. Post the tables, feilds and data you will save and we'll be glad to help. Quote Visit...Bassic Software
Reapz Posted November 20, 2003 Author Posted November 20, 2003 Hi Robby, The app' is a CS stats compiler I'm doing for a friend because he can't find one that gives him all the info that he wants. So I said I'd give it a shot because I didn't think it would be too difficult and sure enough getting the info from the server logs wasn't. The Access database is simply a place to store this info during the compile process prior to uploading to MySQL or generating PHP pages. All the other tables don't present a problem but what I'm trying to achieve with this one is to be able to show how many kills a certain player has against another one. Every time a new lot of server logs are compiled there's the possibility of new players to add to the DB. Originally I thought that I'd have to create one table per player with an entry for all the other players in it but of course that would have resulted in hundreds of tables which is silly. The easiest way I could think of was to create a table like the one I've described and add an entry and a field for each new player. You know, kinda like those distance from City A to City B tables you get in road maps. This way I could do it with just one table and then I could just cross reference Player A's field with the entry for Player B to find the data I wanted. It seems the simplest way to me I'm just restricted by the number of fields I'm allowed Anyway, hopefully I've described a little better what I'm trying to do and maybe you can suggest a much better way to go about it. Cheers. Quote I'm getting the hang of this now... No really I am!
Administrators PlausiblyDamp Posted November 20, 2003 Administrators Posted November 20, 2003 How about one table with the player details linked to a table with the player stats? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
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.