Databases
StackOverflow2013
Postsdbo
POWhat am I doing wrong? Messages won't delete
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhat am I doing wrong? Messages won't delete
    primarykey
    data
    text
    <p>Ive been working on my delete.php file to delete selected messages for literally hours on end without any headway. How would I delete messages with the codes I have set up?</p> <p>Heres the code to how my delete.php is set up right now</p> <pre><code>&lt;?php session_start(); header("Location:inbox.php"); $user = $_SESSION['username']; include 'connect.php'; foreach($_POST['messages'] as $num =&gt; $messages_id) mysql_query("DELETE FROM messages WHERE messages_id='$messages_id' AND to_user='$user'"); ?&gt; </code></pre> <p>Here's the code to my entire inbox.php </p> <pre><code>&lt;?php require "connect.php"; echo "&lt;hr&gt;&lt;br&gt;&lt;div id='mail'&gt;"; // get the messages from the table. $get_messages = mysql_query("SELECT messages_id FROM messages WHERE to_user='$userfinal' ORDER BY messages_id DESC") or die(mysql_error()); $get_messages2 = mysql_query("SELECT * FROM messages WHERE to_user='$userfinal' ORDER BY messages_id DESC") or die(mysql_error()); $num_messages = mysql_num_rows($get_messages); // display each message title, with a link to their content echo '&lt;ul&gt;'; for($count = 1; $count &lt;= $num_messages; $count++) { $row = mysql_fetch_array($get_messages2); $fromuser = $row['from_user']; $messageid = $row['messages_id']; $messagetitle = $row['message_title']; $messageread = $row['message_read']; $messagedate = $row['message_date']; echo " &lt;form name='send' method='post' action='delete.php'&gt;&lt;input type='checkbox' name='delete' value='$messageid'&gt;&lt;/td&gt;&lt;font face='helvetica'&gt;&lt;font size='3'&gt;$fromuser&lt;/font&gt;&lt;/font&gt; &amp;nbsp; &amp;bull; &amp;nbsp; &lt;div align='right'&gt;&lt;a href='read_message.php?messages_id=$messageid'&gt;$messagetitle&lt;/a&gt;&lt;/div&gt; &lt;center&gt;&lt;hr&gt;&lt;/center&gt; "; } ?&gt; &lt;input type="submit" name="Submit" value="Delete Selected"&gt; &lt;/table&gt; &lt;/div&gt; </code></pre> <p>Please help out before my head explodes</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USUltraCommit
    1. USJamal Stanfield
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COCould you show us the entire html doc (or the form elements in order?). Also, add `or die(mysql_error());` to the end of the `mysql_query()` so it should look like `mysql_query("DELETE FROM messages WHERE messages_id='$messages_id' AND to_user='$user'") or die (mysql_error());` That will tell us if it is an error with the query. Though don't leave it, not a good thing to have floating around on a live site.
      singulars
      1. POWhat am I doing wrong? Messages won't delete
      1. USBen
    2. COa) Run mysql_real_escape_string on variables used in the query. b) Print your query to see what delete stament actually looks like on submit.
      singulars
      1. POWhat am I doing wrong? Messages won't delete
      1. USAR.
    3. COmaybe some relating coulmens are wrong or somthing?
      singulars
      1. POWhat am I doing wrong? Messages won't delete
      1. USfingerman
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload