Page 1 of 1

PHP/Mysql table code

Posted: Sun Mar 14, 2004 3:14 pm
by MrBurns
I have 2 mysql tables, one containing a list of names, and a linking code. The linking codes are held in another table and are used to create the amount of columns(they are shown as the column headings). How can i get the appropriate names under the appropraite columns? there might be different amounts of names to go in each column.

Thanks in advance

Posted: Mon Mar 15, 2004 9:21 am
by Steveo31
Perhaps:

"INSERT INTO person (name, linkNo) VALUES ('Steve', '555')";

Posted: Wed Mar 17, 2004 4:16 am
by MrBurns
Sorry, that obviously wasn't very clear....... this is displaying information from different databases in a single html table. I have solved the problem by using tables inside tables

Thanks though!