Simple Record Delete Problem

mbrown174

Hello,
I am attempting to delete records from my database and each time I do I get an error. I have two pages. The first page displays a number of records, to the right of each record is a delete option. The delete option when clicked goes to delete.php

Here is my code for the main page.
<?php do { ?>
<?php echo $row_DeletePost['user']; ?><?php echo $row_DeletePost['Title']; ?><?php echo $row_DeletePost['Date']; ?><a href="Delete.php">Delete</a><br/>
<?php } while {$row_DeletePost = mysql_fetch_assoc($DeletePost)); ?>

This is the code for the delete page...
<?php
require_once('Connections/Forum.php');
$id = $row_DeletePost['Title'];
mysql_connect("$hostname_Forum", "$username_forum", "$password_Forum") or die("cannot connect");
mysql_select_db("$database_Forum")or die("cannot select DB");
$query='Delete from forum where Title = $id;
$result=mysql_query($query);
?>

NogDog

You did not close the quotes on the line where you defined the query. Also, if 'title' is a string, then $id will need to be quoted in the SQL:

$query="Delete from forum where Title = '$id'";

Also, please use the forum's

[/b] bbcode tags around your code samples so that they are (much) easier to read.

mbrown174

It still hasnt worked - this is my code now...

Code for Deleted.php

<?php
require_once('Connections/Forum.php');
$id = $row_DeletePost['Title'];
mysql_connect("$hostname_Forum", "$username_Forum", "$password_Forum")or die("cannot connect");
mysql_select_db("$database_Forum")or die("cannot select DB");
$query="DELETE FROM forum WHERE Title = '$id'";
$result=mysql_query($query);
?>

Code for main page

<?php do { ?>
  <?php echo $row_DeletePost['User']; ?>  <?php echo $row_DeletePost['TimeofPost']; ?> 
  <?php echo $row_DeletePost['Title']; ?> | <a href="delete.php">DELETE </a><br />
  <?php } while ($row_DeletePost = mysql_fetch_assoc($DeletePost)); ?>

Again Thanks for helping!

fean0r

have you tried checking the $id exists?

mbrown174

sorry i guess i should have tried a bit harder to work out the problem. instead i just found a small tutorial
http://www.netadmintools.com/art333.html
This does more or less what I want anyway. But really thanks for your help as I now the meaning of some php error messages...