|
HTML - Table Sorting By Column
Hey guys,
Okay so i have a question over a table that I am generating with data from a database. The way i have my table set up is like this: Recipe Name-----Prep Time-----Total Time-----Rating ========================================= some data here 12 mins 20 mins 4.5 some data here 12 mins 20 mins 4.5 some data here 12 mins 20 mins 4.5 some data here 12 mins 20 mins 4.5 So what i want to know is if I could make the Column Header (RECIPE NAME) into a link that way the user can click it and it would sort the recipe names in ascending order. When i open the page i am already displaying all the data form the database in this table. but i want to allow the user to be able to sort the recipe names. So i would have to i guess (REFRESH) the page automatically?? I already have teh code to sort my data, what I need to know is how exactly to go about making the column header into a link to SORT and then refresh the page Here is my code I currently have used to create the TABLE and populate it using a while loop to send the data from the DB into the table: <table border="2" width ="500"> <tr> <th>Recipe Name</th> <th>Prep Time</th> <th>Total Time</th> <th>Rating</th> </tr> <!--While statement used to pass data from DB into tables --> <? while( $row = mysql_fetch_array( $result ) ) { ?> <tr> <td><a href="ShowRecipe.php?id=<?=$row['id'] ?>"><?=$row['name'] ?></a></td> <td><?=$row['preptime']?> mins</td> <td><?=$row['totaltime']?> mins</td> <td><?=$row['rating']?></td> </tr> <? } ?> </table> Similar TutorialsCould someone tell me what's involved or suggest a way that I could have a table full of info made up of store names, state/province, address, phone numbers etc. that could instantly be sorted by one of these categories. Hi: I would like to present to my users a 3-column table of 'House for Sale' advertisements. This is not a commercial venture but will only be for the use of my Senior Mobile Home Park residents. Each of the three columns should contain x number of rows with each column cell containing a tiny pic (from a house.jpg file) and underneath the pic would be a few general details of the price, address, agent selling, etc. The .pic would be clickable and would then bring up a more enlarged picture of the house and complete details of the house for sale. My first puzzle is how to make this list of rows of advertisements *variable*. I guess I have to 'build' the page in my server according to how many ads are currently active ?? Any first thoughts are welcome. Thanks, -Mel Smith hi i am displaying the data retrived from the database in table format. say using query select . col1 col2 col3 col4 12 15 15 13 15 16 the data displayed in col1,col2,col3 are retrieved from the database. now the problem is now i have to compute value for col4 (i.e col4= (15+15)/4) using the values in col2 ,col3. how to perform this. i am using sql as backend and jsp for front end. please send some similar examples or working code for this or any suggestions are appreciated. Thanks and regards Manjunath I need a three column table in which the center column will have multiple rows, the number will vary. For exampe, this works. I need a third column that will look like the first, just one row corresponding to the seven rows in the second column. Code: <table border=1> <tbody> <tr><td rowspan=8>Dry skin</td></tr> <tr><td>46.0 </td></tr> <tr><td>9.0 </td></tr> <tr><td>35.3 </td></tr> <tr><td>12.5 </td></tr> <tr><td>20.8 </td></tr> <tr><td>27.0 </td></tr> <tr><td>4.0 </td></tr> </tbody> </table> If I do this Code: <table border=1> <tbody> <tr><td rowspan=8>Dry skin</td></tr> <tr><td>46.0 </td></tr> <tr><td>9.0 </td></tr> <tr><td>35.3 </td></tr> <tr><td>12.5 </td></tr> <tr><td>20.8 </td></tr> <tr><td>27.0 </td></tr> <tr><td>4.0 </td></tr> <tr><td>third column, same row? </td></tr> </tbody> </table> another row is started. I just want third column that has one row corresponding, correlated with the seven rows in the second column. I don't know how to do that. The following piece of code delivers a table with fixed width 666px and appr. 200px 466px wide columns, when opened within IE. Long text fits into the columns, long strings break at the border. When opening up within MS Word, the column width seem to ignore the styles. Does anybody know alternative commands delivering the same result in MS Word? Thanks, Andreas <table style="width: 666px; table-layout:fixed; word-wrap: break-word;" cellspacing="0"> <col width="30%"> <col width="70%"> <tr> <td>Floating Rate Payer Calculation Amount:</td> <td>|TRADE_CURRENCY| |CD_NOTIONAL|</td> </tr> </table> I want to dynamically hide column in table. There's many working examples on the web, such as http://www.ahfb2000.com/webmaster_he...ead.php?t=3356 But I lack one feature. When I hide column (all cells in column) via style.visibility="hidden", the remaining column (cells) doesn't adjust its width. I would like to somewhat make the table adjust all cells widths (push together), as if the hidden column (cells) wasn't there at all. Is it possible ? Thanks. Hi, I am new to web design and am trying to design company website without using a site builder. I have built up my container with 3 boxes inside. In the largest I want text on the right and a 1 column 2 row table on the right - to be adjacent to each other but I can't get it to work. I don't want the text to wrap around the table. Please help. I want to hide a table column when a window gets too a certain width. I've clocked onto the media tags, and I've used them to re-structure my navigation bar and I know the media tags work beautifully, I just need to remove a column from a table, the last column too be exact, using just HTML. Alternatively, If I can't remove it how can I make it seem like it's gone? I've tried setting the column width too 0px but that doesn't work. there's an image inside the column though, and I reckon that might be what's messing this up. Any suggestions guys? Not sure if I worded that right. But I have a 3 column table with three rows. And I want a row with no columns at the top that is the full width, so I can put a title in there. how do I do that? Here is my current title. Thank you. Code: <table id="box-table-b">
<thead>
<tr>
<th width="175" scope="col">Website</th>
<th width="69" scope="col">Lowest <br />
Price</th>
<th width="50" scope="col">BUY</th>
</tr>
</thead>
<tbody>
<tr>
<td>xxxx</td>
<td>x</td>
<td><a href="#">Here</a></td>
</tr>
<tr>
<td>xxxxx</td>
<td>x</td>
<td><a href="#">Here</a></td>
</tr>
</tbody>
</table>
Hi, I have the following problem i'm trying to solve with HTML: I have a simple table with 3 columns. I want the table to have a 100% width of the screen. Furthermore the center column must ALWAYS have a width of 1000. The left and right column should just be there too fill the gaps up if you have a wider screen than 1000. Setting these left/right columns to width "100%" doesn't work because than it would just make the left column fill up the space and the right column will have a width of 0. How can I solve this? Some example could would be highly appreciated Thanks, betonboor Hi! I've been trying to figure out why columns in my HTML-table get weird widths. ie. this code: HTML Code: <table width="950" cellpadding="0" cellspacing="0">
<tr>
<td colspan="5">
column1
</td>
<td colspan="5">
column2
</td>
</tr>
<tr>
<td colspan="5">
<input type="text" value="column3" maxlength="20" style="width:165px;" />
</td>
<td colspan="5">
column4
</td>
</tr>
<tr>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
<td>8</td>
<td>9</td>
<td>10</td>
</tr>
</table>
gives me the result: Is there any way I can fix this so each of the columns get's equal size? Preferably without actually having to have to set the width on each of the bottom columns. If not, could anyone explain to me why it's acting this way? Thanks. Hi everyone Can you please help. I need to create a 3 column table, left column, content column and right column. I want the left column to have rounded corners. I am having a tough time doing this. Any help is appreciated Thanks hey guys - I was trying to add a little more kick to my website today and making the text appear in little windows I guess you would say - (I know the site is not complete and links are intentionally broken) if you look on the right of the page you will notice I added 2 table cells to round off the white - now the problem I can not figure out how to bring the white area over to the rounded edges whether I need to make the cell wider or if I need to add another cell - any help is appreciated. source: Http://www.medicalpracticeexams.com/index.asp Thanks can i have fixed layout for only some part of a table? I want the first column of my table to be "auto" and the other columns to be "fixed" llike style='table-layout:fixed;'. How can I achieve this? Thanks! Hi guys, this is my first post an ive only started to use HTML, PHP and mySQL so here goes. The problem I am having is that i want a single line table to duplicate more lines of code when an onClick button is pressed. it basically goes Staff name Wage hours worked I:::::::I I:::::::::::::I I:::::::::::::::::I IButtonI When the button is pressed i want the form table to change to Staff name Wage hours worked I:::::::I I:::::::::::::I I:::::::::::::::::I I:::::::I I:::::::::::::I I:::::::::::::::::I IButtonI and so on. I am storing staff name etc as an array so i can easily calculate totals. Is there a way to do this dynamically without having to show / hide or else using DOM? Any help appreciated! 0 Answers Posted ( Reply | Quote ) Unsubscribe Good day, I am brand new here in this forum. So many knowledgeable folks here. I am relatively new to web design. I typically use templates and themes and tweak them. I can navigate a CSS doc and html to make changes, etc. However, I have a client who has an existing site that she wants to keep the aesthetic of and so I am using what the previous designer left. It is a simple html page with tables. Simple enough. Very elegant visually. No need to SEO really so it works. She has asked if we can make the left column of a two column table scroll independently. The page content is about over 6000px. The scroll column will contain a page outline and other text that will include internal targeted links. This is outside my skill set, but I want to learn. Have searched the net and found some suggestions but want it to be clean and ended up here. There is no style sheet other than the ie6 sheet. Page is he http://www.themedeaproject.com/proposaltestpage.html no graphics are loaded. Can anyone point me to a good tutorial or have any suggestions? Thanks! BlueEyedMonkey aka Tatyanna Hi, I have a bunch of links that I want to alphabatize. Here is what the code looks like: <a href="http://youtube.com/watch?v=YhU1kJ19AgQ">Steppenwolf - Magic Carpet Ride</a><br> <a href="http://youtube.com/watch?v=Bfei_BCjYzQ">Coldplay - Don't Panic</a><br> <a href="http://youtube.com/watch?v=Rdkt-fDvk_Q">Johnny Cash - Folsom Prison Blues</a><br> <a href="http://youtube.com/watch?v=-WZghK8I-AU">James Brown - Doing It to Death</a><br> <a href="http://youtube.com/watch?v=RGm8aagBQxE">Little Brother - Let It Go (Feat. Mos Def & Talib Kweli)</a><br> This goes on for a few hundred more links. They are all inside one paragraph tag. Is there a fast way to alphabatize these band names? Hello. Is there a way to use HTML so that I able to sort by a series of dates? I have a database I am currently using to manage my contacts. I would like to be able to pull up the contacts that have been recently contacted, say in the past 2 months; I would like to be able to sort this database through a series of dates: Ex. 1/30/07 - 3/30/07 and then the database would pull up just those contacts that have been contacted within those dates (each contact entry has a "date of contact" field assigned to it). My database is in Filemaker and I am using BBEdit to manage the web based portion. Any help or information would be greatly appreciated. Thanks. i'm building some small website and have stuck with sorting text in my website: what i want to get is sorting function so i can sort may contest wit button 1st - a to z 2nd by date. can somewhan explin me have to do that. website luck like that : <h1> title </h1> here i want to put button 1 here i want to put button 2 <h2> title1</h2> <p> date1</p> <p>text1</p> <hr/> <h2> title2</h2> <p> date2</p> <p>text2</p> <hr/> <h2> title3</h2> <p> date3</p> <p>text3</p> <hr/> i really stuck with this - if needed i can put all in tables. like: <table> <tr> <td> <h2> title1</h2> <p> date1</p> <p>text1</p> <hr/> </td> </tr> </table> please help me. |
|||||||