Hi All,
Has somebody made a connection from PHP (4.2.2) running on Linux os to a
Ms SQL database running on a W2K machine. If so how have you done that?
Where can I find some kind of tutorial or howto?
Cheers, Rene.
===
R. Groothuis - Aeqis
Gruttosingel 50
I guess it is just like connecting to the database
at your local machine .
Check security on wk2 so you are allowed to connect.
Jochem
Rene Groothuis wrote:
Hi All,
Has somebody made a connection from PHP (4.2.2) running on Linux os to a
Ms SQL database running on a W2K machine. If so how
Well, I'm not sure if you actually truly mean unlimited, because if
you do, be aware that when you define those fields:
# BIGINTUNSIGNED = 8 Byte = =
18446744073709551615
# INT UNSIGNED = 4 Byte = = 4294967295
# MEDIUMINT UNSIGNED = 3 Byte = FF =
Hi,
You might want to try something like:
SELECT ads_displayrate.name, SUM(ads_displayrate.count) as display, SUM(
IF( ads_clickrate.date IS NULL, 0, 1 ) ) as click FROM ads_displayrate LEFT
JOIN ads_clickrate ON ads_displayrate.name = ads_clickrate.name
HAVING YEAR(ads_displayrate.date) =
Should work (provided that the HAVING clauses be written after the GROUP BY)
But less efficient. The point of using the WHERE clauses is to restrict
during the JOIN. What you propose amounts to joining the full left table,
which may be very expensive, especially in the case of web log data.
Hi All,
I am currently building a website for a cinema - and a cinema week runs from Thursday,
to Wednesday.
I need some help with how to get PHP to work with one week periods, but having the
week starting on a Thursday, instead of Sunday, or Monday.
The week will be used to generate dynamic
The simplest seems to store the date normally in the DB.
When you need your special Cinema date, just do a modulo 7:
myDayOfWeek = ( WEEKDAY( '2003-01-17' ) + 3 ) % 7
HTH
Ignatius
- Original Message -
From: Matthew Nock [EMAIL PROTECTED]
To:
Hi to all
Being new to PHP I am naturally experiencing some minor problems.
I have a form which processes Ref and Chassis data, when I load Add.php
which does work but on loading get errors
Notice: Undefined index: Ref in C:\Xitami\webpages\add.php on line 22
Notice: Undefined index: Chassis in
Friends,
I have a RedHat 7.3. I am having problems to send email. I know, I must
config the php.ini. What are the configurations, that i need to setup?
My php.ini has an smtp entry, but no sendmail or qmail is running on the
local machine. Do I have to have one running? I wish I did not have to
Thank you!But the oracle client is too big to fix my box.My box is P575+24M
RAM and can't run X-windows and don't have a CD-ROM driver.:(
Are there any simple ways such as to copy the library needed?
Jadiel Flores [EMAIL PROTECTED] дÈëÏûÏ¢ÐÂÎÅ
:[EMAIL PROTECTED]
You have to install the Oracle
It does not appear that you have posted the code from the add.php page in
your original post (below). From the error messages you provided, that seems
to be where the error is happening. You'll need to post the add.php code and
identify line #23 for us to be able to help.
-Original
Hi Antônio Pires de Castro Jr.,
Friends,
I have a RedHat 7.3. I am having problems to send email. I know, I must
config the php.ini. What are the configurations, that i need to setup?
The path to your sendmailwrapper. I think in the case of qmail you have
to write
MySQL cannot find the username in its grant tables.
The error message very clearly states that there is no user named
'x,@host' which is the value of your $user variable. For your example,
$email == 'x' and $femail == '@host'. The comma is included because it
is part of the literal string,
How can i join two strings.
My code is something like:
$valor1=bruno;
$valor2=Pereira;
$valor=$valor1 + + $valor2
Can someone help me. Thanks.
Cumprimentos
Bruno Pereira
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
with a dot
$valor=$valor1 . . $valor2
:-)
-Original Message-
From: Bruno Pereira [mailto:[EMAIL PROTECTED]]
Sent: woensdag 15 januari 2003 15:48
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] Concatenate two strings
How can i join two strings.
My code is something
-Original Message-
From: Bruno Pereira [mailto:[EMAIL PROTECTED]]
Sent: 15 January 2003 14:48
How can i join two strings.
My code is something like:
$valor1=bruno;
$valor2=Pereira;
$valor=$valor1 + + $valor2
Can someone help me. Thanks.
On Wed, 15 Jan 2003 14:47:59 -
Bruno Pereira [EMAIL PROTECTED] wrote:
How can i join two strings.
My code is something like:
$valor1=bruno;
$valor2=Pereira;
$valor=$valor1 + + $valor2
$valor=$valor1 . . $valor2;
See http://www.php.net/manual/pt_BR/language.operators.string.php
I am using Netware 6 as an LDAP server and running Apache PHP 4.2.2 on a
linux Redhat 7.2.
For some reason when I do a wildcard (ou=*) LDAP_SEARCH I only get part of
the directory.
I then did a LDAP_SEARCH on the CNs in the OUs that the LDAP_SEARCH did not
find, and the
LDAP_SEARCH found all the
hello,
i am trying to do the following:
case login:
$connection = mysql_connect($host, $user,$password) //15
or die (Couldn't connect to server.);
$db = mysql_select_db($database, $connection)
or die
?
//This is lines 22 and 23 of Add.php
require(common.php) ;
GenerateHTMLForm();
$smt2= $_POST['Ref']; //line 22
$smt3=$_POST['Chassis']; //line 23
The form below is in common.php
function GenerateHTMLForm() {
printf(FORM action=\add.php\ METHOD=post);
printf(TABLE border=\0\ width=\100%%\);
I have a question about using DATE_ADD in MySQL. I am not sure if
this is the most effective way of dealing with this problem so I am asking
here. The situation is that I am working on modifying a calendar system for
our use. Our On-Call rotation is such that when someone is On-Call
Is there any way to receive mail via PHP?
What I am interested in doing is creating a double opt-in e-mail list
whereby someone can subscribe to an e-mail service via an on-line form. Upon
doing so, they would get a confirmation e-mail. Replying to this e-mail
would confirm the subscription and
[snip]
if ($dateDiff == 3) {
mysql($DBName,UPDATE Balances SET CompEarned=CompTaken+8 WHERE
said='$said') or die(mysql_error());
mysql($DBName,INSERT INTO Log VALUES('DATE_ADD($StopDate,
INTERVAL 1 DAY','',1,2,'$CalendarDetailsID')) or die(mysql_error());
My big question is about using the
I would say this can be done (-:
Run a quck search on freshmeat.net, sourceforge.net,
of course the manual http://www.php.net/manual/en/ref.mail.php,
and http://www.hotscripts.com/, just to name a few places to start. Or
just search for mailing list php on Google.
There are a ton of mailing
[snip]
if ($dateDiff == 3) {
mysql($DBName,UPDATE Balances SET CompEarned=CompTaken+8 WHERE
said='$said') or die(mysql_error());
mysql($DBName,INSERT INTO Log VALUES('DATE_ADD($StopDate,
INTERVAL 1 DAY','',1,2,'$CalendarDetailsID')) or die(mysql_error());
My big question is about
Is there any way to receive mail via PHP?
What I am interested in doing is creating a double opt-in e-mail list
whereby someone can subscribe to an e-mail service via an on-line form.
Upon
doing so, they would get a confirmation e-mail. Replying to this e-mail
would confirm the subscription
Quite doable.
Check the IMAP functions.
Ignatius
- Original Message -
From: Baumgartner Jeffrey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 15, 2003 5:19 PM
Subject: [PHP-DB] Mail() and replies
Is there any way to
Fred,
I don't have much time today, but here is my initial assessment of what
might be going wrong with your page:
You display add.php which draws a form for data.
You submit that form to add.php (itself).
The form redraws inside the page.
You get errors when add.php looks for data in the
Thanks. I was noticing that it was not working. Let me give this a
try and see how things go.
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 10:32 AM
To: 1LT John W. Holmes; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Actually this is generating another error. Now, without the single
quotes I am getting the following error:
Column 'StartDate' cannot be null
It looks like for some reason the DATE_ADD is returning a NULL
value. Any more ideas?
-Original Message-
From: 1LT John
Hi All..
Quick q here as I cannot remember how to prevent this.
Customer is entering their name in a form that get submitted.
Their name is: Mike O'Neill
But their name is being entered like: Mike O\\\'Neill
This is causing his info not to be saved. How do I prevent this?
Any
here are the files to make add.php work. thanks to Richard Hutchins for his
answer, that I do not yet understand:-)
Fred Wright [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi to all
Being new to PHP I am naturally experiencing some minor problems.
I have a
stripcslashes (string str)
Ric
-Original Message-
From: Aaron Wolski [mailto:[EMAIL PROTECTED]]
Sent: 15 January 2003 16:38
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Slashed being added..
Hi All..
Quick q here as I cannot remember how to prevent this.
Customer is entering their name
On Thursday 16 January 2003 00:55, NIPP, SCOTT V (SBCSI) wrote:
Actually this is generating another error. Now, without the single
quotes I am getting the following error:
Column 'StartDate' cannot be null
It looks like for some reason the DATE_ADD is returning a NULL
value.
On Thursday 16 January 2003 01:15, Richard Allinson wrote:
stripcslashes (string str)
Ric
-Original Message-
From: Aaron Wolski [mailto:[EMAIL PROTECTED]]
Sent: 15 January 2003 16:38
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Slashed being added..
Hi All..
Quick q here as I
Couldn't you use the 'for each' method on $_POST instead?
.b
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]]
Sent: 15 January 2003 16:44
To: 'Fred Wright'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: Undefined index and variables
Fred,
I don't have
Of course, but that would solve the problem I have, albeit it would look
more elegant. Have tried everything except the solution which I cannot find,
see the zip file earlier up the list from Fred Wright
Ben Joyce [EMAIL PROTECTED] wrote in message
I need to essentially take a query and make it into a table. I'll first
settle for the ability to export the query into a text file, somehow
delimited.
Can anyone help me with this?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
mysql($DBName,UPDATE Balances SET CompEarned=CompTaken+8 WHERE
said='$said') or die(mysql_error());
mysql($DBName,INSERT INTO Log VALUES(DATE_ADD($StopDate,
INTERVAL 1 DAY,'',1,2,'$CalendarDetailsID')) or die(mysql_error());
Actually this is generating another error. Now, without
How can I query this characters 'áéíóúÁÉÍÓÚñÑ' from a MSSQL DB with PHP???
Actually I obtain this: ' '¡¢£µÖà餥'!!!
Thanks
Fernando Bernain
Senior A
Business Process Outsourcing
KPMG Argentina
Tel: 54 11 4316 5754
Fax: 54 11 4316 5734
[EMAIL PROTECTED]
Email Disclaimer
The
OK, I cannot figure out why I keep getting errors about Duplicate
entry for key 1. Someone please come to my rescue here as this is truly
kicking my but.
if ($dateDiff == 2) {
mysql($DBName,INSERT INTO phpCalendar_Details VALUES (
'$said','Comp day for weekend
I have an application that records DNA fingerprints(gel images) in
digital form in a MySQL Database. Each fingerprint consists of an array
of 2000 values between 0-255 that represent a grayscale color. I use the
code below to create an image or fingerprint from the data.
code
The images were stripped on my post but here's an external link to the
images I refer to:
Sample1 : http://linux.diversilab.com/sample1.gif
Sample2 : http://linux.diversilab.com/sample2.gif
Thanks,
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Problem solved with
//Init variables
$HTTP_POST_VARS['Ref']=A;
etc
Thanks guys for your help
:-))
Fred Wright [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi to all
Being new to PHP I am naturally experiencing some minor problems.
I have a form which
Hi.
Just upgraded my Oracle installation from 8.1.7.3 to 8.1.7.4.
From that moment on, apache/php will not start (just hangs).
Tried 'make'ing Apache and php again but same result.
Checked oracle variables, etc and all seem to be okay (it was working fine).
Any help much appreciated since
Hello
everybody!!!Here am I again with problems... :-( This time I programmed
severan php scripts embebed with HTML, but the curiosity comes when I try to see
the scripts in a browser. In Opera it's ok, but in Mozilla and Internet Explorer
it appears one table on the other, everything
OK, I cannot figure out why I keep getting errors about
Duplicate
entry for key 1. Someone please come to my rescue here as this is
truly
kicking my but.
You have a key or unique column in your table that you're trying to
insert a duplicate value into.
if ($dateDiff == 2) {
I need to essentially take a query and make it into a table. I'll
first
settle for the ability to export the query into a text file, somehow
delimited.
Can anyone help me with this?
What have you done so far? Do you know how to make a table?
While($row = mysql_fetch_row($result))
{ echo
I am currently building a website for a cinema - and a cinema week
runs
from Thursday, to Wednesday.
I need some help with how to get PHP to work with one week periods,
but
having the week starting on a Thursday, instead of Sunday, or Monday.
The week will be used to generate dynamic
On Thursday 16 January 2003 11:43, Sabina A. Schneider wrote:
Hello everybody!!! Here am I again with problems... :-( This time I
programmed severan php scripts embebed with HTML, but the curiosity comes
when I try to see the scripts in a browser. In Opera it's ok, but in
Mozilla and
50 matches
Mail list logo
