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
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
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
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
-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]'
;
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
-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').
-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
-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;
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
-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;
-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
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
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
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
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?
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
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
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
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
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
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
Is it posible to do a count(*) on a tabe where id=2 and count just those that id = 2
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
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.
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
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,
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
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
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
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,
31 matches
Mail list logo