[PHP-DB] mssql_fetch_array problem

hello all, hope someone could help me it seems that the mssql_fetch_array did not work as it should when the data type to be fetch is an integer ... is there any work around for this? Below is my script ... $country_sql = select countryname, countryid from TBL_COUNTRY; if

[PHP-DB] Informix blobs problem -609 / core dump

Hi. When trying to insert anything into a BLOB column in informix I get a -609 error back (invalid use of TEXT/BYTE host variable), no matter what parameters used when ifx_create_blob'ing. Inserting into TEXT columns does work OK. When trying to read anything from a TEXT or BLOB column, php

[PHP-DB] Query in a function

Hello I have a query that I have placed in a function that is in a file that I include in the page to be displayed. It doesn't work. I know that the code works because when I place the code in the page to be displayed directly it works fine. I can't figure it out. Thanks in advance for any help.

RE: [PHP-DB] mssql_fetch_array problem

Hi Jennifer, … I think that you want to display the Countryname in the DropDownBox, won't you ? Try this one (in your while-loop): if ($country == $myrow[countryid]) { print option value= . $myrow[countryid] . selected . $myrow[countryname] . /option . \n; } else {

RE: [PHP-DB] mssql_fetch_array problem

Not being able to see your code and not knowing exactly what problem you are having I can only throw a few guesses here. If you could elaborate more on what you are expecting and what you are getting that would be a big help. snip $country_sql = select countryname, countryid from TBL_COUNTRY;

[PHP-DB] PHP and MRTG

Is anyone out there using PHP in conjunction with MRTG? I'm currently looking for a PHP script that analyzes a MRTG log file and generates the image Kveðja / Regards == Guðmundur Örn Ingvarsson Chief technician of daily operations / Rekstrarstjóri á

[PHP-DB] mysql client compression with php?

Hi, I have to connect my php server to a remote mysql database and would like to minimize the bandwidth usage. Adding a setting in my.cnf as follows only seems to affect the mysql client applications and not php. [client] compress I have noticed a define in the php sources called

Re: [PHP-DB] Query in a function

errr maybe you need to pass the function the values of the variables you are using either by declaring them global inside the function: global $server,$user,$pass,$type_id; or passing them to the function directly: function type_select($server,$user,$pass,$type_id) hope this helps :-)

[PHP-DB] php accessing oracle

I want to make a query from a oracle database with php. That's what I do: $link=Ora_Logon(user,1234); $query = select * from sales; $cursor = ora_do($link,$query); while(ora_fetch($cursor)) { print $cursor; } I have an arror, it's doesn't recongnize ora_logon() function. Do i have to

Re: [PHP-DB] One quick favor!!!!!!

Each '%20' is a URL-encoded space character. In other words, the string you are getting back from your database query looks like 'fruit '. I suspect you coded the field as a fixed-length string. The best long-term fix is to change the field type to a variable-length string, so that

Re: [PHP-DB] mssql_fetch_array problem

try: if ($country == intval($myrow[countryid])) mssql_fetch_array is found to have some weird behavior. On Tue, 19 Jun 2001, Jennifer Arcino Demeterio wrote: hello all, hope someone could help me it seems that the mssql_fetch_array did not work as

Re: [PHP-DB] mssql_fetch_array problem

Hello!!! Try using the second argument of mysql _fetch_array MYSQL_NUM This will insure that an integer is used.. If not let me knowI'll do testing... Dan Brunner On Monday, June 18, 2001, at 11:18 PM, Jennifer Arcino Demeterio wrote: hello all, hope someone could

[PHP-DB] products

I am pulling some products out of my database (doing some other things to it), but basically making a big array. Now, if I want to set my quantity to zero, and remove every instance where the $iID is, i should be able to do : if($cart[num_items] == 0) {

[PHP-DB] Informix question

Hi all, I'm writing an application which uses the PHP interface to informix. I'm having trouble with newlines in char/varchar or lvarchar fields. How can I store newlines (\n) to an informix database without using blobs? I'm using: -- Bård Farstad Systems developer ez.no | developer.ez.no |

[PHP-DB] Why?

Why do I recieve, but cannot post. I keep getting permanent errors from the mailer daemons. Sorry, I don't have a copy of the last one, but I don't think this message will go through Chadwick Rolfs -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] Query in a function

At 19.06.2001 09:21, you wrote: Hello I have a query that I have placed in a function that is in a file that I include in the page to be displayed. It doesn't work. I know that the code works because when I place the code in the page to be displayed directly it works fine. I can't figure it out.