Checking record has been deleted?

Im deleting records and wnating to check it has been deleted to direct to another page or show error if not. Im using ODBC so i cant use the simple mysql_affected_rows and odbc_affected_rows doesnt seem to be working. A sample of what im wanting to do is below. Is any other way around it?

==========

if(odbc_affected_rows() == 1){
'do something'
} else {
'something else'
}
LVL 2
generaliAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
http://de3.php.net/manual/tw/function.odbc-num-rows.php

if(odbc_num_rows() > 0){
'do something, row(s) delete'
} else {
'something else'
}
0
generaliAuthor Commented:
I tried that and it returns an error saying wrong parameter count. I forgot to mention my DB is access and i think that odbc_num_rows() returns -1 for access. So with that ill never meet the true criteria. Is there another way i can check if record has been deleted/updated?

Cheers
0
generaliAuthor Commented:
Just thought i'd add the delete that i checked the above on does actually work on only one row, so the desired result from the odbc_num_rows() should have been 1.
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you have to pass the result handle of the delete operation:

$query = "DELETE ... ";
$result = odbc_exec($dbc, $query);
$rows_affected = odbc_num_rows($result);
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.