Jump to content

Search the Community

Showing results for tags 'tables'.

  • 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








  1. What would be the most efficient way to code on wordpress? Should I write directly on the platform or copy it from an editor? I am having a hard time on WP specially when adding tables as the code is all messed up (without spaces or lines). If you use WP, please help! Thank you, Damian
  2. I have a stored procedure that I have scheduled as a job to run nightly at midnight. I want the stored procedure to insert the data into a table when it runs. Do I have to create the table first or is there a way to create the table when the stored procedure runs? My second question is: I then need a job to purge that same table every night at 11pm prior to the stored procedure running again at midnight. Thank you for any help you can provide. I appreciate it. Here is my Stored Procedure: USE [TMWSUITE] GO /****** Object: StoredProcedure [dbo].[Wynne_DriverSnapshot] Script Date: 1
  3. i have a table of songs"links" and i am trying to make a search bar for them but i cant seem to figure it out, would anyone be so kind to help me? S3RL (WIP).html
  4. So I'm trying to filter some records out of my select inside a form on my website. Problem is that I currently have this setup: Database Table1 Time Number Table2 Number Something I'm trying to filter time by checking how many records show up of number in table2 So basically I select time from table1 where number is less than <some amount> in table2 How do I actually put that in sql? I currently have this but it isn't working: SELECT Time FROM Showcase WHERE Number IN (SELECT COUNT(Number) FROM Build WHERE CO
  5. How to code this Table I want code of Table of Buttons with link Please
  6. Hello. Is there an EASY way to have a w3css table that is centered & a variable width. IE not taking up 100% of the available div width. Ive currently got this code - it is a small width - but it still floats to the left of the screen. <div class="w3-row"> <div class="w3-half w3-container" style="margin-left:auto; margin-right:auto;"> <table class="w3-table-all" style="margin-left:auto; margin-right:auto;"> Ive tried with or without (rows, w3-centered, w3-center) - & nothing works, ive added (& not added) the css
  7. Hi there, I have been trying set a width of the last column in a table to 200px. <div class="table"> <div class="table-row"> <div class="table-cell">data</div> <div class="table-cell">data</div> <div class="table-cell"><span>data</span></div> </div> </div> .table{display: table;} .table-row{display: table-row;} .table-cell{display: table-cell;} .table-cell span{width: 200px;} Setting .table-cell:last-child to 200px causes strange behaviour with the height of the cells (this matters as a c
  8. Hi people! I'm having an issue in my coding, I created a table and there is a white spacing between cells that I cant get rid of. I have used cellpadding, styled the no border and still comes up. I'm also programming in HubSpot so I don't know if this has anything to do since I'm still doing it in HTML. This is an example of the code used: <tr style="height: 127.056px; border: 0px; border-spacing: 0px;"> <td style="width: 304px; background-image: url('https://cdn2.hubspot.net/hubfs/2294395/gray_BB-07-1.png'); background-size: 100% 100%; background-repea
  9. I was wondering if anyone was familiar with and could help me with my coding? I'm fairly new to coding layouts and would like a few tips. I understand it would be easier to not use tables, but this is what I find easier to work with as I'm comfortable with the coding as it is. My issue is trying to change the color/width on scrollboxes. I tried using a certain coding, but it did not work at all and simple left my scrollbox the same; white and gray. I saw someone else who also uses tables and this type of coding make their scrolboxes different using similar coding but I still can't figure
  10. Hi Guys, I have a slight problem with some of my code. I have a series of tables running down a page with each table containing different data. All looks fine when I look at it as a HTML page but when I use it as an Email 2/3 elements move for some reason, is there a way I can make sure these elements won't move? The code is in the backend of a program I use and gets called as Emails are generated for different subjects. Thanks in advance, Craig.
  11. Dear all, i am getting the following issue with my tables, as they resize according to text size, how can make it all same size and auto break text to second line to make it more readable and consistent ( the following image is the test i was running ) i tried to change the css and do style for table however it didn't work.. here my css and here the code for the tables in the image
  12. Dear all, i have been working in my college project and i reached a point were i can't get my cart orders into Order history, as it's not working and keep giving me the following error page, Error : INSERT INTO `cib4003_h00233671_at`.`orderhistory`(`order_id`, `Product_ID`, `Product_Name`, `client_ID`, `quantity`) VALUES ('', '', '', '2', ''); Duplicate entry '0' for key 'PRIMARY' ^ i checked the databse and all values are 0 except the Client_ID... thats why i am getting Duplicate entry, however, i tried to fix the problem for the past few hours and i can't find the issue, her
  13. Hi, I am considering to have two tables related to investments: 1) investors 2)invested money, with a link between the two. For the second table, besides own id and id linking to the first table, there are: investment received, paid money (e.g. profits, paid capital etc.), and dates associated with investment and paid money. There is also some money deductible which is relevant to tax, exchange rate, expenses, etc. I have two options: having those deductions as part of the second table with proper formulas, or keep the table simple and have deductions not in the table but rather as part of th
  14. This is my situation If variable $conn has all variables (with a value) $conn = new mysqli($servername, $username, $password, $dbname); and then you use var_dump($conn); and the output would be null of all the values of $conn. What would it mean? Am I right the connection then needs to be re-established? I'm doing 2 queries on a database. First query is SHOW TABLES then make the user choose a table value. From this value a new query is done. So first connection is done. But can I use this connection or should I make a new one?
  15. My goal seems simple: a dark green background to my table with lines alternating with a lighter green background. The problem is that I can't get rid of the areas to the left and right of each <td> where the dark green is bleeding through. I've tried setting the left/right border property to 0, the left/right margin property to 0, the left/right border property to 0; the border color to the lighter green—all with no results. The only thing that works is to use "cellpadding='0' cellspacing='0'" with the <table> tag, but this also affects the vertical spacing, which I don't want to m
  16. Hi,While testing the table (pls see below) in Jaws, noticed that Jaws didn't recognize the Header 2 and the cells related to this header.Do I have to treat this table as a complex table with headers and ids?Before, I was pretty sure that rowgroup and colgroup values should help improve accessibility in this kind of tables. Maybe, it is because different screen reader tools work differently.PLs advice.Thank you!<table><caption>Table's caption</caption><tr> <th scope="col">Header 1</th> <th scope="col">Header 2</th> </tr>
  17. The idea is to insert with the browser a multiple input field, a loop, into mysql database. Is the solution to first put this loop input variable in an array and after that create in this case multible tables? Or is an array not necessary?
  18. I made a set up for showing tables with a php script. Its based on a script from w3schools. // make connection with localhost $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // script calling to connect with dbase function write_content () { // reading the tables from the dbase $sql = "SHOW TABLES"; // show tables $result = $conn->query($sql); while ($row = $result->fetc
  19. Hello! I have a web page that is not standard compliant, just need it available temporarily until I can build it using CSS. Created in Dreamweaver CS3, HTML 4.0.1 Transitional with tables (ouch), using the "insert plugin" feature. Page has multiple MP3 files that were converted from the .aiff format by the app All2MP3 for Mac. If you can suggest a free converter that includes metadata, as this one does not. Am working with old equipment & browsers, so cannot test visually myself, but I am told that the files function fully as intended in current versions of Safari, IE & Firefox
  20. I am very new to this i have a doubt i am trying a query in php the actual concept is i have data of one user in users table and the same users doing some transactions in transaction table so i need to display the data from two different tables in single view file how can join both tables in single query Note: users id is forgien key of transaction created_by please suggest me
  21. Hi, I've just built a basic web site, but I now realise (by going through the process) that I need to understand other languages & processes in order to make the site streamlined & fully functional. Because I've only learnt html & css (on a basic level) my understanding of php, sql, js, xml, etc is very poor. I therefor need some advice on what the best mechanisms are for inputting data, storing it & displaying it on the web, possibly with some type of rss feed too. The basic process the site is doing, can be described as follows: 1. Users enter data using an online fo
  22. Does Anybody have a SQL code that does the following ones of or is it done in parts?1. DB Schema Design - Design a basic database to store the following information + A fleet of Vehicles - Include details such as mileage, vin numbers etc + A pool of drivers - Include relevant documentation, e.g. Drivesr license, ID Book + A group of routes - Marking out GPS coords for directions etc. is not necessary, just include a start & end address as well as any other info you believe to be pertinent + A drivers schedule, tying the above 3 tables together
  23. Hi please help wiith php code, im trying to retrieve data from a self referencing table types(id,name,parent,desc) this values should be in a drop down list "<li>" in html Thanks in advanced
  24. Hey guys, I can't figure out why my top image on my table isn't working right. The bottom border won't show up and the image is clearly readjusting to something because the quality is awful when I put it into my coding, but it's fine on photobucket. I've adjusted the whole table size, the tr size, the td size, the padding and the margin on absolutely everything. I can't figure it out. Please help! Page i'm struggling with: audreyholmesmusic.webs.com/testhome.htm Let me know if 'view source' doesnt work and you need the code.
  25. So I'm trying to build out an html email for a client in Constant Contact. I've worked out most every bug in all email clients, but for some reason one of my tables (see code comment "table two - left & right columns") is being shifted to the left by about 1px. It doesn't do this in Apple's mail client, nor does it display like that when viewed in a browser. It seems to only occur in Microsoft and Google email clients. The math on the tables adds up, the images are correct, all padding, margins, spacing, borders, etc. are removed. I'm at a loss and on deadline. Any help would be awesome.
  • Create New...