I'm creating a simple php program and I'm trying to find a way to be able to go from the page 2 back to the page 1 with a button. I tried by making a button in
The SNO seems to be misdirecting So, I simplified the question even further --creation CREATE TABLE LAB (JOB_ID int, LAB_ID VARCHAR(50)); CREATE TABLE SPR (JOB_
I need to fill multiple different arrays by using a MySQL query. This would have up to 16 different arrays. I want to specify each array with
I have this Existing table tb1 in my database Now new data comes and new data is stored in another table tb2 Earlier Account_Number 9988 was Level 2, But now
I have a table like below with two columns Person and Supervisor. Person Supervisor 1 3 2 3 3 4 I want to select rows where the Supervisor column only has val
I opened PopSQL and the there is a red dot at my connection. If I go into it and test it, it tells me Unknown database 'giraffe'. I opened mySQL and typed 'show
I am trying to find the average number of rental books for each quarter. Rental(RegNum, DateBorrowed, DateReturned) Books(RegNum, BookName, Category) What i am
I have a table called products which has a varchar column called name encoded in latin1_swedish_ci. I'm trying to make a search query in order to filter product
I am looking for some help. I need to create a dependent dropdown based on the previous input. Everything works in my code, and it sends and receives data from
I'm working on a student project. I'm building an e-commerce website to sell soaps, and the error message I'm getting is the following. Fatal error: Uncaught E
I'm trying to make a secure connection with my database I wrote the following code: <?php // form filled? if (isset($_POST['submit'])) { $user = 'gebrui
I am running a MySql 8 DB and using Visual Studio 2017. Here is my VB code. Try With prm .Direction = ParameterDirection.Input .MySqlDbType
i have two 3 files 1 for the database and the others is for add the data and the index but my adddata.php doesn't catch the value and just ret
I am building a chat application like discord, I can successfully send a chat message, and i am trying to send emojis, files like image, pdf, docx, links. How t
after 4 days of tries and researchs over the web I can't make my wishes working. Any help would be appreciated !Performed on MYSQL WORKBENCH I got a DB made of
I have an API: https://baseballsavant.mlb.com/gf?game_pk=635886 I want to fetch the data from here (which is in JSON format) using a python code and create a ta
I want a select that if/exists it returns the 'link' value instead of regular output. so instead of '1' it returns the 'link' Is that possible? SELECT IF( E
I am trying out prepared statements, but the below code is not working. I am getting the error: Fatal error: Call to a member function execute() on a non-objec
I would like to configure PhpMyAdmin to access only one database through one user. I tried before to restrict access via .htaccess using this answer from 2013 b
I have a problem with my PHP and MySQL code. I was creating a private messaging system but unfortunately, each time I reload the page, the las