Page 1 of 1

Error with oracle recordset looping

Posted: Fri Nov 01, 2002 8:56 am
by g_bhagirath
Hi All,
I am new to PHP and at my work we have recently upgraded apache on one of our box and the PHP pages on this server are now running into one perticular type of error.
Below is the error that it is throwing out:
Warning: _oci_open_server: Error while trying to retrieve text for error ORA-12154 in /home/apache/https-drscholls/docs/adodb/adodb-oci8.inc.php on line 120

Fatal error: Call to a member function on a non-object in /home/apache/https-staging2/docs/browse/index.php on line 73
Here is the code from where the error is comming

Code: Select all

49 $cat_ID = $HTTP_GET_VARSї"ailID"];
50 include($app_root . 'browse/cls_browse.php');
51 $obj_template = new Template($app_root . "/browse");						// create a template object named $obj_template
52 $obj_browse	= new browse; 													// create a browse object named $obj_browse

53 $obj_template->set_file("page", "browse_ailment.html"); 					// set page = our template file
54 $obj_template->set_block("page", "myblock", "rows"); 
55 $obj_browse->ailment($cat_ID);
56 $obj_template->set_var("category", $obj_browse->cat_Name);
57 $obj_template->set_var("back_link", "problem.html");
58 $obj_template->set_var("header_pic", "0problem/hd_gotaprob.gif");
59 $obj_template->set_var("sub_header_pic", "");
60 $obj_template->set_var("bubble_boy", $obj_browse->cat_ShortName);
61 $obj_template->set_var("nav_play_img", "../0images/subnav_play.gif");
62 $obj_template->set_var("nav_spa_img", "../0images/subnav_spa.gif");
63 $obj_template->set_var("nav_preg_img", "../0images/subnav_preg.gif");
64 $obj_template->set_var("cat_Desc", $obj_browse->cat_Desc);
65 $obj_template->parse("output", "page", true);								// Append copies of mainpage:
66 while (!$obj_browse->rs->EOF) {
67 $obj_template->set_var("prod_name", $obj_browse->rs->fieldsї1]);		// Set element's value and name:
68 $obj_template->set_var("prod_descrip", $obj_browse->rs->fieldsї2]);
69 $obj_template->set_var("prod_img", $obj_browse->rs->fieldsї3]);
70 $obj_template->set_var("prod_link", "?fuseaction=product&prodID=".$obj_browse->rs->fieldsї0]."&type=ail&ID=".$obj_browse->cat_ID."&prodName=".$obj_browse->rs->fieldsї4]);
71 $obj_template->parse("rows", "myblock", true);							// Append copies of myblock:
72 $obj_browse->rs->MoveNext();
73 }
74 $obj_template->pparse("output", "page");
Since i am new to PHP i am unable to fine the place where its breaking in the code. The version of PHP that its running on is 4.0 .

Can some one help me with this.
Will appreciate any help..

Thanks in advance
Bhagirath