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

2002-01-08 Thread Denis GALINSH
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

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

2002-01-08 Thread Richard Hillström (GIS)
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

[PHP-DB] load text file

2002-01-08 Thread Sommai Fongnamthip
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

Re: [PHP-DB] Concept help required

2002-01-08 Thread DL Neil
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 the word

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

2002-01-08 Thread Ford, Mike [LSS]
-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

2002-01-08 Thread George Pitcher
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

RE: [PHP-DB] Oracle date conversion

2002-01-08 Thread Ford, Mike [LSS]
-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:56').

RE: [PHP-DB] oracle connectivity problem

2002-01-08 Thread Ford, Mike [LSS]
-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 successful in

RE: [PHP-DB] mysql_num_rows

2002-01-08 Thread Ford, Mike [LSS]
-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

2002-01-08 Thread matt stewart
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

RE: [PHP-DB] mysql_num_rows

2002-01-08 Thread Ford, Mike [LSS]
-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

2002-01-08 Thread Ford, Mike [LSS]
-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 just good

Re: [PHP-DB] mysql_num_rows

2002-01-08 Thread Neil Thomson
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, 2002

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

2002-01-08 Thread bill
Turn your checkboxes into an array input type =checkbox name=id[] val=?php echo $thisid ? 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

Re: [PHP-DB] mysql_num_rows

2002-01-08 Thread bill
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 2002

[PHP-DB] mysql.so

2002-01-08 Thread Andrea Trasatti
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

2002-01-08 Thread Stephen Abshire
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

Re: [PHP-DB] mysql.so

2002-01-08 Thread Andrey Hristov
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

2002-01-08 Thread Dave Carrera
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

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

2002-01-08 Thread Rick Emery
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

2002-01-08 Thread Nally, Tyler G.
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

Re: [PHP-DB] Concept help required

2002-01-08 Thread DL Neil
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 means

[PHP-DB] count query

2002-01-08 Thread Barry Rumsey
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

2002-01-08 Thread DL Neil
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

Re: [PHP-DB] count query

2002-01-08 Thread Daniel Barton
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.

Re: [PHP-DB] Concept help required

2002-01-08 Thread Miles Thompson
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 understanding

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

2002-01-08 Thread Peter Westergaard
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,

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

2002-01-08 Thread Miles Thompson
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

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

2002-01-08 Thread Miles Thompson
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

[PHP-DB] mail() function

2002-01-08 Thread Osman Omar
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

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

2002-01-08 Thread Peter Westergaard
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,