Jump to content

Search the Community

Showing results for tags 'table'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • W3Schools
    • General
    • Suggestions
    • Critiques
  • HTML Forums
    • CSS
  • Browser Scripting
    • JavaScript
    • VBScript
  • Server Scripting
    • Web Servers
    • Version Control
    • SQL
    • ASP
    • PHP
    • .NET
    • ColdFusion
    • Java/JSP/J2EE
    • CGI
  • XML Forums
    • XML
    • Schema
    • Web Services
  • Multimedia
    • Multimedia
    • FLASH

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start





Website URL








Found 76 results

  1. Unknown column 'col' in 'field list' Is the error message, i tried all kinds of backticks, and quotes but doesnt work So I was thinking, how can I check (in phpmyadmin or in the mysql console) whether a table has the columns that are needed?
  2. I have a script and a MYSQL query its supossed to create a new table $variable now I have $sql = "CREATE TABLE '$variabele' "; But it doesnt work. I think CREATE TABLE works for constants not for variables. Which query should I use?
  3. Hello! I have a map in my website and when I click on it, if there is a feature, it shows its information. This information is written by an innerHTML and currently it looks like that: if (feature) { var objeto = feature.getProperties(), propiedades; var propiedades; content.innerHTML = ""; for (propiedades in objeto){ content.innerHTML += propiedades + ':' + objeto[propiedades] + "<br />"; } return container.style.display = 'block'; } else { return container.style.display = 'none'; } So the info is shown ok but a little untidy. So I would like to show this info with a table. propiedades contains the name of the data and objeto[propiedades] their values. Could anybody tell me how to do it or give me an example please? Thank you in advance!
  4. hisoka

    server database

    Suppose I have a table in mysql server database and I want to add a row that fits these piece of information username = john password = silverlight is it true if I do it like this : INSERT INTO table (username , password) values ('john' , 'silverlight'); ?? this is the first question the second question is : are these two the same ??? INSERT INTO table (username , password) values ('john' , 'silverlight'); // without single quotes INSERT INTO table ('username' , 'password') values ('john' , 'silverlight'); // with single quotes if not what is the difference ?
  5. I'm having a thing I cant figure out in CSS I defined a class to make a table. The idea is that the table will be filled with text and its added frequently. The bottom border of the table should add a new line and augment. I tried several things, I also tried overflow-x auto, but I dont want a scrollbar. Is there a way to get rid of that scrollbar. Im using CSS3 It would be great if someone has a solution.
  6. Hello..Can someone please teach me how to change the <table> tag into <div> tag without changing the table style..I heard that <div> tag is more friendly than <table>.. Please give me an example.. Thank you..
  7. Hi, I am building my first web site & very new to html code etc.... One problem I can't seem to solve is that in my site I have two tables next to each other. One floating right & one floating left. They are different heights & will fluctuate in content over time as they contain variable information. Under the two tables I have a <p> footer with some text in it. I can sometimes get the text in my web editor (web expressions 4) to span the page & sit under both tables, but this never works in all browsers when I preview it. Some let the text float up under the shorter table & some span the text at a random point? What is the best code to allow text to always span the page & not float up, but at the same time be responsive to the changes in the tables heights? Have tried divs, breaks & lines but without success in chrome/IE/firefox (using eric meyers css/reset as well to null any variables). Thanks. PS: w3sch is an excellent resource.....
  8. Hello, I have been researching a question I have but cant seem to find an answer for my situation. I have a simple html form that in a couple of fields may require user to write a longer then usual response on the trouble she is experiencing. What I would like is for that table cell to abbreviate the text and I have a link (called More) to the full page for that indivual row which can display the whole trouble report. Right now the whole text appears in the table cell and distorts the display. Is there a way to do this. Thanks. Here is the code for the table. It is the row with 'Problem' variable I would like to abbreviate. <table class="table table-striped table-bordered table-hover" cellpadding="10" cellmargin="5" border="3"> <tr> <th id="table_header">First Name</th> <th id="table_header">Last Name</th> <th id="table_header">Reach #</th> <th id="table_header">Room Number</th> <th id="table_header">Type of Trouble</th> <th id="table_header">Room Availability</th> <th id="table_header">Trouble Report</th> <th id="table_header">Ticket Status</th> <th id="table_header">Assignment</th> <th id="table_header">TT Number</th> <th id="table_header"></th> </tr> <?php foreach($model as $row) { echo "<tr class='success'>"; echo '<td>'. $row['FName'] .'</td>'; echo '<td>'. $row['LName'] .'</td>'; echo '<td>'. $row['Rch_Num'] .'</td>'; echo '<td>'. $row['Rm_Number'] .'</td>'; echo '<td>'. $row['Prob_Cat'] .'</td>'; echo '<td>'. $row['Rm_Avail'] .'</td>'; echo '<td>'. $row['Problem'] .'</td>'; echo '<td><i>'. $row['Tkt_Status'] . '</i></td>'; echo '<td>'. $row['Assgnd_Tech'] .'</td>'; echo '<td>' . $row['TT_Num'] . '</td>'; echo "<td class='info'><a class=one href='tt_record.php?id=" . $row['id'] . "'>More...</a></td>"; echo "</tr>"; }?></table>
  9. I wonder if anyone here can help me... I am having troubles with the table code. It is messing with other elements on my page. Does anyone know how I can fix it so that it only adds a border to the sections I want to have borders and not to everywhere on the page? Every time I add html code bits to my page to create these: It makes the Header look like this: When it is supposed to look like this: *I use weebly as my website building platform, so the elements in the first picture above was created with the custom element tool. Each product block is a single cell table, and this is the code I am using for each product block (apart from a few URLs and Text, etc... each one is the same): <!DOCTYPE html> <html> <head> <style> table, th, td { border: 2px solid #DCDCDC; padding: 1px; } table { border-spacing: 1px; } th, td { padding: 5px; } a { text-decoration: none; } p.small { line-height: 60%; } </style> </head> <body> <table style="width:100%"> <tr> <td><div align="center"> <a href="http://www.rebeckahstreasures.com/happily-ever-after-crochet-pattern-for-fashion-dolls.html"><img src="http://www.weebly.com/uploads/1/4/3/9/14399682/1012548_orig.jpg" alt=”Happily Ever After Fashion Doll Crochet Pattern PDF $10.00 by Rebeckah’s Treasures - You can be a designer too when you mix and match necklines & silhouettes! Grab your copy today here: http://goo.gl/5bXO46 #crochet #pattern #barbie #toys” border="0" width="100%" style="margin:3px 0px"/><h4 style="margin:0px 0px">"Happily Ever After"</h4><h5 style="margin:0px 0px">Crochet Pattern</h5></a> <p class="small" style="margin:0px 0px"><em> $10.00 USD</em></p> <a href="#" onclick="R.cart.add(36645, 220124); return false;"><img src="http://www.weebly.com/uploads/1/4/3/9/14399682/_8947683_orig.png" border="0" width="120"style="margin:0px 0px"/></a></div></td> </tr> </table> </body> </html> Thanks in advance!
  10. Hello, MyProject I am having a hard time making the form inputs align with the localstorage table. The forms will have to fit in between the ID and ACTIONS columns and align with where the data is being inputted. I also am having a hard time setting the widths for the table columns. Adjusting the padding is not a problem, but setting a set width is a problem. Any help would be greatly appreciated. Also, is there any way to change the local storage ID something like GW-"DATE"-"TIME" rather than numerically going up 1-2-3-4-5-etc.? Thank you, I SIDEARM I
  11. Hello everybody, I've created a table in HTML and while layout and styling with CSS is working nicely, the text of the first cell is very slightly shifted towards the bottom and therefore not aligned with the rest of the text in the other cells. What is the reason for this and how can this issue be solved ? Thank you very much in advance !
  12. Hello everyone, I am facing an issue with a page containing a table and a form : the form does not take over the style defined in the style sheet. It work out fine once I omit the closing </table>, however in that case the order of the elements gets messed up. What can I do to fix this ? Here is the code (I've taken out several irrelevant elements (additional list items, metas, etc.) : <!DOCTYPE html> <html> <head> <meta charset="iso-8859-1" /> <title>HIGHWAY - Hard Rock'n'Roll</title> <link rel="Shortcut icon" href="favicon2.ico" type="image/x-icon"> <link rel="stylesheet" type="text/css" media="screen" href="styles.css"> <style> ul {list-style-type: none; margin: 0; padding: 0;} li {display: inline;} </style> </head> <body style="background-color:#000"> <center> <img src="logo_entete.jpg" alt="Logo Highway" style="width:700px; height:196px;"><br/> <br/> <br/> <!-- Site navigation menu --> <nav> <ul> <li><a href="news_fr.html">★ NEWS</a></li> <li><a href="band_fr.html">★ BAND</a></li> </ul> </nav> <br/> <!-- Main content --> <h1 style="text-align:left">CONTACT</h1> </br> <table> <tr> <td><u>Booking (France)</u><br/><br/> HIGHWAY Corp.<br/> 128 Place du Quebec, Appt 36<br/> 34000 Montpellier - France<br/> Email : highwaybeer@hotmail.com<br/> Téléphone : +33 6 29 37 93 57 </td> <td><u>Booking international (hors France)</u><br/><br/> Big Noise Productions<br/> Christina Guntert<br/> Email : ca.guntert@hotmail.fr<br/> Téléphone : +33 6 43 58 53 29<br/> </br> </td> <td><u>Technicien son</u><br/><br/> Adrien Lagarde<br/> Email : lagarde.music@gmail.com<br/> Téléphone : +33 6 48 55 29 59<br/> </br> </br> </td> </table> <p class="section_form" align="left"> <form action="MAILTO:ca.guntert@hotmail.fr" method="post" enctype="text/plain"> Abonnez-vous à la newsletter : <input type=text name:mail value="Votre adresse email"> <input type="submit" value="S'abonner"> </form> </p> <br/> <!-- Footer --> <p class="footer">© Highway Corp. 2014</p> </body> </html>
  13. hi all! please guide me how can i setup table prefix for different users while registering. like. i want to provide same table structure for all users and i think it would be better to use different table prefixes. please suggest me how can i select table prefix from registration data and write it to the mysql connection script automatically. and how can i setup mysql connection better with prefixes..... thank u in advance...
  14. I am having some issue with making my websites. I am making a layout like a newspaper forr ebook site . Its look will be a column with books category and it will be in left side in center there will be some latest album but problem with text align help me
  15. I am building a web page that's part of a contacts system. The page enables the user to search for a contact and after finding a contact they can view and edit that contacts details in the web page. The page consists of a number of tables that I want to control using HTML 5 and CSS 3. In full screen mode (e.g. on a desktop machine) there are up to 4 tables across the page. I need the page to convert to a single, narrow column of tables when the screen width gets narrower (e.g. when on a mobile phone). I've attached 2 screen shots. The first shows the page in full screen mode: The other shows how I want the page to convert when it goes into narrow mode: Please let me know what I can do to get the page working in that way. I've already played around with this problem in different ways. Initially I tried using lists, but found that I couldn't combine tables with lists, because they don't seem to display correctly in that set up. I've also tried using <section>, <article> and <aside> but found it difficult to control the widths of things (tables) when using these. Also, it seems difficult to use these components when I have 3 or 4 tables spread across the page and I want/need to convert those into a single column of tables with only one table per row in that column. It currently seems to me as though HTML 5 and CSS 3 just aren't set up to deal with this kind of scenario. I hope someone out there can prove me wrong and point me in the right direction, so that I can resolve this problem. Thanks in advance for your time.
  16. Hey everyone i am a newbie in web develop anyone can tell me how to set table align in css?and th, td, tr also with table align i got stuck help me please ? thanks in advance
  17. Ok so I have been looking for how to do this all day(Very long time) and I can't find it anywhere. What I am trying to do is power my website with what I call URL variables the things that YouTube uses E.G. Page.php?video=1 but when it comes to selecting data from my database I have an issue. I have a table for ID and some others I will call them EX1 to EX5, what I am trying to do is the URL "?" thing says a number and that number is turned into a variable(don't know how) but that variable indicates the ID, but I don't want to put the ID on the page, I want the ID to tell my PHP code where in the tables the EX1 - EX5 are, so they can become a variable for later use on the page. Sum up. PHP takes the URL?name=1 turns into variable(1) - variable indicates where in the columns to look LOOKS UNDER ID finds 1 - now it needs to make the EX1 - EX5 in the same column into variables. ID EX1 EX2..... 1 I don't know how to do this can anyone help me?
  18. i'm trying to make a install script. for that i wish to CREATE a DATABASE and at the same time CREATE some TABLEs for it with a single form submit? for this can DATABASE be selected within the "CREATE TABLE" query? if yes how? or there is any other idea?
  19. Hello all, first time poster on the forum and I can get some insight on how to solve a problem I am having. I hope its rewarding for you as well. A little background, I am using an xml file that is exported from Autodesk Civil 3D that list Pay Items, Quantities, and Units for Road Construction estimates. My goal is to harness this xml file to include unit prices and then create a total cost per pay item. You will see there is a field for <estimatedUnitPrice> and I would but in a price there for each item. For now I can not even use the xsl file and the html file to get a table to generate that will list each pay item. Below is the code, and I have attached a picture of the results of running this code via Visual Web Developer Express, as may see it will not list the pay item <gml:description> which I expect. XML file Named "Summary (XML)" This file comes directly from Autodesk Civil 3D, I only have one pay item listed here for brevity sake, normally there would be many <item> sections. <?xml version="1.0" encoding="UTF-8"?><DesignProject xsi:schemaLocation="http://www.transxml.net/schema/dp/0.3 DP-GML20060123pxs.xsd" gml:id="ID001" xmlns="http://www.transxml.net/schema/dp/0.3" xmlns:gml="http://www.opengis.net/gml" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:txl="http://www.transxml.net/schema/txl/0.3" xmlns:rpi="http://www.transxml.net/schema/rpi/0.3" xmlns:lr="http://www.transxml.net/schema/lr/0.3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <gml:name>design project</gml:name> <gml:description></gml:description> <projectID>ID001</projectID> <unitSystem>english</unitSystem> <group> <DesignProjectPayItemGroup gml:id="dppig1"> <gml:description></gml:description> <designProjectPayItemGroupID>dppig1</designProjectPayItemGroupID> <item> <DesignProjectPayItem gml:id="id"> <sequenceOrder>0</sequenceOrder> <estimatedUnitPrice>0</estimatedUnitPrice> <estimatedQuantity>4558.445</estimatedQuantity> <referencePayItem> <ReferencePayItem gml:id="60201-0600" xmlns="http://www.transxml.net/schema/ref/0.3"> <gml:description>18-INCH PIPE CULVERT</gml:description> <referencePayItemID>60201-0600</referencePayItemID> <specBookVersion></specBookVersion> <lumpSum>false</lumpSum> <supplementalDescriptionRequired>false</supplementalDescriptionRequired> <unit> <txl:UnitOfMeasure> <txl:unitOfMeasureID>LNFT</txl:unitOfMeasureID> <txl:unitSystem></txl:unitSystem> </txl:UnitOfMeasure> </unit> </ReferencePayItem> </referencePayItem> <referenceInformation xmlns="Civil3D.QTO.Computation"> <unitType>linear</unitType> <listSeparator>,</listSeparator> </referenceInformation> </DesignProjectPayItem> </item> </DesignProjectPayItemGroup> </group></DesignProject> XSL File Named "Detailed" I got thie file from an example for W3Schools Tutorials. I changed only what was in bold, and deleted a second column that was in the org example. <?xml version="1.0" encoding="iso-8859-1"?><!-- Edited by XMLSpy® --><xsl:stylesheet version="1.0"xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <html> <body> <h2>My CD Collection</h2> <table border="1"> <tr bgcolor="#9acd32"> <th>Description</th> </tr> <xsl:for-each select="DesignProject/group/DesignProjectPayItemGroup/item/DesignProjectPayItem/ReferencePayItem"> <tr> <td> <xsl:value-of select="gml:description" /> </td> </tr> </xsl:for-each> </table> </body> </html> </xsl:template></xsl:stylesheet> HTM file named "Detailed" Again this file source code came from a tutorial and I changed the file names that are in bold below. <html><head><script> function loadXMLDoc(filename) { if (window.ActiveXObject) { xhttp = new ActiveXObject("Msxml2.XMLHTTP"); } else { xhttp = new XMLHttpRequest(); } xhttp.open("GET", filename, false); try { xhttp.responseType = "msxml-document" } catch (err) { } // Helping IE11 xhttp.send(""); return xhttp.responseXML; cription } function displayResult() { xml = loadXMLDoc("Summary (XML).xml"); xsl = loadXMLDoc("Detailed.xsl"); // code for IE if (window.ActiveXObject || xhttp.responseType == "msxml-document") { ex = xml.transformNode(xsl); document.getElementById("example").innerHTML = ex; } // code for Chrome, Firefox, Opera, etc. else if (document.implementation && document.implementation.createDocument) { xsltProcessor = new XSLTProcessor(); xsltProcessor.importStylesheet(xsl); resultDocument = xsltProcessor.transformToFragment(xml, document); document.getElementById("example").appendChild(resultDocument); } }</script></head><body onload="displayResult()"><div id="example" /></body></html>
  20. please help me inserting data to mysql database table from a html table. like <table> <tr> <td>name</td> <td>Gender</td> <td>age</td> <td>school</td> </tr> <tr> <td>John</td> <td>Male</td> <td>21</td> <td>Oxford</td> </tr> <tr> <td>Juliya</td> <td>Female</td> <td>25</td> <td>Oxford</td> </tr><!- bla! bla! bla! --></table>SUBMIT I want to send all the rows' data at once to a table. Please guide how could it be done!
  21. waay2kool

    Table row colors

    Hi, I have created a table where each row is an alternating color green then cream then green etc. My html looks like: <table border="2" cellspacing="2" cellpadding="2" width="90%"><tr bgcolor="pms3275"><td width="25%"><font color="white">PRODUCT NUMBER</font></td><td width="20%"><font color="white">DESCRIPTION</font></td><td width="5%"><font color="white">DURO METER</font></td><td width="25%"><font color="white">SIZE</font></td><td width="5%"><font color="white">UNIT</font></td><td width="10%"><font color="white">LIST PRICE</font></td><td width="10%"><font color="white">SHOPPING CART</font></td></tr><tr bgcolor="teal"><td>NON-REINFORCED</TD><TD>SHEETING</td><td>Shore A</td><td></td><td></td><td></td><td></td></tr><tr bgcolor="#FFFFCC"><td>SH-20001-002</TD><td>Non-Reinforced Sheeting</td><td>40</td><td>6" x 8" x .002" Matte</td><td>each</td><td>$70.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-20001-002'>Add to Cart</a></td></tr><tr bgcolor="#CCFFFF"><td>CUST-20001-002</TD><td>Non-Reinforced Sheeting</td><td>40</td><td>12" x 16" x .002" Matte</td><td>each</td><td>$140.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=CUST-20001-002'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>SH-20001-003</TD><TD>Non-Reinforced Sheeting</TD><td>40</td><TD>6" x 8" x .003" Matte</TD><TD>each</TD><TD>$75.00</TD><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-20001-003'>Add to Cart</a></td></tr><tr bgcolor="#CCFFFF"><td>SH-20001-004</TD><TD>Non-Reinforced Sheeting</TD><td>40</td><TD>6" x 8" x .004" Matte</TD><TD>each</TD><TD>$75.00</TD><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-20001-004'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>CUST-20001-005</TD><TD>Non-Reinforced Sheeting</TD><td>40</td><TD>12" x 12" x .005" Matte</TD><TD>each</TD><TD>$130.00</TD><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=CUST-20001-005'>Add to Cart</a></td></tr><tr bgcolor="#CCFFFF"><td>SH-20001-005</TD><td>Non-Reinforced Sheeting</td><td>40</td><td>6" x 8" x .005" Gloss</td><td>each</td><td>$80.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-20001-005'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>CUST-20001-010</TD><TD>Non-Reinforced Sheeting</TD><td>50</td><TD>12" x 12" x .010" Gloss</TD><TD>each</TD><TD>$140.00</TD><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=CUST-20001-010'>Add to Cart</a></td></tr><tr bgcolor="#CCFFFF"><td>SH-20001-010</TD><td>Non-Reinforced Sheeting</td><td>50</td><td>6" x 8" x .010" Gloss</td><td>each</td><td>$80.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-20001-010'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>SH-20001-013</TD><td>Non-Reinforced Sheeting</td><td>40</td><td>6" x 8" x .013" Matte</td><td>each</td><td>$50.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-20001-013'>Add to Cart</a></td></tr><tr bgcolor="#CCFFFF"><td>SH-20001-020</TD><td>Non-Reinforced Sheeting</td><td>50</td><td>6" x 8" x .020" Gloss</td><td>each</td><td>$90.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-20001-020'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>SH-20001-040C</TD><td>Non-Reinforced Sheeting</td><td>50</td><td>2.5" x 3" x .040" Gloss</td><td>each</td><td>$25.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-20001-040C'>Add to Cart</a></td></tr><tr bgcolor="#CCFFFF"><td>SHS-20001-040</TD><TD>Non-Reinforced Sheeting</TD><td>50</td><TD>4" x 6" x .040" Gloss</TD><TD>each</TD><TD>$40.00</TD><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SHS-20001-040'>Add to Cart</a></td></tr><tr bgcolor="#CCFFFF"><td>SH-20001-040</TD><td>Non-Reinforced Sheeting</td><td>50</td><td>6" x 8" x .040" Gloss</td><td>each</td><td>$100.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-20001-040'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>SHS-20001-062</td><td>Non-Reinforced Sheeting</td><td>50</td><td>4" x 6" x .062" Gloss</td><td>each</td><td>$50.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SHS-20001-062'>Add to Cart</a></td></tr><tr bgcolor="#CCFFFF"><td>SH-20001-062</TD><td>Non-Reinforced Sheeting</td><td>50</td><td>6" x 8" x .062" Gloss</td><td>each</td><td>$110.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-20001-062'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>SH-20001-062C</TD><td>Non-Reinforced Sheeting</td><td>50</td><td>2.5" x 3" x .062" Gloss</td><td>each</td><td>$25.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-20001-062C'>Add to Cart</a></td></tr><tr bgcolor="#CCFFFF"><td>SHS-20001-080</TD><td>Non-Reinforced Sheeting</td><td>40</td><td>4" x 6" x .080" Matte</td><td>each</td><td>$50.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SHS-20001-080'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>SH-20001-080</TD><td>Non-Reinforced Sheeting</td><td>40</td><td>6" x 8" x .080" Matte</td><td>each</td><td>$120.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-20001-080'>Add to Cart</a></td></tr><tr bgcolor="teal"><td>REINFORCED</td><td>SHEETING</td><td></td><td></td><td></td><td></td><td></td></tr><tr bgcolor="#CCFFFF"><td>SH-21001-007</TD><td>Reinforced Sheeting</td><td>40</td><td>6" x 8" x .007" Gloss</td><td>each</td><td>$130.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-21001-007'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>CUST-21001-007</td><td>Reinforced Sheeting</td><td>40</td><td>12" x 16" x .007" Gloss</td><td>each</td><td>$600.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=CUST-21001-007'>Add to Cart</a></td></tr><tr bgcolor="#CCFFFF"><td>SH-21001-020</td><td>Reinforced Sheeting</td><td>40</td><td>6" x 8" x .020" Gloss</td><td>each</td><td>$120.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-21001-020'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>SHS-21001-030</td><td>Reinforced Sheeting</td><td>40</td><td>4" x 6" x .030" Gloss</td><td>each</td><td>$50.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SHS-21001-030'>Add to Cart</a></td></tr><tr bgcolor="#CCFFFF"><td>SH-21001-030</td><td>Reinforced Sheeting</td><td>40</td><td>6" x 8" x .030" Gloss</td><td>each</td><td>$130.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-21001-030'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>SH-21001-040</td><td>Reinforced Sheeting</td><td>40</td><td>6" x 8" x .040" Gloss</td><td>each</td><td>$140.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-21001-040'>Add to Cart</a></td></tr><tr bgcolor="teal"><td>FIRM</td><td>SHEETING</TD><td></td><td></td><td></td><td></td><td></td></tr><tr bgcolor="#CCFFFF"><td>SHS-22001-020</td><td>Firm Sheeting</td><td>60</td><td>4" x 6" x .020" Gloss</td><td>each</td><td>$40.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SHS-22001-020'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>SH-22001-020</td><td>Firm Sheeting</td><td>60</td><td>6" x 8" x .020" Gloss</td><td>each</td><td>$90.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-22001-020'>Add to Cart</a></td></tr><tr bgcolor="#CCFFFF"><td>SHS-22001-040</td><td>Firm Sheeting</td><td>60</td><td>4" x 6" x .040" Gloss</td><td>each</td><td>$60.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SHS-22001-040'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>SH-22001-040</td><td>Firm Sheeting</td><td>60</td><td>6" x 8" x .040" Gloss</td><td>each</td><td>$130.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-22001-040'>Add to Cart</a></td></tr><tr bgcolor="#CCFFFF"><td>SH-22001-080</td><td>Firm Sheeting</td><td>60</td><td>6" x 8" x .080" Gloss</td><td>each</td><td>$140.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-22001-080'>Add to Cart</a></td></tr><tr bgcolor="#FFFFCC"><td>SH-22001-120</td><td>Firm Sheeting</td><td>60</td><td>6" x 8" x .120" Gloss</td><td>each</td><td>$150.00</td><td><a href='http://grcht.tlyfy.servertrust.com/ShoppingCart.asp?ProductCode=SH-22001-120'>Add to Cart</a></td></tr></table> I would like to separate this out to a css sheet from all being within the html. How do i get the <tr> tag to alternate colors? Thanks!
  22. I didn't know where to add my new topic, but because my problem involves coding in HTML. I thought this might be the right place. So.. I'm new to web design/coding and i'm coming to you guys for help because the company i work for has now got a new website which uses Umbraco CMS to add and edit content. What they neglected to tell us was that we'd need to know HTML to edit certain data. I have added the HTML coding below for the Table of specs for one of the products we sell at my work, but my problem is getting the color_boxes to align centrally with all the rest of the data. (see image attached of 'The Table as viewed on the webpage'). HTML: <table border="0" class="comm_table" align="center"><tbody><tr><th colspan="2" width="129">Size/ref/code</th><th class="table_th1" style="text-align: center;">W½</th><th class="table_th1" style="text-align: center;">W1</th><th class="table_th1" style="text-align: center;">W2</th><th class="table_th1" style="text-align: center;">W3</th></tr><tr><th colspan="2" width="129">Colour</th><th><div class="color_box"><span class="color" style="background: none repeat scroll 0% 0% #ffffff;">color</span></div></th><th><div class="color_box" style="text-align: center;"><span class="color" style="background: none repeat scroll 0% 0% #99CC00;">color</span></div></th><th><div class="color_box"><span class="color" style="background: none repeat scroll 0% 0% #D00000; align: center;"> color</span></div></th><th><div class="color_box"><span class="color" align="center" style="background: none repeat scroll 0% 0% #333399;">color</span></div></th></tr><tr><th class="table_th1" rowspan="2" style="text-align: center;">Height of Walker (cm)</th><th class="table_th1" style="text-align: center;">STD Wheels</th><td>37-46</td><td>41-55</td><td>48-64</td><td>59-78</td></tr><tr><th class="table_th1" style="text-align: center;">Activity Wheels</th><td>41.50</td><td>45-60</td><td>52-68</td><td>63-82</td></tr><tr><th class="table_th1" colspan="2" style="text-align: center;">Hand-grip width (cm) </th><td>34</td><td>34</td><td>34</td><td>38</td></tr><tr><th class="table_th1" colspan="2" style="text-align: center;">Frame width (cm) </th><td>58-60</td><td>58-60</td><td>60-62</td><td>62-64</td></tr><tr><th class="table_th1" colspan="2" style="text-align: center;">Frame Length (cm) </th><td>52-59</td><td>56-62</td><td>69-83</td><td>77-89</td></tr><tr><th class="table_th1" colspan="2" style="text-align: center;">User Height (cm) </th><td>up to 95</td><td>91-122</td><td>107-137</td><td>129-152</td></tr><tr><th class="table_th1" colspan="2" style="text-align: center;">Max User Weight (kg </th><td>27</td><td>27</td><td>39</td><td>60</td></tr><tr><th class="table_th1" colspan="2" style="text-align: center;">Frame Weight (kg) </th><td>3</td><td>3.3</td><td>3.85</td><td>4.85</td></tr></tbody></table><p> </p><p style="text-align: left;">*All dimensions are based on four wheeled walkers. Frame weight is calculated based on the frame with wheels but excludes accessories. Activty wheels will affect the adjustment range of each walker. Colours shown are standard for each size. Special colours are available at an additional cost.</p><p style="text-align: justify;"><span class="Apple-style-span">Measuring correctly:</span> Whilst the user is standing with their arms by their side and with a few degrees of flexion at the elbow, measure from the crease in the palm of the hand to the floor. Always remember to adjust the walker as the user grows to maintain good posture and efficient walking.</p><p style="text-align: left;"><span>For further information about the Kaye Walker and the accessories available please request our brochure via our online enquiry.</span></p> Looking at the coding in red, which is relative to my problem. This will need tidying up a lot, after i have tried so many times to edit the coding to do what i want it to. But i had no success.. I have also attached a screen grab of the HTML coding we are looking at (as edited in Umbraco CMS): I have also included two more screen grabs of the Table as viewed in Umbraco CMS & the Table as viewed on the webpage if this is of any help. The Table as viewed in Umbraco CMS: The Table as viewed on the webpage: As you can see above the colour boxes are not aligned central to the rest of the data input in the table. i would appreciate someone to help me understand the correct way of coding. As i am an ultra newbie and have taken it upon myself to learn HTML, anyone who might offer any course in HTML coding, please get in touch via PM. Thanks, Reb
  23. Hi, I have form that displaying report per week. First thing to do is choose what week then automatically display the date/shift that week ranges. here is my weekly_report.php <?php error_reporting(0); session_start(); ob_start(); date_default_timezone_set("Asia/Singapore"); include('connection.php'); ?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><title>Weekly Report</title><head><link rel="stylesheet" type="text/css" href="op_report.css" /><script type="text/javascript" src="jquery.js"></script><script type='text/javascript' src='jquery.autocomplete.js'></script><link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" /><script type="text/javascript">//----auto complete week--//$().ready(function() { $("#week_selected").autocomplete("get_week_list.php", { width: 115, matchContains: true, mustMatch: true, selectFirst: false }); $("#week_selected").result(function(event, data, formatted) { $("#week_number").val(data[1]); }); }); /*AJAX*/function AJAX(){ var xmlHttp; try{ xmlHttp=new XMLHttpRequest(); // Firefox, Opera 8.0+, Safari return xmlHttp; } catch (e){ try{ xmlHttp=new ActiveXObject("Msxml2.XMLHTTP"); // Internet Explorer return xmlHttp; } catch (e){ try{ xmlHttp=new ActiveXObject("Microsoft.XMLHTTP"); return xmlHttp; } catch (e){ alert("Your browser does not support AJAX!"); return false; } } } } //-----get weekdata from week---//function getweekdata() { // if (window.event.keyCode==13 || window.event.keyCode==10) { divid = "week_data"; var url = "get_weekly_data.php"; var str = "id=" + document.getElementById("week_number").value; var xmlHttp = AJAX(); xmlHttp.onreadystatechange = function(){ if(xmlHttp.readyState > 0 && xmlHttp.readyState < 4){ // document.getElementById(divid).innerHTML=loadingmessage; } if (xmlHttp.readyState == 4) { if (xmlHttp.status == 200) { var jsonart = xmlHttp.responseText; document.getElementById(divid).innerHTML = jsonart; } } } xmlHttp.open("POST", url, true); xmlHttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded"); xmlHttp.setRequestHeader("Content-length", str.length); xmlHttp.setRequestHeader("Connection", "close"); xmlHttp.send(str); // } } </script></head><body onload=document.getElementById("week_selected").focus();><form name="weekly_report" action="" method="post"><div id="ddcolortabs"><ul><li> <a href="index.php" title="Operator's Shift Report"><span>Operator's Shift Report</span></a></li><li id="current"> <a href="weekly_report.php" title="Reports"><span>Reports</span></a></li></ul></div><br/><div><table><tr><td style="border: none;">Type Week:</td><td><input type="text" name="week_selected" id="week_selected" value="" size="15" onkeyup="getweekdata();"></td></tr></table></div><input type="hidden" name="week_number" id="week_number"><div id='week_data'></div></form></body></html> //get_week_list.php <?phpob_start();include "connection.php";$q = strtolower($_GET["q"]);if ($q == '') { header("HTTP/1.0 404 Not Found", true, 404); }//else (!$q) return;else{$sql = "select week_id, week_number from week_list where week_number LIKE '$q%'";$rsd = mysql_query($sql);$cnt = mysql_num_rows($rsd); if($cnt > 0) { while($rs = mysql_fetch_array($rsd)) { $pid = $rs['week_id']; $pname = $rs['week_number']; echo "$pname|$pidn"; } } else { header("HTTP/1.0 404 Not Found", true, 404); }}?> and here is my get_weekly_data.php // which display the data for that week. <?phpob_start();include "connection.php";if($_POST["id"]){ $sql = "select r.report_date, s.shift_type FROM op_reports AS r, shift_list AS s WHERE WEEK(report_date) + 1 = '" . ($_POST["id"]) . "' GROUP BY shift_type ORDER BY shift_id ASC"; $res = mysql_query($sql); echo "<table>"; echo "<tr>"; echo "<th>Comp</th>"; while($row = mysql_fetch_assoc($res)) { $report_date = $row['report_date']; $report_shift = $row['shift_type']; echo "<th>$report_date/$report_shift</th>"; } echo "</tr>"; $sql_r = "select r.report_date, s.shift_type FROM op_reports AS r, shift_list AS s WHERE WEEK(report_date) + 1 = '" . ($_POST["id"]) . "' GROUP BY shift_type ORDER BY shift_type DESC"; $res_r = mysql_query($sql_r); echo "<tr>"; echo "<th></th>"; while($r = mysql_fetch_assoc($res_r)){ echo "<th>Output</th>"; } echo "</tr>"; $sql_comp = "SELECT DISTINCT p.process_name , r.process_id, r.report_shift FROM op_reports AS r JOIN process_list AS p ON (p.process_id = r.process_id) WHERE WEEK(report_date) + 1 = '" . ($_POST["id"]) . "' GROUP BY process_name ORDER BY p.process_name ASC"; $res_comp = mysql_query($sql_comp); echo "<tr>"; while($row_comp = mysql_fetch_assoc($res_comp)) { $process = $row_comp['process_name']; $process_id = $row_comp['process_id']; echo "<td>$process</td>"; $comp = "SELECT DISTINCT o.compound_type, o.process_id, o.shift_date FROM op_output AS o WHERE process_id = '$process_id' GROUP BY o.shift_id, compound_type ORDER BY compound_type ASC"; $c = mysql_query($comp); echo "<tr>"; while($co = mysql_fetch_assoc($c)) { $compound_type = $co['compound_type']; $process_i = $co['process_id']; $shift_date = $co['shift_date']; echo "<td>$compound_type</td>"; $sql_output = "SELECT DISTINCT o.compound_type, SUM(o.compound_output) AS compound_output, o.process_id, o.shift_id, o.shift_date FROM op_output AS o WHERE process_id = '$process_id' AND o.compound_type = '$compound_type' GROUP BY o.shift_id, o.shift_date, compound_type ORDER BY o.shift_id ASC"; $res_output = mysql_query($sql_output); while($row_output = mysql_fetch_assoc($res_output)) { $compound_output = $row_output['compound_output']; $shift = $row_output['shift_id']; $compound = $row_output['compound_type']; $date = $row_output['shift_date']; if($shift == 1 && $date == $shift_date) { echo"<td>$compound_output</td>"; } else { echo "<td></td>"; } if($shift == 2 && $date == $shift_date) { echo"<td>$compound_output</td>"; } else { echo "<td></td>"; } if($shift == 3 && $date == $shift_date) { echo"<td>$compound_output</td>"; } else { echo "<td></td>"; } if($shift == 4 && $date == $shift_date) { echo"<td>$compound_output</td>"; } else { echo "<td></td>"; } if($shift == 5 && $date == $shift_date) { echo"<td>$compound_output</td>"; } else { echo "<td></td>"; } } echo "</tr>"; } } echo "</tr>"; echo "</table>"; }?> My problem now is on displaying of output per date/shift. It's been todays that I tried to fixed this. I hope somebody can help me. Thank you so much
  24. I have a table with two columns and three rows (6 cells). In each cell, I have a "header" and then a list of links. This list can vary from 1 link to 5+ and is subject to change. The client does not like how much white space there is between the the last item in the list, and the next header. I haven't set the cellpadding or cellspacing attributes, so I'd assume that they are 0 since not specified. The attribute that would work perfectly for my solution- cell padding, does not support negative values. :-( Does anyone else have any ideas? Many Thanks,Jg
  25. terryds

    CREATE TABLE error!

    Hello, everyone..I have a database named testdbI want to create a table named signup_table.. This is the code i wrote Then, an error appeared...Would someone please help me on this ?
  • Create New...