When I make a connection to my MYSQL database (hosted on phpmyadmin on a domain with hosting, not localhost), I receive an error that I'm denied access to the server entirely. What is going on? I'm not extremely familiar on…
I am simply trying to use insert_batch() but it's not even inserting in my table as well and not even showing an error. But I am sure the flow of control has passed through the function insert_batch(). I have tried…
I need to select all rows added in the last week in the database. This is for a "Top 5" page which should show the most sold products over the past 7 days. I tried: SELECT order_id FROM orders WHERE…
I am very New with php and Database... I have a File where Display the Comment, contact.php , here to schow it and my Css, because codepen have only for JS , the Comment form not to Display , the…
I am trying to create a new table in a database each time a user submits a form. I take the information they submitted and use that to name the new table I create. However when I query the database…
I have a table with around 100 medicine interactions. I'm trying to make a statement where I insert X amount of drug names and it returns all rows where those drug names present in the first two columns. If a…
I have data in my PHPMYADMIN in a few columns and rows. Via PHP I read the Data out of my SQL Table and print it into a table. The last of my table is a action button. So the…
I'm try to select "max(TxnDate) as txDate, [account name dr], [credit usd]" and I got an error "query does not include the specified expression 'credit usd' as part of an aggregate function" in excel VBA programming but in work find…
I have a simple code (very simple one) that I was using to try something out for a work and I was trying a function to work with the variables of a form radio in post method, to update my…
I need to write a query which must include use of INNER JOIN, but did not manage to write it correctly. In PhpMyAdmin, I created a database with two related tables of users: Table #1 is called "Usertype" and has…