How to insert database rows if there are no answers

by

Simply do not insert anything into Answer table when there is no answer. Rest of your solution is basically correct.

When displaying questions with answer, check if there is answer (empty select result or null in left joined column) to show and if not, show “No answer”. But there is no “No answer” in database.

More Related Contents:

  1. mysqli or PDO – what are the pros and cons? [closed]
  2. AJAX request callback using jQuery
  3. using jquery $.ajax to call a PHP function
  4. mysqli_query() expects at least 2 parameters, 1 given
  5. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  6. Strict Standards: mysqli_next_result() error with mysqli_multi_query
  7. Why does mysqli num_rows always return 0?
  8. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  9. What is the difference between MySQL, MySQLi and PDO? [closed]
  10. PHP/Apache/AJAX – POST limit?
  11. Retrieving Multiple Result sets with stored procedure in php/mysqli
  12. jQuery AJAX form using mail() PHP script sends email, but POST data from HTML form is undefined
  13. How do I count query result rows?
  14. Long Polling/HTTP Streaming General Questions
  15. How do you use IN clauses with mysqli prepared statements [duplicate]
  16. What to do with mysqli problems? Errors like mysqli_fetch_array(): Argument #1 must be of type mysqli_result and such
  17. Jquery ajax setTimeout after form succes not redirecting?
  18. How to fetch all in assoc array from a prepared statement?
  19. Fatal error: Call to undefined function mysqli_result()
  20. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  21. Why I am getting an error when using w3school tutorial? [duplicate]
  22. Using wildcards in prepared statement
  23. How to remove the fatal error when fetching an assoc array
  24. Show hide custom Woocommerce checkout field based on selected payment method
  25. Fatal error: Call to undefined method mysqli_stmt::get_result()
  26. Set character set using MySQLi
  27. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  28. How to get a list of databases?
  29. Get the last modified date of a remote file
  30. jQuery Mobile: Sending data from one page to the another

Leave a Comment