I have just used a select with a select for the first time. It seems to work and I am getting the desired result when I run it in phpMyAdmin. However, when I then use $variable = mysql_num_rows($queryresult); I get…
I've been working with a simple MySQL table using Docker Compose that only included ID and NAME column. I attempted to update my myDb.sql file that initially creates the table like this: CREATE TABLE `Person` ( `id` int(11) NOT NULL,…
I have 2 tables. The first, called stazioni, where I store live weather data from some weather station, and the second called archivio2, where are stored archived day data. The two tables have in common the ID station data (ID…
I am a complete beginner when it comes to PHP and mySQL. I am currently working on a simple project where a user would go to a form created in HTML and fill out some information and when they hit…
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 am trying to modify some PHP code that was created ages ago in Codecharge, to include a Group By clause in a MYSQL statement. I have tested my MYSQL query and it works brilliantly in phpmyadmin. When I bring…
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'm trying to write a function in php that will allow me to return an array of objects (in my case the objects are the rows in my database(MySQL) from phpMyAdmin) into a Json format. Here is my function: public…
After I installed the latest version of PHP 7.3.4 and MySQL Community Server 8.0.15 I faced this error on my phpmyadmin 4.7.7: Warning in .librariesconfigFormDisplay.php#661 "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? Backtrace…
Hello everyone and best regards, To clarify the question, I have a table of users in my database on phpMyAdmin. Each time the user logs in, a column that is called "UserActivity" type DATETIME is updated in the table to…