Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. order of matching results

    You can always have it order by multiple columns so if multiple rows have the same value for the first sort column then it will use the next, etc. Otherwise, consider the result of the sort undefined and subject to change at any point. If you need it in a specific order then specify the order.
  3. Yesterday
  4. Portfolio CSS

    Oh, the filter is going to cause some trouble. Even though the elements aren't visible, they're still there and are counted for in the nth-child() selectors. I can't immediately think of a CSS solution for that, you probably will need to write a Javascript program to determine which elements need a break before them.
  5. Portfolio CSS

    OK, looks like the "nth-child(2n+1)" counter does not reset when we click on a filter. Example here: https://www.w3schools.com/code/tryit.asp?filename=FNRBNZD4GKHX On the initial display, we have a new line for: - Image #1: Mountains - Image #4: Retro - Image #7: Man When we click on a filter, the new line triggers are always on the same 3 initial images. Run the test and then click on the "People" filter to see what I mean. The initial image #7 "Man" is on a new line.
  6. Contact Form.

    Hello Ingolme Thanks for getting back to me and sorry for the delay in replying. I'm very new to all this coding, so it takes a while to get my head around the language. I'll take a look at your suggestion tomorrow and get back to you.
  7. order of matching results

    I'll have to double check that. the primary key is a unique ID for each entry, so numeric value , could be that.
  8. order of matching results

    It probably depends on the database engine. I believe it may try ordering by the primary key if the rest of the fields are the same.
  9. order of matching results

    My experience of how mysql determines what result goes first varies, that why I use the ORDER BY keyword.
  10. order of matching results

    This isn't a bug or a how too inquiry, I know how to order items with mysql queries. What I am wondering though is, how does mysql determine what result goes first between 2 matching results? A quick example, I do a SQL Query ordering by "total wins", so a numeric value. 2 people have 7 wins each, how does the SQL Query determine the order for the 2 people? In my testing of leagues that am coding, I actually have two divisions of 8 people with 7 wins/ 7 losses each, always showing on leaderboard at same position. I am thinking its ordered by who was added first to database table? but am not sure if mysql has the capability to remember that? As I said, its not a bug or a big deal really, am just curious on this. I also figured I might get asked in future by someone playing my game.
  11. It's OK. I have figured out a solution. I will generate the variable HTML code dynamically outside the template and then insert the result as the value of an HTML template variable that serves as a placeholder for the dynamically generated content within the template.
  12. How to get an iframe with no borders ?

    Height 100%, for browser viewport height won't work unless all direct parents have height: 100% up to and including html element, OR you give the closest parent height: 100vh; which is viewport height. any margins, padding borders will be addition to this height. html->body height: 100% OK! table direct child of body has no height: 100% FAIL! it will collapse, td height will collapse to content height. resize? depending how you implement it, try it see hover effect of iframe src page? from parent main page? you don't you apply css directly on the iframe src page itself. Don't know why that would happen?
  13. It would be easier to address this if you could show examples of your template and maybe the data.
  14. How site's admin manage their site ?

    https://codex.wordpress.org/WordPress_Screenshots
  15. Contact Form.

    The mailto protocol doesn't provide a way to set the "From" address. It lets you set the subject and body. In order to do that, you have to give the inputs the correct name attribute: <input name="subject"> for the subject, <input name="body"> for the body. If you want more sophisticated mail functionality you're going to have to work with server-side programming.
  16. Contact Form.

    Hello I'm using one of w3 schools responsive templates to build my site. I've put in a contact form but I'm not sure if it's responding correctly? An e mail box does pop up but no name of sender or email address of sender, nor any message. I've attached screen shots, if anyone can confirm where I'm going wrong that would be much appreciated. Many Thanks Martin
  17. EASY FOR YOU (php javascript) !!

    Javascript cannot pass data to PHP. PHP runs first on the server, generates Javascript code and then sends that Javascript code to the browser to be executed. If you need any server-side work done after that then you will have to use AJAX. Here is the AJAX tutorial: https://www.w3schools.com/js/js_ajax_intro.asp
  18. How to get an iframe with no borders ?

    Please respond , Thanks
  19. Google Custom search

    If it was just that, then you could reset it by setting the box-sizing to content-box. In the case of your site, this probably will work: #___gcse_0, #___gcse_0 * { box-sizing: content-box; } I tried that, though, but there are more issues. It seems to be that setting the line-height to 1.5 is also messing with the layout, so you would need to reset that too. .gsc-input { line-height: normal; } I don't know if this will solve all the layout issues.
  20. EASY FOR YOU (php javascript) !!

    don't understand your question
  21. BULK UPDATE

    need to do a join https://www.w3schools.com/sql/sql_join.asp
  22. BULK UPDATE

    Hi All, I am hoping someone can point me into the right direction with this one. So i have two databases, the one is used to update costings (dbs1) for different products using multiple tables. The other dbs (dbs2) is used to store costings of an existing project I then at the end of my design process use a query to update dbs1 with dbs2. here is the syntax; THIS WORKS... UPDATE SSRevitProject1.dbo.WindowTypes SET Cost = new.Cost FROM SSRevitCostings.dbo.SSParkHomeCostings AS new WHERE SSRevitProject1.dbo.WindowTypes.Model = new.Model THIS DONT WORK... UPDATE SSRevitProject1.dbo.CaseworkTypes SET Cost = new.Cost FROM SSRevitCostings.dbo.SSContainerCostings AS new WHERE SSRevitProject1.dbo.CaseworkTypes.Model = new.Model The problem i have is that SQL is for some reason not using one of my tables in dbs1 to update dbs2. I hope this is clear enough.
  23. Eloquent way to vertically align text and images

    You don't need flex or table styling, vertical-align will achieve that on its own, but you do require container that will use display: inline-block around title(h4?) and paragraph for stacking, which I think is what you meant. With max-width to prevent text extending beyond that of container boundary width. <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta name="viewport" id="viewport" content="target-densitydpi=high-dpi,initial-scale=1.0" /> <title>Document Title</title> <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script> <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jqueryui/1.10.4/jquery-ui.min.js"></script> <script type="text/javascript"> </script> <style type="text/css"> .vert-align { text-align: center; } .vert-align > * {vertical-align: middle; display: inline-block; padding: 0 1%; text-align: left; max-width: 73%;} .vert-align img:first-child {max-width: 23%; min-width: 290px; } </style> </head> <body> <div class="vert-align"><img src="https://www.w3schools.com/html/pulpitrock.jpg"/><div><h4>Header TODO write content</h4><p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. </p></div></div> </body> </html>
  24. Combining and comparing date and time

    Okay, thanks for reply.
  25. Google Custom search

    Anyone?
  26. EASY FOR YOU (php javascript) !!

    spirit of my code : <html> here a button on click for script here an element <p with id="demodemo" <script type="text/javascript"> function myFunction() { var abc= "REF1"; document.getElementById('demodemo').innerHTML = abc; ?php here I need abc how ? is there 2 methods ? thanks for your help ?> } </script> </html>
  27. Combining and comparing date and time

    The end time can be calculated by a server-side programming language prior to being added to the database.
  1. Load more activity
×