| Re: getting amount of deleted rows from: $result=odbc_exec($conn, 'delete from....'); [message #169499 is a reply to message #169497] |
Wed, 15 September 2010 13:53  |
Captain Paralytic
Messages: 204
Registered: September 2010
Karma:
|
Senior Member |
|
|
On 15 Sep, 13:50, jodleren <sonn...@hot.ee> wrote:
> On Sep 15, 3:03 pm, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
>
>
>
>
>> On 15 Sep, 10:21, jodleren <sonn...@hot.ee> wrote:
>
>>> As the header says:
>
>>> $result=odbc_exec($conn, 'delete from....');
>>> echo ".... rows deleted";
>
>>> I want to know how much I deleted.... probably very simple, but hard
>>> to find :)
>
>>> Sonnich
>
>> Oh it was just SOOOO hard to find.
>
>> I had top search google for
>> php odbc rows deleted
>> and lo and behold a link tohttp://php.net/manual/en/function.odbc-num-rows.php
>> as the second site reference with the abstract:
>> This function calls SQLRowCount, which according to the ODBC
>> Specification returns "the number of rows affected by an UPDATE,
>> INSERT, or DELETE statement;
>
>> Wow that was so hard I had better go and lay down for a rest.
>
> Not funny.
> You know, that as programmer you might know the solution, but with new
> language you are lost. You have an idea, but cannot build it yet.
> From my previous expireinces, I always get the "rows affected", so
> reading it out here like this is new to.
> Therefore, if you dont know what to look for, it is pretty hard to
> find.
All I did was took the key words from your post. I didn't know the
answer as I have never used odbc in php. I just used a bit of common
sense and thought:
"the guy is using ODBC in PHP and he wants a count of ROWS DELETED"
So I had no more idea of "what to look for" than you did!
In fact:
php odbc rows affected
also works.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]