[PHP-DB] sybase with php4.1 and apache 13.20 problem

Hello, I've got problem with working php 4.1.0 under apache 13.20 with Sybase SQL. I installed Sybase ASE 11.0.3 with Open Client Lib and developt part and compiled php 4.1. with sybase support ( FreeBSD 4.4) as a apache module and usual executable file. # ./configure --with-sybase=/usr/home/syb

RE: [PHP-DB] sybase with php4.1 and apache 13.20 problem

So if I understand you correct you can call Sybase from php on commandline but not via apache? You should compile --with-sybase-ct but that is probably not causing your problem. Sounds strange, never had that problem, if it worked on cli it worked in Apache. What errormessage are you getting fr

[PHP-DB] load text file

Hi, I prefer to used load data infile command to insert text file (CSV format) to MySQL. I wonder that Could load data use with pure text file (no delimiter)? if not how to insert text file in to MySQL faster than read every line? SF -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Concept help required

George, > > =As a general comment, it is always dangerous to "replicate" when shifting > platforms, better to reverse engineer > > and then implement anew and taking advantages of the strengths of the new > tools. This particularly when moving > > into the relational field... > Perhaps the use of

RE: [PHP-DB] Re: Array not supported for strings???

> -Original Message- > From: Andy [mailto:[EMAIL PROTECTED]] > Sent: 04 January 2002 20:24 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: Array not supported for strings??? > > $stmt= " > SELECT country > from $DB2.$geo_T1 > where country_code = '$country_id[$i]' >

Re: [PHP-DB] Concept help required

DL Neil (I presume you have a first name tucked away inside there), Your comments are appreciated. I am becoming more and more comfortable with what I am doing with MySQL/PHP. With reference to the 3-box trick, I thought that the bulk of my work would be inthe centre box but as you point out tha

RE: [PHP-DB] Oracle date conversion

> -Original Message- > From: David C. Norris [mailto:[EMAIL PROTECTED]] > Sent: 26 December 2001 17:00 > > Oracle DATEs are retrieved (by ora_fetch_into($cursor, $row, > ORA_FETCHINTO_NULLS), for example) as plain dates (e.g., '26-DEC-01'), > losing the time of day (as in '26-DEC-01 12:34

RE: [PHP-DB] oracle connectivity problem

> -Original Message- > From: Rajiv Khandelwal [mailto:[EMAIL PROTECTED]] > Sent: 27 December 2001 10:59 > > hi, > I am facing a strange problem. > I have oracle 8.1.6 (server) installed on linux and am > trying to access > it thru PHP from a client machine (again Linux). > I was succes

RE: [PHP-DB] mysql_num_rows

> -Original Message- > From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] > Sent: 06 January 2002 20:10 > > I am pretty sure that the query is correct. here is the actual query: > $query="select distinct(nodeid), nodename > from books where > bookid=$bookid"; > $r

RE: [PHP-DB] mysql_num_rows

don't know if this makes a difference, but i've always used WHERE bookid = '$bookid'"; - single quote round the $bookid variable - not sure if that's the problem, or if it's just good practice? -Original Message- From: Ford, Mike [LSS] [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 14:0

RE: [PHP-DB] mysql_num_rows

> > -Original Message- > > From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] > > Sent: 06 January 2002 20:10 > > > > I am pretty sure that the query is correct. here is the > actual query: > > $query="select distinct(nodeid), nodename > > from books where > > bookid=$bookid"; >

RE: [PHP-DB] mysql_num_rows

> -Original Message- > From: matt stewart [mailto:[EMAIL PROTECTED]] > Sent: 08 January 2002 14:10 > > don't know if this makes a difference, but i've always used > WHERE bookid = > '$bookid'"; - single quote round the $bookid variable - not > sure if that's > the problem, or if it's ju

Re: [PHP-DB] mysql_num_rows

dont u need to add the $sql to the mysql_query... as in mysql_query($sql,$db); ?? i thourhgt u did ? anyways.. might be wrong. Neil - Original Message - From: Ford, Mike [LSS] <[EMAIL PROTECTED]> To: 'Gurhan Ozen' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 08, 20

[PHP-DB] Re: database/form help needed

Turn your checkboxes into an array And then parse the array when you POST the form while (list($key,$val)=each($id)) { echo "$val"; // this is an id that was checked } // end while The virtue of this is you don't have to check for all possible values (id1, id2, id3, etc), you'll only end

Re: [PHP-DB] mysql_num_rows

Drop the "$result" from the mysql_num_rows() so it reads: $num_results=mysql_num_rows(); Depending upon the PHP version, that might do the trick for you. kind regards, bill Mike Ford wrote: > > -Original Message- > > From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] > > Sent: 06 January 20

[PHP-DB] mysql.so

Hello all, I'm trying to recompile PHP, I downloaded V4.1.1 and wanted to move from my old 4.0.6 to it. I have a RH 6.2, btw. I had mysql.so, oci8.so and a couple more libraries. I think I had downloaded them from rpmfind or similar site. How do I recompile them to work with PHP 4.1?

RE: [PHP-DB] oracle connectivity problem

It sound like you have Oracle installed on one machine and are attempting to connect to it from another machine. If this is the case you may need to install the client libraries on the machine that does not have oracle installed. I recently did some development for a client in Windows and rece

Re: [PHP-DB] mysql.so

Old modules (compiled for php 4.0.x) are not binary compatible with 4.1.x series. To compile oci8.so you need an oracle installation. More info on oracle from Thies Arntzen. I'm not sure but ./configure --enable-mysql && make will produce the .so Regards, Andrey Hristov - Original Message -

[PHP-DB] adding $ to my file

Hi All I am trying to add this to a file on my system $var = $string_submited_by_form All i get when i run the script is an input to my file like this = string_submited_by_form whithou the $var at the beging Can anyone please help. Thanks in Advance Dave C The two rules for success ar

RE: [PHP-DB] adding $ to my file

try addslashes() function -Original Message- From: Dave Carrera [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 12:05 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] adding $ to my file Hi All I am trying to add this to a file on my system $var = $string_submited_by_form All i

[PHP-DB] Trouble with "date" column

Hello, My boss is going through the mysql.com tutorials starting at ... http://www.mysql.com/articles/ddws/12.html ... and currently stuck at ... http://www.mysql.com/articles/ddws/13.html The boss is using phpMyAdmin to access the database, and everything has been working just fine

Re: [PHP-DB] Concept help required

George, > DL Neil (I presume you have a first name tucked away inside there), =David > Your comments are appreciated. I am becoming more and more comfortable with > what I am doing with MySQL/PHP. =I have found it to be an excellent combination (even on Windows) and have used them as the mean

[PHP-DB] count query

Is it posible to do a count(*) on a tabe where id=2 and count just those that id = 2

Re: [PHP-DB] count query

Barry, Is it posible to do a count(*) on a tabe where id=2 and count just those that id = 2 =why don't you try it? The answer is yes, because count(*) means count the entire number of non-null rows selected. See manual: 3.3.4.8 Counting Rows =dn -- PHP Database Mailing List (http://www

Re: [PHP-DB] count query

Hi, SELECT SUM(IF(id = '2',1,0)) AS field_name FROM table Versatile command - you can use it for quite a lot of things. Barry Rumsey wrote: > Is it posible to do a count(*) on a tabe where id=2 and count just those that id = >2 -- -- Dan Barton Terrestrial Program Biologist Asst. D

Re: [PHP-DB] Concept help required

For DL Neill: Like the "3 box" approach. A very strong image for separating the functionality. Why don't you write it up as an article for DevShed or WebMonkey? If you look at the traffic on the list there are lots of people who just see PHP pages as "happening" and have no clear understandi

[PHP-DB] Re: Pulling a long list of data stalls PHP

Miles, you wrote: >Is your table indexed on the field your query is based on? That will >greatly speed up the query. > >Miles Thompson I'm afraid in my case, the query needs to be pretty much a complete table dump. Even if I filter a subset the data, my relational DB experience (not deep, ad

Re: [PHP-DB] Re: Pulling a long list of data stalls PHP

Peter, That's not right, but please forgive me if there is some background I've misplaced and I'm asking "old" questions. What OS are you on? What database? (I'm assuming MySQL, just because it's so common.) What version of the database? What version of PHP? Can you execute your SELECT at t

Re: [PHP-DB] Re: Pulling a long list of data stalls PHP

Something more ... 1. Put something like this in your code where you execute the query $ result = mysql_queyr($sql) or die( mysql_errno()." : ".mysql_error()); 2. If the query is succesful, just dump the result w/o any formatting, just in case the problem's there. (Shouldn't be with IE, it's re

[PHP-DB] mail() function

Hi all, I use mail() function to send automatic email to me but when I receive the email, I found that send date is not correct (send date is in future) How do I correct this problem I use PHP 4.1.0 platform win98se apache 1.3.22 Thanks -- PHP Database Mailing List (http://www.php.net/) To u

Re: [PHP-DB] Re: Pulling a long list of data stalls PHP [_SOLVED_]

Thanks to Miles! The problem, for anyone who is going through this themselves lay (in my case) with my php.ini file - evidently my fat fingers copied the 'recommended' php.ini file, instead of the 'distro' php.ini file. The 'Recommended' file contains a few optimizations and security patches,