Web Hosting Vodahost    

Home Take The Royal Tour! Order Now Features Prices
Go Back   Web Hosting > VodaHost Web Hosting Support > mySQL & PHP

Notices

mySQL & PHP Discussions, information and help with mySQL and PHP.

Reply
 
Thread Tools
  #1  
Old 09-05-2009, 06:52 PM
Rob (SA)'s Avatar
Major
 
Join Date: Nov 2006
Location: Centurion, South Africa
Posts: 483
Default Change data form columns to rows

Hi folks,

I have a file that looks this this.



I am lookin gfor some help to get the numbers listed in the red square at the bottom to appear in the row at the top and similarly to do the same excercise for the blue row and so on and so on.

[PHP]<?
echo "<td>$hole</td><td>${$lengthhole}</td><td>${$par_hole}</td><td>${$index_hole}</td>";
echo "<td><input type=\"text\" maxlength=\"2\" size=\"2\" name=\"gross_score$hole\" value=\"${$gross_score}\"></td>";
echo "<td><input type=\"text\" maxlength=\"12\" size=\"15\" name=\"gross_name\" value=\"$gross_name\" disabled></td>";
echo "<td><input type=\"text\" maxlength=\"2\" size=\"2\" name=\"net_score\" value=\"$net_score\" disabled></td>";
echo "<td><input type=\"text\" maxlength=\"12\" size=\"15\" name=\"net_name\" value=\"$net_name\" disabled></td>";
echo "<td><input type=\"text\" maxlength=\"3\" size=\"3\" name=\"stableford\" value=\"$stableford\" disabled></td>";
echo "<td><input type=\"checkbox\" name=\"fairway$hole\" value=\"1\" $fw_checkbox></td>";
echo "<td><input type=\"checkbox\" name=\"gir$hole\" value=\"1\" $gir_checkbox disabled></td>";
echo "<td><input type=\"text\" maxlength=\"2\" size=\"2\" name=\"putt$hole\" value=\"${$putt}\"></td>";
echo "<td><input type=\"checkbox\" name=\"bunker$hole\" value=\"1\" $bunker_checkbox></td>";
echo "<td><input type=\"checkbox\" name=\"sandsave$hole\" value=\"1\" $sandsave_checkbox disabled></td>";
echo "<td><input type=\"text\" maxlength=\"3\" size=\"3\" name=\"drive$hole\" value=\"${$drive}\"></td>";


echo "<td><select name='teeclub$hole'>";
[/PHP]

your help in this regard will b emost appreciated
__________________
Kind Regards
Rob
www.gnjgf.co.za
www.oryan-projects.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2  
Old 09-17-2009, 06:53 PM
mattski's Avatar
Master Sergeant
 
Join Date: Jan 2008
Location: Colorado
Posts: 64
Default Re: Change data form columns to rows

Rob,

Tables can be a real pain to get right if you are hand coding them. I hand code most of my designs but use a WYSIWYG editor for complex table layouts and then wrap the PHP code around it.

Without seeing your entire table layout it's hard to see where the issue is. Based on what you posted here I don't see that you have any rows defined. All you have here are <td> tags. Each row is surrounded by <tr> tags at the beginning of the row and </tr> tags at the end of the row. The <td> tags identify the column start and </td> tags identify the end of the column in the row.

So what you want to do is have something that looks like this:

HTML Code:
<tr><td>Hole:</td><td>1</td><td>2</td><td>3</td></tr> <tr><td>Meters:</td><td>212</td><td>550</td><td>442</td></tr>
Obviously you will be doing this in PHP and populating the data in the table but this is the general layout you'll want to follow.
__________________
Mattski

http://www.ScorpioFire.com


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT +1. The time now is 12:59 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC7
2005-2009 VodaHost Web Hosting Your Perfect Web Host - All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203