Search the Community
Showing results for tags 'not'.
-
Hi There, I have two questions about SQL syntax, the first one is about "SELECT DISTINCT" and the other is "NOT". Question 1: For example, "Customers" table has fields including CustomerID, CustomerName, ContactName, Address, City, PostalCode, Country. From my understanding, if my SQL statement is SELECT DISTINCT Country FROM Customers; then it will show the list of unique countries. However, I'd like to know what does it mean if my SQL statement is SELECT DISTINCT Country, City, CustomerName FROM Customers; ? Why I don't have to write SELECT DISTINCT Country, DISTINCT City, DISTINCT CustomerName? You may refer to this session: https://www.w3schools.com/sql/sql_distinct.asp Question 2: I'm working on the session, and there's an example as below: I understand that this example would like to exclude BOTH Country = "Germany" and Country = "USA", but I don't understand why using the operator [AND] instead of [OR]? Doesn't [AND] represent the intersection while [OR] mean union? So, if I want to exclude BOTH "Germany" and "USA", why I can't use [OR] as the operator in this example?
- 2 replies
-
- sql
- syntax question
-
(and 2 more)
Tagged with:
-
Hi!I recently programmed a Websit and put it on XAMPP, only to see that the PHP include command responisble for the Website does'nt work.Here is the HTML: <!doctype html><html><head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width" /> <title>About me.</title> <link rel="stylesheet" href="style.css" /></head><body> <header> <h1>My Pages.</h1> </header> <?php require 'sidebar.php'; ?><div id="main" margin-top="5px"> <div id="ut"> <h2>Lorem Ipsum</h2> Dolor sit amet. </div> Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas tincidunt sodales tellus et condimentum. Vestibulum ac magna ac enim venenatis porttitor vel a lorem. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi placerat massa fermentum justo tempor in rutrum erat tempor. Phasellus tempus rhoncus odio, id mattis ipsum viverra id. Fusce in lectus vel dolor interdum laoreet. In ut mi velit. </div> </div></body></html> and here is the sidebar.php: <html><body><div id="sidesec">The Sidebar of Doom!<br>-------------------------<br><ul style="list-style-type: disc; text-align: left;"><li><a href="#">Home</a></li><li><a href="#">About me.</a></li></ul></div><div id="sidesec">Lorem Ipsum<br>dolor sit amet,</div></div>';?></body></html> I've tried it on multiple browsers now, but it does not show the sidebar. Please tell me what i'm doing wrong, as I have no more Idea what to try.
-
this is my SQL: SELECTprodukter.p_id,produkter.p_titel,produkter.p_kunstner,produkter.p_oprettet,image_url.img_url,genre.g_navn,priser.pr_prisFROMprodukter INNER JOIN produkter ON produkter.p_FK_pris = priser.pr_id INNER JOIN image_url ON image_url.img_FK_products = produkter.p_id INNER JOIN genre ON produkter.p_FK_genre = genre.g_id and i cannot see what the heck is wrong... ideas?...and how to fix ect Oo...
-
I have an xml blog and a javascript file i am trying to use to publish this blog to a website with. I am just testing to see if AJAX is working at all because i have been having issues with this for a day now. Here is the Javascript code: function blog(){var xhr = new XMLHttpRequest(); xhr.onReadyStateChange = function(){if(xhr.readyState == 4 && xhr.status == 200){var xmldom = xhr.responseXML;alert(xmldom.documentElement);}} xhr.open("GET","blog.xml",true);xhr.send();} Here is the xml code: <?xml version="1.0" encoding="UTF-8"?><rss version="2.0"><channel><item><title>hello</title> <link>www.google.com</link> <description>world</description></item><item><title>hello</title> <link>www.google.com</link> <description>world</description></item><item><title>hello</title> <link>www.google.com</link> <description>world</description></item></channel> </rss> Finally, here is the HTML code: <div id="blog"><h4>News Updates</h4><script type="text/javascript" src="blog.js" async></script><button type="button" onclick="blog()">click me</button></div> I have it set up to where the button in the HTML code has the onclick event listener that calls the javascript "blog()" function. the problem is that i never does anything NO MATTER WHAT I DO. it is always unresponsive. I never get a single alert box no matter what i make the script do inside the onreadystate function.