[PHP-DB] big/small letters with oracle

2004-06-01 Thread Torsten Lange
Hello, I want to automatically generate a select list, where a user can select all measurement parameter, lets say Na, Mg, Cl and Si as (s)he likes. For instance I have a specific spring and all chemistry parameter are saved in one table. For our Oracle9iDB, this parameter select list can be

[PHP-DB] big/small letters with oracle No2

2004-06-01 Thread Torsten Lange
But when using queries on the USER_... data dictionary, Oracle delivers always big letters, which is for chemical elements (NA vs. Na) or location names (ALICE SPRINGS vs. Alice Springs) and location codes often uncomfortable to read. It happend in the heat of the moment... The above is only

Re: [PHP-DB] Drop-down box in php

2004-04-20 Thread Torsten Lange
I use html forms with select field size 1 and the option values and/or what is supposed to appear in the box. This you populate by your DB query, maybe using an array and a loop (from 0 to ..). Torsten andy amol schrieb: hi, I would like to know how to create and populate drop down boxes in

[PHP-DB] ocistatement

2004-03-05 Thread Torsten Lange
Hello, I receive an array from an OCIFetchStatement() and want to address its elements by indices, which fails. The original select has two columns. How do I have to visualize that array? I want to load it into an option list. I tried also some examples with while(list...), but it can not work

Re: [PHP-DB] SELECT

2004-03-04 Thread Torsten Lange
peppe schrieb: for ($row =1; $row = $numRows; $row++) { $rowArray = mysql_fetch_array($result); $access1 = $rowArray[1]; Hi Peppe, although I don't know the function mysql_fetch_array()... why you use $rowArray[1], which is the first element (if $rowArray is of type array).

Re: [PHP-DB] global variables

2004-03-02 Thread Torsten Lange
Yes agreed - but you cannot store them in a variable because they will be lost each time the page reloads. Why not store them in a cookie? Hello Davey, thank you for help! I now don't use a cookie but added a column for this purpose in my usertable in the db. Torsten -- PHP Database Mailing

[PHP-DB] global variables

2004-03-01 Thread Torsten Lange
Hi, I build a small web interface to a database. I include into the index.php the filepaths and a manage.php: #index.php ?php session_start(); $base_path = /.../; include('manage.php'); ? In manage.php I include the variables.php and the functions.php and then decide on the status of a variable

Re: [PHP-DB] global variables

2004-03-01 Thread Torsten Lange
Richard Davey wrote: You don't check $v_dec in your manage.php script though, you check to see if $page_no is set which it never will be, because no-where do you give it a value. Thanks Davey, but is $page_no not set every time (see below) or did you mean that I must rather use

Re: [PHP-DB] global variables

2004-03-01 Thread Torsten Lange
Hello Devey, $v_dec[page_no] = $page_no; Which means that $v_dec will always equal nothing, because at the point at which the file is included, $page_no hasn't been set to anything at all. You mean this will unset $v_dec[page_no]? This explains why at reload of index.php happens what happend.

[PHP-DB] oracle: fetch a query result into an array

2004-02-18 Thread Torsten Lange
Hello, I'm a php beginner and not succeed in fetching an oracle query result into an array. I want to load the colum names of a table (from an Oracle9i) into a select-field. There is something working, but only the last column name appears in the select field and is wraped by each letter. For