rowid

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aradhanathawait
    New Member
    • Mar 2008
    • 36

    rowid

    hi all

    I tried to update a record using its rowid in php. But it is not showing as it shows in the backend. and therefore update is not working . Please help ..

    Thanx and regards,
    Aradhana
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    Post your code ... using code tags.

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      why you need to use rowid to update any record.

      Rowid is not designed for that purpose.

      Comment

      • aradhanathawait
        New Member
        • Mar 2008
        • 36

        #4
        Originally posted by r035198x
        Post your code ... using code tags.

        <? require_once("p enclass.php");

        $myq = "select pensioner_name, rowid myrowid from b_register where mir_no=20051030 0";

        $rst = db_query($GLOBA LS['dbconn'],$myq);

        $fet = db_fetch_array( $rst);

        print $fet['pensioner_name '].$fet['myrowid'];

        ?>

        It displays rowid as Object id #1

        Please guide how to obtain the rowid as it is shown in backend

        Regards,
        Aradhana

        Comment

        • amitpatel66
          Recognized Expert Top Contributor
          • Mar 2007
          • 2358

          #5
          Originally posted by aradhanathawait
          <? require_once("p enclass.php");

          $myq = "select pensioner_name, rowid myrowid from b_register where mir_no=20051030 0";

          $rst = db_query($GLOBA LS['dbconn'],$myq);

          $fet = db_fetch_array( $rst);

          print $fet['pensioner_name '].$fet['myrowid'];

          ?>

          It displays rowid as Object id #1

          Please guide how to obtain the rowid as it is shown in backend

          Regards,
          Aradhana

          Why you need to use a ROWID for an UPDATE?...why not a primary key column?

          Comment

          Working...