Try to change the mysql_query to show errors meaningfully: mysql_query($sql, $sql_connection) or die(mysql_error() . “<br/>Query was: ” . $sql); If you have an error, it will stop execution and you will see both the error and the query that was attempted to be executed. 1 solved Why is my PHP is not inserting data into … Read more
$sql = “INSERT INTO tasks (taskName, requestedBy, details, dateAdded) VALUES (‘$taskname’ ,’$requestedby’ ,’$details’, ‘$datenow’)”; // Removed quotes from columns, and added missing quote on datenow Please note, this technique for adding values into the database is very insecure, and is prone to SQL injection attacks. 5 solved PHP insert into not inserting any data
Introduction If you are having trouble getting your PHP insert into statement to work, you are not alone. Many developers have encountered this issue and have had difficulty finding a solution. This article will provide an overview of the problem and offer some tips and tricks to help you get your PHP insert into statement … Read more
The table name in the INSERT is wrong. And the column list must match the values list. Try INSERT correct table name (target columns) Values (vales for each column). Additionally if you omit any columns the insert will fail unless they have defaults. solved Why does insertion command is giving an error about new operator? … Read more
use update $sql=”update TABLENAME set GAME1 = case when GAME1 = ” then $item3 else GAME1 end, GAME2 = case when GAME2 = ” and GAME1 <> ” then $item3 else GAME2 end, GAME3 = case when GAME3 = ” and GAME1 <> ”and GAME2 <> ” then $item3 else GAME3 end WHERE ID = … Read more