FrobinRobin

Although there are some errors in the display code (which makes it near-impossible to read) there is a tutorial with some things you should consider on this site: http://www.phpfreaks.com/tutorials/118/0.php

To solve my own noob problems I usually echo the query on the web page before executing it. Then I copyNpaste the query into PHPMYADMIN to see if it works A great way to find those school boy errors as PHPMYADMIN will give you a clue as to whats wrong.

Thanks Effigy, Would what I've done be considered incorrect or (more importantly) detrimental to my database? table_a ID, name REL_table_a__table_b ID, table_a_ID, description SELECT table_a.name, table_b.description FROM table_a, REL_table_a__table_b WHERE table_a.ID = REL_table_a__table_b.table_a_ID **Pls excuse my bad sql example** I understand why not to use ID in the REL_ table (not needed as table_a_ID in the REL_ table is sufficient) - I may now remove it. Also - what was your query for google? I cant seem to find the right words and I'd really like more information on the usage of "REL_" neither of your examples mentioned "REL_"

Hi all, (my first time post ) I came across an example database where tables were related using REL_ and seperated by _ _ (double underscore i.e. REL_table1__table2) PHPMyAdmin reads the table as a collapsable tree and which I really like. I only use this relation from my own interpretation (creating table1 on it's own, and only creating table 2 within the REL_ table) so my table list would be: table1 REL_table1 REL_table1__table2 I've looked on the internet but cannot find any information on it? Can someone please point me in the right direction to learn how to use this correctly? (btw: I have rtfm) Many thanks in advance!