ID: 14753 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Feedback Bug Type: Oracle related Operating System: Win2000AdvServer PHP Version: 4.1.1 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2001-12-29 10:05:03] [EMAIL PROTECTED] run at pl/sql developer: /++++++++++++++++++++++++++++++++++++++++++++++++++++++++++/ SQL> select * from pt_smsojb_temp; PT_SMSOBJ_TEMP_ID PT_SMSOBJ_TYPE PT_SMSOBJ_ID PT_SMSOBJ_MOBI PT_SMSOBJ_USER_ID PT_SMSOBJ_NAME ----------------- -------------- ------------ -------------- ----------------- -------------------- 27 u 11 13900000002 1 陈庭昀 28 u 1 13950362526 1 叶建斌 29 o 1 13900000005 1 大头 26 u 10 13900000001 1 林应广 30 o 2 13959355539 1 王大霖 31 o 3 13959344539 1 王小霖 32 o 4 13900000006 1 李华 33 o 5 13900000007 1 李大华 34 o 6 13900000037 1 李小华 35 o 7 13900030037 1 李不华 36 o 8 13933030037 1 李林华 37 o 9 13933330037 1 李林林 12 rows selected /++++++++++++++++++++++++++++++++++++++++++++++++++++++++++/ my php code /++++++++++++++++++++++++++++++++++++++++++++++++++++++++++/ <html> <head> <title>列表</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <link rel="stylesheet" href="../style.css" type="text/css"> </head> <body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0"> <? $connection=Ora_pLogon("ptsms@doone","ptsms123"); $cursor=Ora_Open($connection); <form name="sendmore" method="post" action="sendtoobj.php?action=more" target=center_w> <? $query="select * from pt_smsojb_temp"; Ora_Parse($cursor,$query); Ora_Exec($cursor); while(Ora_fetch($cursor)) { ?><input type="checkbox" name="member[]" value="<?echo Ora_getcolumn($cursor,0);?>" checked><?echo Ora_getcolumn($cursor,5);?>[<?echo Ora_getcolumn($cursor,3);?>]<br> <? } ?> </form> </body> </html> /++++++++++++++++++++++++++++++++++++++++++++++++++++++++++/ It will display 12 records sometimes or 13 records sometimes when I refresh the web,but it should display 13 records. Why? I used the function Ora_commit when I insert a record to database in php. It's my code. <? $query="insert into pt_smsojb_temp (PT_SMSOBJ_TEMP_ID,PT_SMSOBJ_TYPE,PT_SMSOBJ_ID,PT_SMSOBJ_MOBI,PT_SMSOBJ_USER_ID,PT_SMSOBJ_NAME) values (pt_smsojb_temp_id.nextval,'u','$PT_SMSOBJ_ID','$PT_SMSOBJ_MOBI','$userid','$PT_SMSOBJ_NAME')"; Ora_Parse($curor,$query); Ora_Exec($curor); Ora_commit; ?> ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=14753&edit=1
