Search the Community
Showing results for tags 'tables'.
-
Hello. I want to do something in W3CSS / CSS to do a scrollable table, but default to the current time, though I'm not sure what the process is called. Can someone advise the name of a process (if it exists), or any tutorials on how to do it? I've got a table of 3-4 columns. The first column is the time - in 5-minute blocks.. and then the other columns (in the row) contain information regarding the specified time. What I can do, is create a table with all the times - from midnight to midnight the next day.. However - Is there a way for the table to "scroll" up / down - Keeping the top/header row? But start with the current time - the user can still scroll up to see earlier times, but when the page starts/loads, the time for the current time is at the top of the table. Hopefully, that makes sense. Example: If someone views the site at 5:15 PM - all events from 5:15 pm will be displayed at the top, but the user can still scroll up/down to see earlier/later events.
-
Hello. I have a table in W3CSS. Ive got 4-5 lines / sections, and in each section I have one line of SELECT fields (along with other information). i am wondering I have 4-5 SELECT fields in a table line/row, and one TEXT field. Is there a way that if a person a) keeps all values blank (nothing selected) - no messages come up. b) when they select one value in that row, or adds a number in the text field (I guess i'll use classes), a script checks all values in that row & gives a warning if any value is blank.
-
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
-
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: 10/22/2019 6:35:18 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[Wynne_DriverSnapshot] as WITH cte (mpp_id, mpp_firstname, mpp_lastname, mpp_status, mpp_fleet, mpp_terminal) as ( Select mpp_id, mpp_firstname, mpp_lastname, mpp_status, mpp_fleet, mpp_terminal from manpowerprofile where mpp_terminationdt >= GETDATE() ), cte2 (lgh_number, lgh_startdate, lgh_enddate, lgh_outstatus, rn, lgh_driver1, lgh_class, lgh_class2) as ( Select lgh_number, lgh_startdate, lgh_enddate, lgh_outstatus, ROW_NUMBER() OVER (PARTITION by lgh_driver1 order by lgh_number desc) as rn, lgh_driver1, lgh_class1, lgh_class2 From legheader ) Select mpp_id, mpp_firstname, mpp_lastname, mpp_status, mpp_fleet, mpp_terminal, lgh_number, lgh_startdate, lgh_enddate, lgh_outstatus, lgh_driver1, lgh_class, lgh_class2 from cte left join cte2 on mpp_id = lgh_driver1 where rn = '1' and mpp_id NOT IN ('UNKNOWN','TESDR','TESDR2') order by mpp_id
-
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
-
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 COUNT(Number) < 50); it currently doesn't end up with anything but in theory it should show the times from the records where the count of the value of number is less than 50 so if Number = 40 and it gets counted 70 times it shouldn't show up. but if Number = 30 is counted 29 times it should show up can anyone tell me what is going wrong?
-
How to code this Table I want code of Table of Buttons with link Please
-
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 styles as well. This website does not contain any information about reducing the horizontal width or the ability to center a table. (all the examples shown, display a table at 100% of the available width). Does anyone here have the ability to add a few more examples to the site: https://www.w3schools.com/w3css/w3css_tables.asp
-
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 certain row is highlighted). Setting a width on the span solves the cell height issue, but the table still distributes the available space to each column evenly, so the last column is its natural width, plus 200px making it pretty wide. Is there a way to stop this last column filling out and remaining at 200px? Thanks.
-
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-repeat: no-repeat; height: 127.056px;"> <h1 style="color: #84161a; text-align: center; font-family: Agency FB;"><span style="font-size: 36px;">ADMIN <span style="color: #444444;">EMILY</span></span></h1> </td> <td style="width: 314px; background-image: url('https://cdn2.hubspot.net/hubfs/2294395/gray_BB-07-1.png'); background-size: 100% 100%; background-repeat: no-repeat; height: 127.056px;"> <h1 style="color: #84161a; text-align: center; font-family: Agency FB;"><span style="color: #444444; font-size: 36px;"><span style="color: #800000;">MARKETING</span> EMILY</span></h1> </td> <td style="width: 298.208px; background-image: url('https://cdn2.hubspot.net/hubfs/2294395/gray_BB-07-1.png'); background-size: 100% 100%; background-repeat: no-repeat; height: 127.056px;"> <h1 style="color: #84161a; text-align: center; font-family: Agency FB;"><span style="font-size: 36px;">DATA <span style="color: #444444;">EMILY</span></span></h1> </td> <td style="width: 302.792px; background-image: url('https://cdn2.hubspot.net/hubfs/2294395/gray_BB-07-1.png'); background-size: 100% 100%; background-repeat: no-repeat; height: 127.056px;"> <h1 style="color: #84161a; text-align: center; font-family: Agency FB;"><span style="font-size: 36px;">SALES <span style="color: #444444;">EMILY</span></span></h1> </td> <td style="width: 320px; background-image: url('https://cdn2.hubspot.net/hubfs/2294395/gray_BB-07-1.png'); background-size: 100% 100%; background-repeat: no-repeat; height: 127.056px;"> <h1 style="color: #84161a; text-align: center; font-family: Agency FB;"><span style="font-size: 36px;">CUSTOMER SERVICE <span style="color: #444444;">EMILY</span></span></h1> </td> </tr>
-
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 out why it wasn't working with mine. My layout: My coding: http://pastebin.com/tH8dve2G Layout with similar coding: http://i47.tinypic.com/30mx0xy.jpg If anyone is familiar with this type of coding and could help/tell me what I need to change or how I can get the scrolboxes to match my layout like the one I found, I would greatly appreciate it. Any tips would be great. Please don't tell me to switch to coding without the tables, that isn't very helpful. Thanks.
-
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.
-
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
-
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, here my cart page code and here my history php where i do the insert part
-
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 the accounting work in accountants' books. I would appreciate if someone knows what could be the best/advisable professional practice.
-
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?
-
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 make any more compact. I can't figure out what I'm missing here. Thanks.
-
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> <tr> <th scope="rowgroup" colspan="2">Header row 1</th> </tr> <tr> <td>Cell 1-1</td> <td>Cell 1-2</td> </tr> <tr> <th scope="rowgroup" colspan="2">Header row 2</th> </tr> <tr> <td>Cell 2-1</td> <td>Cell 2-2</td> </tr> <tr> <th scope="rowgroup" colspan="2">Header row 3</th> </tr> <tr> <td>Cell 3-1</td> <td>Cell 3-2</td> </tr></table> -
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?
-
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->fetch_assoc()) { echo current($row) . '<br/>'; } $conn->close(); return; } echo "<br><br><br>"; echo "The following tables are found in the database " ; echo write_content (); The problem is that conn is a not defined variable.though it worked in a condition with if. Then a second error message is given sounding: Fatal error: Call to a member function query() on a non-object in ..... these errors concern this line: $result = $conn->query($sql);
-
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, but auto play simultaneously without controller functionality in Chrome. My suppositions, but no conclusions from searching... websites created with tables that contain media (anything other than text) are not supported websites created with HTML 4 & tables containing media are not supported files created with All2MP3 app are not supported because the app is too old, latest version 2010 HTML 4 code, specifically the embed tag & attribute parameter syntax automatically created in Dw is not supported the plugin used within Dw CS3 is too outdated I appreciate your assistance! Pic of code attached also. <td width="280" height="50" align="left" valign="top"><font color="#CC3366" size="2" face="Arial, Helvetica, sans-serif"> Unbridled Emotion Mvmt. No. 2</font><br> <embed src="ue2.mp3" width="250" height="16" loop="false" controller="true" autoplay="false"></embed></td>
-
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
-
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 form. 2. Data is stored on a database & manually verified. 3. Certain info from the database is automatically displayed on the site (but not all) in a friendly viewable format. 4. Every time the site is updated a feed is created (like an rss or blog). The first two processes I have achieved, but I am exploring ways of achieving the 3rd & 4th processes. Any advice on what methods or languages would be best to use would be greatly appreciated. I'm happy to learn any coding required. The data set can be stored in various formats (xlsx, csv, ods, tsv, etc), its really a question of the best way to interpret it & automatically display it that I am exploring. Along with creating the feed. Thanks for any advice. Old Guy.
-
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
-
I am Currently having Issues creating this XHTML table for my next assignment. My professor wants me to be able to create this table as shown in the picture, using XHTML code. Im really struggling with the "colspan" and "rowspan" attributes to apply to this code. and to be able to create this table; as shown in the picture. Can anyone with good knowledge in XHTML pleasse help
