skulk

Planning on starting a review website using tags. After a little research read that you should have 3 tables to optimaly use tabs (true?). So I took that a couple of steps forward and decided to put everything into new tables, since all the fields (editor review, user review and data) will be quite big. So I figured if everything was in one table, it would really have rubbish performance. Did I take it too far? Or is it the correct way? Total number of (main_name) fields will be a couple of hundered. Shouldn't cross 1000, does that change anything? Proposed structure is as follows: main id name location map id main_id tag_id editor_id userrev_id data_id tag tag_id name editor editor_id review userrev userrev_id user rating review menu data_id data

In other words, I want to implement the AutoFilter from MS Excel, into PHP_MySQL. Anyone?

I have a database with the following fields. Name | Company | Date values in each column could be repeated, or not. as in there could be several same names with the same company with different dates, or different names with same company. How do I populate a table with this info and have drop down boxes, so that I can narrow down the search? For example: Name | Company | Date 12 | 1 | 1929 13 | 1 | 1929 14 | 1 | 1929 12 | 2 | 1929 12 | 4 | 1929 13 | 1 | 1941 12 | 6 | 1929 So if in the drop down I select '12' under name, only those entries with 12 are shown, and then I can further sort it by selecting only '1' under Company. Hope I'm clear, I manage to complicate things when I post them

It won't be +/- as I mentioned in the last line, it will be B/S. My mysql knowledge is really limited, so I found code for sorting in PHP (which I guess is longer than what you said), but the 2nd part, summing it up etc, I couldn't figure out.

I want to accomplish the following, either through php or mysql queries, not had much luck in the last few days, so if anyone could help me, .... I have: Desc | +/- | Qty A | + | 10 A | + | 10 A | - | 20 A | + | 5 B | + | 2 A | + | 3 I want the final output to be: Desc | +/- | Qty A | + | 8 B | + | 2 Basically go through the table, and if something has been bought and sold completely, ignore that 'desc'. If not just display the final holding after all +'s and -'s. The first table will be in a mysql table, and the +/- will be 'B'/'S'. Thanks alot edit .... the 'Desc' is not limited to A and B, it could be as few as 2 variables and as many as 300.

I wanted to port a VB program of mine to PHP, and had a coupla doubts. The site will have a membership system, with a new line (or more) of data being associated with (nearly) every member on a daily basis. I was wondering how to go about storing that data (all the data since inception till current, would also need to be aggregated each time the user logs in): 1. I thought of having a table for every user, but i guess that would lead to a huge database, and slow the whole site down. 2. Have a single table and store every users info in that and parse the table each time, again as time goes by that table would be enormous and become slow again. 3. Store a separate file for every user and when the user logs on create a temp table and copy the csv contents to it and then proceed. According to me this would be the best, am I correct? If everything is stored in csv's, is ther a way to prevent a user from guessing the address and filename and accessing all the data? Sorry about the long post, hope it makes sense.