I'm most of the time using MySQL in conjuction with PHP and I hope that it's okey to post questions regarding MySQL. There isn't much traffic here anyway so I hope you can live with it...
Anyway... I'm going to put two different translations of the bible in a MySQL-db. And before I do anything I would like to know a couple of things that I couldn't make out of the MySQL manual. Q1: This db won't be too big for MySQL to handle? Q2: My first thought was to use two tables like this: table1: | book_id (PRI_KEY) | short_name | long_name | extended_name | bible_part | table2: .--------------(PRI_KEY)-------------. | book_id (F_KEY) | chapther | verse | txt1917(text) | txt2000(text) | Is this a good idea? Table2 will get huge! Any better ideas? Q3: Can you do a search where the WHERE-clause searches the primary key in table 2 or do I have to use "...WHERE book_id = '1' AND chapther = '1' AND verse = '1'".... Q4: Can you order the data in table 2 in the db itself and not just when displaying the results so that the first primary key allways will be | 1 | 1 | 1 | and the last will be (in this case) | 77 | 22 | 21 | Well... I think that is it... Please help me on this one. Feel free to answer any or all of the questions... thanks! . bobo . www.elstudion.com . www.elstudion.com/bobo . -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
