Isn't displaying information which I select from database in mysql php

Hello i am trying to find out what the value is in the database (this is like a level system and depending on the level in the database then decides if you have access to the page) so what i am try

View details »

Retriving data from mysql db

Hi bros am working for an api for retriving data from(mysql) three tables with in one call and those three tables are not having any relation like how can I do that. Can anyone help me

View details »

No error, but unable to insert row in a table

Hi I have been working on a flask web app, It has many tables with relation among themselves. One table is users_email. +---------+------------------+ | user_id | email | +---------+----

View details »

mysqli_query only returning results when there's a WHERE statement

MySQL query is only showing information if I have a condition in the SQL statement. I've successfully used the SQL statement in phpmyadmin and it works great. I've changed the table name in the PHP

View details »

How to select count today and tomorrow data less than specific time group by day?

I have a table like a table below. I want to select count and group by day. But the data in 1 day will start counts at 7:00:00 until tomorrow at 6:59:59 (24hr.). For example Day 1 data between '

View details »

Update multiples rows with different ID at the same time

is it possible to do something like this? update table set field ='text' where ID=1 and ID=3 and ID=5 I executed it but no row is updated.

View details »

How can i rewrite this sql script without using exists

I am new to sql. How can i rewrite the below script without using exists select distinct oe.*, o.*, so.* ,ro.* from ms_bvoip_order_extension oe inner join ms_order o on oe.ms_order_id = o.ms_order

View details »

Prepared Statement failing to bind

I am trying to write to a table in PHP, but the prepared statement parameters aren't binding. The parameters in the statement are placeholders, but everything is present in the actual application.

View details »

Use tuple as a foreign key

Let's say i have a table named borrows like this one: CREATE TABLE IF NOT EXISTS `borrows` ( `memberID` int(11) NOT NULL , `ISBN` int(11) NOT NULL , `CopyNr` int(11) NOT NULL , `date_of_borrow

View details »

SQLDependency equivalent in MySQL

For SQL server we have SQLDependany class but what is the equivalent for MySQL. I believe there is one from Dev Art but that has a license cost to it. Is there another free version? OR If I am us

View details »

What is the proper if clause syntax for a MySQL UDF?

I am brand new to MySQL, so I apologize if some of this is relatively elementary. I'm trying to write a UDF to round a digit to a certain number of significant figures. I have a function which, in

View details »

Finding overlapping times from a select statement

Okay, so I have a table (timetable) in a database (calendar) which if formatted like so: +----+--------+-----------+-----------+---------+ | id | name | day | startTime | endTime | +----+--

View details »

i have problem to find MYSQL service in my computer

i install mysql workbench, but whene i go to open my server mysql i got some problem ("failed to connect to MySQL at 127.0.0.1:3306 with user root")==> Table 'performance_schema.session_variable' doesn't exist...

View details »

How can I use rollback() manually

So I am using JavaFX with mysql, and when I click a button, it executes an update and a delete. Another button should do a rollback. But when I click it, nothing happens on the db. Im using the setA

View details »

A field that stores the time the row was inserted and doesn't change it on update

According to what I've read in some posts such as the answer for this question passing null value in a timestamp field will store the date when the row was created, but will update it when row is e

View details »

Should I use view to make fixed conditions query?

If I want to get current day rows in a table,Which approach below is better than each other: Create a view and add where clause (e.g where create_time = curdate()) Create a table, insert rows into

View details »

For each loop with a while loop just shows the first MYSQLI row forever it never shows the other rows

I know eval is dangerous and evil but I need to use this for this situation. Basically I have two different databases that has the same table structure but with different data so I used a for each

View details »

Is it possible to create a folder with files with PHP?

I'd like to create a specific folder with files in it for each user when registered, is that possible with php or mysql? If so, how?

View details »

Select columns of dataframe with a list, python

I do a query to mySql and I form a dataframe df, which has 100 columns with differents type of animals. connection = pymysql.connect(...) query = .. animals = pd.read_sql(query, connection) The a

View details »

Laravel filter model relation

I have a model with relations and I want to return only part of these relations that match a query. But I don't achieve this, every time every relations are return. My models are Lot public fu

View details »