Good Afternoon: I'm a chemistry teacher from Spain. I am not an experimented programmer, but I decided to create a small program to help my students with my subject. I am creating this small program in Java where I'm trying…
I am Involve a CodeIgniter Project.In this project another developer insert cat_id in the database include # separated like #1#. when insert two cat_id the value store in database like #1##2#. Now I want to retrieve the cat_id and join…
I'm trying to get more values in a column and I'm testing it in phpMyAdmin: I have a table Nieuws that contains in this case ID and a Title. Table Nieuws I have a table called Nieuws_tags where I give…
I have multiple tables that don't have indexes nor primary key after migration. There are 9149 entries in some tables and about 10 new entries have been given id = 0. I can't give primary key due to multiple entries…
I am working on a project based on PHP i have an issue that i purchased a hosting whose server is of another country and i am in Pakistan when i enter data in database table from PHPMyAdmin in enters…
No Error in Cpanel but nothing show in browser.. About my code, i need display $result of status by directly from browser "http://www.example.com/exp.php?status=pending" to show table off all pending.. but when i execute in browser only showing "" i'm completely…
Nested query in Sql. SELECT *, (SELECT `supplier_sign_up_id`, ( SELECT email_address FROM supplier_sign_up WHERE supplier_sign_up_id = 42 LIMIT 1 ) FROM `suppliers_acc` WHERE singup_login_id = 138 LIMIT 1 ) FROM `singup_login` WHERE 1; It's give error- Operand should contain 1…
I am trying to create a new table using the mysql GUI in phpmyadmin. This is the error I am getting #1072 - Key column 'id ' doesn't exist in table CREATE TABLE `loginsys`.`groups`( `id` INT NOT NULL AUTO_INCREMENT, `name`…
After updating (through -apt update and apt upgrade) access to the installation of MantisBT has become useless. The databases and users are intact. Access to the server (VPS) through SSH is available and intact. The connection to the database has…
I have this input box on my form: <td contenteditable="true" class="date"></td> and I'm trying to add a date dropdown to it so what I did was: <td contenteditable="true" class="date"><input type="date"></td> And now when I hit send it won't save to…