HTML Navigation Menu Alignment Issue Programming Databases by khan zain "I'm working on a navigation menu for my [HTML](https://iqratechnology.com/academy/html-training/) page, but it's not behaving as expected. The links aren't aligning properly, and the styling seems a bit wonky. I've included the code below. Can anyone help me figure out what's causing this navigation headache? This my Code <!… pass data to another asp page Programming Software Development by Fergus_1 ok so i have a page with a gridview on it and it displays rows from sql table. i have also a link assigned to each row: <asp:GridView ID="GridViewMatters" runat="server" AutoGenerateColumns="False" OnRowDataBound="GridViewMatters_RowDataBound"> <Columns> <asp:… Question Answering with YouTube Videos Using RAG in LangChain Programming Computer Science by usmanmalik57 In previous articles, I explained how to use natural language to interact with [PDF documents](https://www.daniweb.com/programming/computer-science/tutorials/541732/paris-olympics-ticket-information-chatbot-with-memory-using-langchain) and [SQL databases](https://www.daniweb.com/programming/computer-science/tutorials/541771/using-natural-language-… This is me venting Community Center Meta DaniWeb by Dani This is definitely not a targeted attack at *anyone*. Please take it just as me having a bad day and venting. I'm kinda tired of people constantly telling me that I'm the reason that DaniWeb traffic has tanked over the years. And if only I had done this differently. Or done that differently. Or listened to members more about this. Or listened to… Re: What's your favorite productivity hack outside of coding? Community Center by Reverend Jim Odd that something so basic and obvious needs to be named. Of course, "Pomodoro Technique" is a lot shorter than "go hide in the server room so my boss won't keep interrupting me so I can get some work done" technique. At least that's what I used to call it. Re: This is me venting Community Center Meta DaniWeb by Reverend Jim It's hard for me to imagine that all of the pleasure I've gotten out of Daniweb, the challenges, the insights, the friendships since I joined in 2010, are all dependent on the largesse of just one very talented person. I, for one, appreciate all you have done, particularly considering your current health issues. If you feel unappreciated then … Re: This is me venting Community Center Meta DaniWeb by Reverend Jim Also, in non-computing over the years I have heard comments like "if only I hadn't stopped for coffee I would have missed that accident, or several other variations. The thing is you never know what would have happened if you had made different decisions. Certainly making a different decision may have resulted in things being better. Or they … Re: This is me venting Community Center Meta DaniWeb by jkon Dani , yes I also believe that you are responsible for the decline of DaniWeb .... BUUUT that was many years ago. We all foreseen the decline of "forums" back in early 2010's , there were many alternatives of what to do , and I strongly believe that you choose the wrong one. I will not repeat what you did or what you could be done … Re: This is me venting Community Center Meta DaniWeb by Dani > what was missing was a programming hub of news / forum / interviews I have always been a strong proponent of having editorial (news, tutorials, interviews, etc.) complement the user-generated forum discussions. In the past, well over 50% of our gross revenue from advertising went straight into paying for staff writers. IMHO we used to have … Using Natural Language to Query SQL Databases with Python LangChain Module Programming Computer Science by usmanmalik57 The advent of large language models (LLM) has replaced complex scripts with natural language for automating various tasks. You can now use LLM to interact with your databases using natural language, which makes life easier for people who do not have sufficient SQL knowledge. In this article, you will learn how to retrieve information from SQL … Re: How to query database using variable and get all results not just one row Programming Web Development by Mikekelvin To ensure that you're retrieving all records associated with the current user, you need to make sure that your query accurately filters the data based on the user's identifier (variable_name). Here's how you can modify your query to achieve this: // Assuming $currentUser holds the identifier of the current user // Query database to retrieve … Re: How to query database using variable and get all results not just one row Programming Web Development by Chris_103 To retrieve all records associated with the current user, you can use the fetchAll() method instead of fetch(). Here's how you can modify your code: ```php // Query database to retrieve records associated with the user $sql = "SELECT * FROM table_name WHERE variable_name = :variable_name"; $stmt = $conn->prepare($sql); $stmt->… Mariadb10.11.6 Glarea single failed node startup stuck failure Programming Databases by mx_983 Basic background information Mariadb Ver 15.1 District 10.11.6 MariaDB Glarea cluster, one with three nodes: Node1:192.168.18.78 Node2: 192.168.18.79 Node3: 192.168.18.80 Among them, Node1 node was restarted after a power outage of 1 hour, and after executing the system ctl start mariadb, it was stuck for a long time (running for 6 hours) … Re: How to query database using variable and get all results not just one row Programming Web Development by Biiim logically, it would be because `WHERE variable_name = :variable_name` matches 1 row in your table maybe try a `var_dump(str_replace(':variable_name',"'some_value'",$sql));var_dump($records);`? run the sql on whichever way you use to access your DB directly I don't use PDO so i'm not too familiar on how it returns results, either … Re: Improve HAVING BY performance Programming Databases by toneewa I'm a little late to the party, however, I want to share my experience learning MySQL in the past day. I setup a server, a database, and wrote a C++ program to connect to it. It measures the times for 3 SELECTs. The whole product list, using HAVING, and WHERE. I also tested reversing the orders. Query execution time: 0.0002336 seconds … Re: Online subission forms not sending emails of submitted info Programming Web Development by Biiim Hi David, > More problems. I incorporated the coding Biiim provided. Before any changes, after submission, would display the correct (yellow) screen. After code changed, not only will still not send email but screen turns blank white. URL provider, IONOS, told me that the Host is smtp.ionos.com and the Username and password are for an email… Re: Online subission forms not sending emails of submitted info Programming Web Development by Biiim In your code where you write `mail($to,$subject,$message,$headers);` if you want to get error messages or "do something if it fails" you need to alter it a bit to something like: if(mail($to,$subject,$message,$headers)){ //if successful do something }else{ //if error do something else } //or… Re: Improve HAVING BY performance Programming Databases by Biiim > I don't have experience with MariaDB, but in MySQL, something like that will work as long as I do SELECT sum(points) AS total FROM ... HAVING total > 10. Is that what you were getting at? Kind of, MariaDB is a fork of MySQL from around 2009 or something like that, MySQL 5.* and the creator continued developing MariaDB and Oracle took … Re: Improve HAVING BY performance Programming Databases by Dani > I know that in my experience, OR's are very bad for speed you can get away with a few but they can get very bad when they stop the whole query making use of one of the main indexes, you can actually speed it up by moving the or's into the HAVING usually. Thank you for that tip! I never thought of that, but it totally makes sense!! > … Re: Improve HAVING BY performance Programming Databases by Dani Here are some articles that can explain it in greater depth: * https://web.dev/learn/performance/why-speed-matters * https://developer.mozilla.org/en-US/docs/Learn/Performance * https://web.dev/explore/fast The HTML page must be downloaded in its entirety before the web browser can begin loading anything else (CSS, Javascript, images, etc.)… Re: Online subission forms not sending emails of submitted info Programming Web Development by Dani I wonder if the problem is that your php mail() function is configured to use SMTP in your php.ini file. A lot of SMTP servers switched over the past year or so to using XOAuth2 for authentication. A username + password in your config settings will no longer suffice to establish a connection. You can see me complaining about it [here](https://www.… Re: AirTM API: How to Build a Form? Programming Web Development by Dani I can see that the URL that you linked me to has 4 steps to create a purchase. The first one is to create a Purchase via an HTTP POST request. That can be done with a cURL request. cURL requests require some backend programming such as via PHP or some other language. Are you using a server-side language to write your web app? If so, which one so… Re: Do you participate in any other communities? Community Center Geeks' Lounge by Dani I was talking to Chris (the DiC founder/owner) a little bit before he decided to shut it down. He was saying he's been so busy with his other businesses that he spent maybe 5 minutes on it over the past 5 years, so he lost interest, and it wasn't paying its server costs. At least in the case of DaniWeb, it *also* isn't even coming close to … Re: Online subission forms not sending emails of submitted info Programming Web Development by Biiim You don't need composer or access to the php.exe. just locate the PHPmailer Directory into your web root, to keep it simple and the require links should point to where it is located. mine is `require 'includes/PHPMailer/src/PHPMailer.php';` cause I put it in a folder called includes, this should be relative to the file that is using it.… Re: Improve HAVING BY performance Programming Databases by Biiim > INSERT INTO electronics.products(ProductID, ProductName, Price) VALUES ('1','capacitors', 2.50), ('2','resistors', 4.50), ('3','rectifiers', 7.50), ('4','diodes', 10.00), ('5','ICs', 25.00), ... ('50000','...', ...); I don't see any mention of an index on it & your benchmark indicates you don't have one: ALTER TABLE `… Re: Online subission forms not sending emails of submitted info Programming Web Development by david.tigner More problems. I incorporated the coding Biiim provided. Before any changes, after submission, would display the correct (yellow) screen. After code changed, not only will still not send email but screen turns blank white. URL provider, IONOS, told me that the Host is smtp.ionos.com and the Username and password are for an email address associated … Re: ASUS Laptops - my experience Hardware and Software by Reverend Jim I called Best Buy Friday morning to ask about the status of my laptop. I was told the average wait time was one minute. Fifteen minutes later I was told there were eight calls ahead of me and would I like to leave my number for a callback. I did so and after two more hours of waiting I called the local Best Buy direct. I was told my laptop would be… Re: Online subission forms not sending emails of submitted info Programming Web Development by Dani > After code changed, not only will still not send email but screen turns blank white. That's a PHP fatal error. It could be a syntax error, or it could also be that PHPMailer is not in the location you're telling PHP to look. Do you have any way of accessing the error log? Without access to the server, perhaps through a web-based control … Re: Mariadb10.11.6 Glarea single failed node startup stuck failure Programming Databases by rproffitt From https://stackoverflow.com/questions/78269177/mariadb10-11-6-galera-single-failed-node-startup-stuck-failure where they call it out as a bug waiting for a fix. Re: Mariadb10.11.6 Glarea single failed node startup stuck failure Programming Databases by rproffitt The problem is still unresolved. Until the bug is fixed. Be sure to tell all that you don't accept this as a bug and want a fix now.