Can’t insert data into mysql database using PHP [closed]

by

Edited:

Try just adding this code:

<?php
$message = mysql_real_escape_string(bbcode_to_html($message));

$sqlquery1 = 'insert into topics (id_parent, id, id_user, title, message, id_author, timestamp, timestamp_user) select "' . $dn1['id_parent'] . '", "' . $id . '", max(id_user)+1, "", "' . $message . '", "' . $_SESSION['userid'] . '", "' . time() . '", "' . time() . '" from topics where id="' . $id . '"';

$sqlquery2 = 'update topics set timestamp_user="' . time() . '" where id="' . $id . '" and id_user=1';

$result1 = mysql_query($sqlquery1) or die(mysql_error() . ": Full Query was: " . $sqlquery1);

$result2 = mysql_query($sqlquery2) or die(mysql_error() . ": Full Query was: " . $sqlquery2);

if ( $result1 and $result2){
    ?><header class="major">
    Komen sukses! Kembali ke <a href="https://stackoverflow.com/questions/31281199/read_topic.php?id=<?php echo $id; ?>">Topik!</a>
</header>
<?php
}else{
    echo 'Terjadi kesalahan saat mengirim komen!';
}
?>

This will now also show you the query you tried to execute. This will help if you want further questions answered well.

More Related Contents:

  1. How to avoid to display this error in PHP?
  2. Disappears \ from db value [closed]
  3. Why shouldn’t I use mysql_* functions in PHP?
  4. PHP – Using PDO with IN clause array
  5. How to get ID of the last updated row in MySQL?
  6. Invoking a PHP script from a MySQL trigger
  7. When should I use MySQLi instead of MySQL?
  8. How to repair a serialized string which has been corrupted by an incorrect byte count length?
  9. Fatal error: Uncaught Error: Call to undefined function mysql_connect()
  10. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result [duplicate]
  11. PDO binding values for MySQL IN statement [duplicate]
  12. PDO mysql: How to know if insert was successful
  13. php / Mysql best tree structure
  14. Trying to get property of non-object in [duplicate]
  15. PHP & MySQL Pagination
  16. How to write a REST API?
  17. how to access the command line for xampp on windows
  18. PHP inserting multiple checkbox AND textbox arrays into MySQL Database
  19. How can I solve incompatible with sql_mode=only_full_group_by in laravel eloquent?
  20. PHP, MySQL and Time Zones
  21. How do I loop through a MySQL query via PDO in PHP?
  22. display data from SQL database into php/ html table [closed]
  23. Getting time difference between two times in PHP [duplicate]
  24. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  25. Is there a way to show a WHERE clause just for one field in MySQL?
  26. MySQL Stored Procedure vs. complex query
  27. Finding free blocks of time in mysql and php?
  28. Backup a mysql database and download as a file
  29. Is a BLOB converted using the current/default charset in MySQL?
  30. PHP/MySQL Pagination

Leave a Comment