March 30th, 2003, 11:00 AM
|
|
Registered User
|
|
Join Date: Mar 2003
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Problems trying to use DELETE
Hi,
I'm trying to create a forum (which I've done but iot doesn't look very pretty!). So far you are able to post a message and read the posts but I am having trouble deleting posts.
So far I have two files, one called delete.php
PHP Code:
<?php
// This is the DSN we have create for our database
$connect = odbc_connect("forum", "root", "");
?>
<html>
<body>
Discussion Forum using PHP/Access under IIS<br /><br />
<?php
shownode(0); // display all the main threads
// This function is a recursive function which shall display all the br /anches
// and sub br /anches of the threads
function shownode($nodecode)
{
global $connect; // using the global variable for connection
// Get a list of all the sub nodes which specific parentcode
$noderesult = odbc_exec($connect,"select * from forum where parentcode = $nodecode");
echo '<ul type="disc">';
while(odbc_fetch_row($noderesult)) // get all the rows
{
$code = odbc_result($noderesult,"code");
$title = odbc_result($noderesult,"title");
$uname = odbc_result($noderesult,"uname");
$email = odbc_result($noderesult,"email");
echo "<li>";
echo "<a href=\"delete_post.php?node=$code\"> $title </a>";
echo "-- by ($uname) $email<br />";
shownode($code);
}
echo "</ul>";
}
?>
</body>
</html>
which lists all the messages so you can pick one to delete. Then when you click on the one you want to delete you go to delete_post.php
PHP Code:
<?php
$code=$_GET['node'];
$connect = odbc_connect("forum", "root", "");
//print_r($_GET['node']);
// insert the record in the database
$resultupdate = odbc_exec($connect,"delete from forum where node= '".$code."'");
header("location:forum.php"); // open forum.php file to display the thread
exit;
?>
When I uncomment the print_r it displays the correct node to be deleted but when I try to delete it I get this error
Quote: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect in c:\phpdev\www\mywork\forum\delete_post.php on line 6
Warning: Cannot add header information - headers already sent by (output started at c:\phpdev\www\mywork\forum\delete_post.php:6) in c:\phpdev\www\mywork\forum\delete_post.php on line 7 |
I think I understand the problem with the header but I don't know why the syntax is wrong.
If I just tell it to delete all the entries that works fines but obviously I don't want to do that!
Any help would be greatly appreciated I've been Goggling for hours and nothing seems to work always the same or similar SQL Error
Thanks,
Tom
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
