rowid

[aradhanathawait]

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]

Post your code ... using code tags.

[debasisdas]

why you need to use rowid to update any record.

Rowid is not designed for that purpose.

[aradhanathawait]

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

[amitpatel66]

<? 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?