Constraint violation inserting into parent table
I am learning PHP/MySQL and ran into this. I have combed through Stack Overflow, but did not find anything that helped me solve the issue.
Query to fetch datas where current date is greater than another field plus one year
I am working on a php project with mysql. In the database i have a table that store users data and in these data there is the medical certificate. When i record the medical certificate i insert the release date (I know that it is valid for one year from this date).
Now i would like to fetch from the database all the users that have the medical certificate outdated. To do this, i use this query but it returns wrong result.. What am I doing wrong? what am I missing? I use DATE_ADD to add one year to medical certificate inside the query:
SQL – Extracting dates within a range spanning multiple years [closed]
Closed yesterday.
Duplicate entries saved in phpmyadmin through php and javascript while we create the process of like dislike button for blogs
I want to create a like-dislike
process in HTML
, CSS
, JavaScript
, PHP
, and jquery
, and for that, I have a database
named ows
, and in this database, I have two
tables named blogs
and rating_info
.
My sql query does not return results when I use a WHERE id = something, thought the value provided is not NULL or zero
PHP and MySQL
My sql query does not return results when I use a WHERE id = something, thought the value provided is not NULL or zero
PHP and MySQL
Trouble with PHP coding
I have trouble with the final Lesson 29 from the book Learn PHP, MySQL and JavaScript. This time I’m using ServBay and when I try to open the site folder I got the error :
how can i insert multiple values of appended select input into mysql database by implode the list
I am working on inputting entries into a database.
i have an input select-option that appends multiple values to another select-option in the form of a list
Outer loop not working in Nested-While-Loop
I have three tables blogs
, comments
and replies
.
Ranking students grades Mysqli
i have an exams table with students scores for each subject in the same table. the problem is that i want to have a rank for each subject of a student. for example what is the students rank in english. the problem is that the ranking seems to be done by comparing all the students subjects. therefore not giving an accurate result.