[SOLVED] How do you delete entries from ODBC using php

[contraboybish]

Ok i have an Access Database that i can read and write to no problems

however, when i try to delete an entry it all seems to run with no

error but the record never deletes!!!!!  The '$_POST[id]' is from a previous page.

 

this is the code i am using.............

 

<?php

require_once('testconnection.php');

 

$query = ("DELETE FROM subscription WHERE subId = '$_POST[id]'") or die (odbc_errormsg());

 

odbc_close($odbc);

header("Location: register_results.php");

?>

 

 

Am i missing something???

 

Please help i'm almost out of frustration tablets :-)

 

Bish

[Barand]

Works better when the query is executed

$query = "DELETE FROM subscription WHERE subId = '{$_POST['id']}'"
odbc_exec($query) or die (odbc_errormsg());

[contraboybish]

ok have just tried your script, to the letter and now i get.....

 

Parse error: syntax error, unexpected T_STRING in D:\bishserver\library\register_delete.php on line 7

 

Any thoughts :-/

 

Bish

 

[chigley]

Paste the code please?

[Barand]

Missed ; at end of first line.

[contraboybish]

This is the code i have now......

 

7:    $query = "DELETE FROM subscription WHERE subId = '{$_POST['id']}'";

8:    odbc_exec($query) or die (odbc_errormsg());

 

The error message now is.....

 

Warning: Wrong parameter count for odbc_exec() in D:\bishserver\library\register_delete.php on line 8

 

Where's it going wrong!!!

 

Bish

 

[paul2463]

try

$query = "DELETE FROM subscription WHERE subId = '{$_POST['id']}'"
odbc_exec($odbc,$query) or die (odbc_errormsg());

[chigley]

<?php

odbc_exec($odbc, $query);

?>

[Barand]

Ah, odbc queries need the connection specifying

 

8:    odbc_exec($conn, $query) or die (odbc_errormsg());

 

where $conn was the value returned by odbc_connect

[contraboybish]

Ok Here is the code now...

 

$query = "DELETE FROM subscription WHERE subId = '{$_POST['id']}'";

odbc_exec($conn, $query) or die (odbc_errormsg());

 

odbc_close($odbc);

 

ok tried the above and i now get....

Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in D:\bishserver\library\register_delete.php on line 8

 

When i add a subscription the code i use is as follows and it works fine...

 

$query = odbc_exec($odbc, "INSERT INTO subscription (subName, subTitle, subAddress, subTelephone, subEmail, subDate)

VALUES('$_POST[name]','$_POST[title]','$_POST[address]','$_POST[telephone]','$_POST[emailaddress]', now())") or die (odbc_errormsg());

 

AAaaaarrrgghh

[chigley]

Don't use $conn, use $obdc.

[Barand]

Call it $aspidistra if you want, so long as it's the value returned when you connected,

[contraboybish]

Looking at all the above and putting it all together.....

 

<?php

 

require_once('testconnection.php');

 

$query = "DELETE FROM subscription WHERE subId = '{$_POST['id']}'";

odbc_exec($odbc, $query) or die (odbc_errormsg());

 

odbc_close($odbc);

 

header("Location: register_results.php");

 

?>

 

I now get a serious looking error message.......

 

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in D:\bishserver\library\register_delete.php on line 6

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

 

I can see me downloading the MDB file from the server deleting the files and uploading it again!! Didn't think this was going to be this difficult!!! :-)

 

Bish

[Barand]

try removing quotes if id is numeric

 

$query = "DELETE FROM subscription WHERE subId = {$_POST['id']} ";

[contraboybish]

Thats it brilliant it works!!!!!

Final code is............

 

<?php

 

require_once('testconnection.php');

 

$query = "DELETE FROM subscription WHERE subId = {$_POST['id']}";

odbc_exec($odbc, $query) or die (odbc_errormsg());

 

odbc_close($odbc);

 

header("Location: register_results.php");

 

?>

 

I have to say this is the first time i have used a forum and you guys

have been brilliant.

 

Many many thanks

 

Bish