billynastie Posted July 22, 2009 Share Posted July 22, 2009 Hi All I am trying to write a little bit of code for a football team website basically it has a results grid like below. <tbody> <tr> <td width="145"> </td> <td width="32">Barr</td> <td width="32">Beec</td> <td width="32">Beec</td> <td width="32">Boot</td> <td width="32">Dean</td> <td width="32">Dean</td> <td width="32">Flix</td> <td width="32">Mont</td> <td width="32">Moor</td> <td width="32">Moor</td> <td width="32">Park</td> <td width="32">Pend</td> <td width="32">Swin</td> <td width="32">Urms</td> </tr> <tr> <td>Barr Hill</td> <td>X</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> </tr> <tr> <td>Beechfield Storm</td> <td valign="center" align="center"> </td> <td>X</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> </tr> <tr> <td>Beechfield Tornado</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td>X</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> </tr> <tr> <td>Boothstown Tigers</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td>X</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> </tr> <tr> <td>Deans Sports</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td>X</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> </tr> <tr> <td>Deans Tigers</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td>X</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> </tr> <tr> <td>Flixton Juniors</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td>X</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> </tr> <tr> <td>Monton Amatuers</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td>X</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> </tr> <tr> <td>Moorside Rangers Blue</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td>X</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> </tr> <tr> <td>Moorside Rangers Red</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td>X</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> </tr> <tr> <td>Parkwyddn</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td>X</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> </tr> <tr> <td>Pendlebury United</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td>X</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> </tr> <tr> <td>Swinton Juniors</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td>X</td> <td valign="center" align="center"> </td> </tr> <tr> <td>Urmston Town</td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td valign="center" align="center"> </td> <td>X</td> </tr> </tbody> What i am having problems with is firstly the names which are both down the left of the grid and shortnames across the top and also getting the mysql data to position in the grid in the correct places mysql data below. CREATE TABLE IF NOT EXISTS `games` ( `ID` int(10) NOT NULL auto_increment, `team` varchar(255) NOT NULL, `opponent` varchar(255) NOT NULL, `date` varchar(25) NOT NULL, `h_or_a` varchar(1) NOT NULL, `score` varchar(25) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; As you can see im only using simple data within my database and I would like to know if this a wrong method and how to solve this problem. I am really struggling with theis and any help people can send my way as a starting point would be extreamly greatful as I have tried everyway I can think to do this and im hitting a brick wall now. Please Help. Link to comment https://forums.phpfreaks.com/topic/166949-please-help-results-grid/ Share on other sites More sharing options...
billynastie Posted July 24, 2009 Author Share Posted July 24, 2009 Take it no one can help me do this. Link to comment https://forums.phpfreaks.com/topic/166949-please-help-results-grid/#findComment-881826 Share on other sites More sharing options...
haku Posted July 24, 2009 Share Posted July 24, 2009 The problem is that double-semi colon on line 36 in your php code. Link to comment https://forums.phpfreaks.com/topic/166949-please-help-results-grid/#findComment-881839 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.